Creating Data Quality and Master Data Management Solutions with SQL Server 2017 MDS and DQS
Course Summary
Training level | Deep Dive |
Duration | 3 days / 24 Hours |
Delivery method | In class |
Level | 300 |
Language | Bulgarian/English |
List price | 650 Euro VAT Excl. |
Click Tabs for Detailed info
In this course, attendees will understand the MDM concepts and how to approach the Master Data and the Data Governance process. They will become familiar with Microsoft tools for Data Quality and Master Data Management – DQS and MDS. Attendees will go trought different scenarios and examples of modeling a master data management solution and developing a data quality process.
- BI developers who have a challenge to design master data solution and improve a data quality of their data
- Data Engineers who want to understand tools and processes of managing master data
- Describe what master data is
- Define MDM activities
- Understand data quality problems
- Create a DQS knowledge base and DQS projects
- Manage master data with MDS
- Perform Data Profling with SQL Server tools
- Control data quality over time
- De-duplicate master data
Module 1. Introduction to Data Quality and Master Data Management
Module 2. MDS and DQS Overview and tools
Module 3. Creating Models and entities
Module 4. Defining Business Rules
Module 5. Model versioning and subscriptions
Module 6. Data Profiling with SQL Server Tools
Module 7. Data Cleansing with DQS and De-Duplicating
Module 8. Integrating MDS and DQS into a data governance process
Next planned dates:
Trainer: Dejan Sarka
Trainer: Margarita Naumova

RESERVE YOUR SEAT
You have a question or you want to book now? Feel free to contact us!
Vili Koleva-Training Manager
E: vili.koleva@inspirit.bg
M: +359 (885) 113 442
