The data is the key asset of a company. Companies want to gather information from the data; therefore, they start BI projects. However, most of BI projects have to deal with problems with Data Quality (DQ). Data quality can be a huge obstacle for a successful BI project. Of course, line of business applications suffer from poor data quality as well.
Every company has part of the data which is used everywhere, in every transaction, like customers data, products data and similar. Such data is called master data. People who manage master data are often called data stewards. Processes and activities for maintaining master data are known as Master Data Management (MDM). In this course, you are going to learn MDM problems and solutions and introduce Microsoft tools for DQ and MDM, including Data Quality Services (DQS) and Master Data Services (MDS).
This course is intended for data stewards, business intelligence application developers and advanced administrators.
Upon completion of this course, the student will be able to:
- Describe what master data is
- Define master data management activities
- Understand data quality problems
- Install Data Quality Services (DQS)
- Create DQS knowledge base and projects
- Deploy Master Data Services (MDS)
- Manage master data with MDS
- Profile data with SQL Server tools in order to find areas of low data quality
- Control data quality over time
- Merge data from multiple independent sources through identity mapping
- De-duplicate master data
Module 01: Introduction to Data Quality and Master Data Management
Module 02: Installing and Maintaining Data Quality Services (DQS)
Module 03: Installing and Maintaining Master Data Services (MDS)
Module 04: Managing Master Data with MDS
Module 05: Data Cleansing with DQS
Module 06: Data Profiling with SQL Server Tools
Module 07: Identity Mapping and De-Duplicating
Module 08: Data Quality and Master Data Management with Excel
Before attending this seminar, it is recommended that students have at least moderate experience with transactional applications, data warehousing, reporting and On-Line Analytical Processing. The attendees should be familiar with the Transact-SQL language. Knowledge of a .NET language like C# or VB.NET is welcome as well.