Master Data Management with SQL Server 2008 R2

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. 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.

In this seminar, we are going to do a brief theoretical introduction to data quality issues. After that, we are going to talk how you can use tools you get with SQL Server 2008 R2 in order to measure data quality. We are going to show some advanced T-SQL queries, usage of Integration Services, UDM cubes and Data Mining for checking the accuracy, completeness, consistency and descriptive statistics of your data. We will focus on finding the root cause for bad data.

Measuring data quality is not enough. On longer terms, you have to manage master data somehow. In the second part of the seminar, we are going to introduce SQL Server 2008 R2 Master Data Services (MDS). MDS is a set of tools and services, including database and Web portal. MDS concepts like MDS Hub, models, including entities, hierarchies and collections, are going to be introduced through examples.

• Data Quality 
  • Problem Definition and Data Quality Dimensions 
  • Completeness 
  • Accuracy 
  • Information 
  • Measuring Data Quality over Time 
• Master Data Services Concepts and Architecture 
  • Master Data Services Hub 
  • Models 
  • Versioning 
  • Master Data Manager Web Application 
  • Importing and Exporting 
• Advanced Problems 
  • String Matching 
  • Merging from Multiple Sources