Chapter 17. Creating a Data Quality Project to Clean Data

Exam objectives in this chapter:

  • Build Data Quality Solutions

    • Create a data quality project to clean data.

In Chapter 14 you learned about data quality problems. You also learned how to install and maintain Microsoft SQL Server 2012 Data Quality Services (DQS). It is time to start using DQS to improve the quality of your data.

DQS is a knowledge-driven solution. Therefore, you need to learn how to prepare a knowledge base (KB). Then you use this KB to cleanse data by using data quality projects. In the last lesson of this chapter, you will learn how to profile data with tools other than DQS, such as the SQL Server Information Services (SSIS) Data Profiling task and T-SQL queries.

Lessons in ...

Get Training Kit (Exam 70-463): Implementing a Data Warehouse with Microsoft SQL Server 2012 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.