Share via

Introduction to DQS and MDS

  • Article

Recently I delivered the Business Intelligence Practice Accelerator for our esteemed partners. During the sessions I realized there was a dearth of information around DQS and LDS which is subsequently leading to diminished usage of the tools. Thats when I decided to collate a few resources and post it for the benefit of all. I must say it was easy to locate resouces owing to a wonderful post by Matt Masson.

This if you’re looking to get started with Data Quality Services (DQS) and Master Data Services (MDS), please leverage these fantastic resources available on Technet. The site includes videos and slides for full day training sessions on both products.

Data Quality Services for SQL Server 2012

  • Data Quality Basics and Introducing DQS: Video | Slides
  • Knowledge Management and Data Cleansing in DQS: Video | Slides
  • Data Matching in DQS: Video | Slides
  • DQS Integration with SSIS: Data Cleansing using SSIS: Video | Slides
  • DQS Integration with MDS: Data Matching using MDS: Video | Slides

Master Data Services for SQL Server 2012

  • Master Data Services Overview: Video | Slides
  • Managing Data Warehousing Dimensions with MDS, Part 1: Video | Slides
  • Managing Data Warehousing Dimensions with MDS, Part 2: Video
  • Data Loading via Entity Based Staging (EBS): Video | Slides
  • MDS Hierarchies and Collections: Video | Slides
  • Business Rules and Workflow in MDS: Video | Slides
  • MDS Model Migration and Upgrade: Video | Slides
  • Security Features and Guidelines in MDS: Video | Slides
  • Eliminate Duplicate Data with the MDS Add-In for Excel: Video | Slides

I hope the above gives you an insight on two of the most wonderful services within the SQL Server 2012 stack. I'll keep this space updated with more information on the 2 tools as and when I get my hands on them.