DQS Training
Microsoft SQL Server Data Quality Services for Data Cleansing & Data Deduplication with Data Quality Client & SSIS tools
Description
The topics which are covered in this online video training course on DQS are
DQS Introduction
DQS Terminologies
DQS Architechture
DQS Installation
Data Cleansing
Data Source used for Demonstration
Domains and Knowledge Base
Cleansing Project
SSIS Package for Data Cleansing
Data Deduplication
Matching Policies
Deduplication Project
Advanced DQS
Term Based Relations
Composite Domains
Creating Regular Expressions Rules in a domain
Domain DataTypes
Import Knowledge Base & Domains
Export Knowledge Base & Domains
Open Delete Rename Unlock Knowledge Base & Projects
Purpose of each DQS Databases
Backup and Restore DQS Databases
DQS Configurations
DQS Activity Monitor
What You Will Learn!
- Creating Domains
- Creating Knowledgebase
- Data Cleansing
- Data Deduplication
- DQS Adminstration
Who Should Attend!
- Beginners who want to learn Microsoft Data Quality Services
- It will be value addition skill for Microsoft BI developers
- Consultants who want to take data cleansing tasks
- IT Students who want to create one quick IT Project and submit to their college
- One or two questions are asked about DQS in Microsoft SSIS Certification exams as well