Summary
In this chapter, we had a quick look at Data Quality Service, which is a part of Microsoft SQL Server 2014. This service provides cleansing based on a Knowledge Base. The data steward can define and maintain Knowledge Bases, and create and modify matching policies. Data quality projects can be created directly from the data quality client tool, from SSIS with the DQS cleansing component, or from the data quality components in the MDS Excel Add-In. DQS is a powerful tool to clean data before loading it into data warehouses, to ensure data consistency, and clean different datasets.
When the quality of data is high, we can use data mining algorithms to identify data patterns and do descriptive and predictive analyses. The next two chapters ...
Get Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
