Overview

Understanding and mastering the various Microsoft SQL Server Tools available for Data Quality , Master Data Management , Fuzzy Matching and Enterprise Information Management can be daunting and exasperating. In the hopes of reducing the anxiety and frustration I am providing a practical roadmap using openly available resources and requiring only a few days to complete.

I have reviewed and organized several articles and blog post that would allow you within a few days to master the skills required to utilize several SQL Server 2012 capabilities mentioned above.

From a business perspective where to be covering the following:

Basic

Master Data Management (MDS)

Data Quality (DQS)

Integration (SSIS)

Advanced

Fuzzy Matching(data Deduplication)

Data Profiling (Source analysis against business rules)

Basic EIM

Master Data Services

Nick Barclay: BI-Lingual: MDS Architecture Notes

This article will provide overview of the MDS architecture in support of MDM (Master Data Management)

This article will teach you the steps for implementing Microsoft MDS as well as the tasks required to develop and load a Model. Complete all exercises in order. MDS is the tool Microsoft provide to support creating and maintaining reference data set (Lookup and Code tables) in support of Master Data Management.