Overview

Introduction

The Manage Data Quality Project to Clean Data module provides you with the instruction and server hardware to develop your hands on skills in the defined topics. This module includes the following exercises:

  • Install MDS Add-in for Excel
  • View Master Data in Excel
  • Use Data Quality Services to Match MDS Data in Excel

Exercise 1 - Install MDS Add-in for Excel

In this exercise, you will learn the following in Microsoft SQL Server 2012:

  • Install MDS Add-in for Excel

Exercise 2 - View Master Data in Excel

In this exercise, you will learn the following in Microsoft SQL Server 2012:

  • Create an MDS model with data and view the MDS data in Excel

Exercise 3 - Use Data Quality Services to Match MDS Data in Excel

In this exercise, you will learn the following in Microsoft SQL Server 2012:

  • Integrate Data Quality Services with MDS
  • Create a DQS Knowledge base for MDS data
  • Use the DQS matching functionality in the Add-in for Excel to avoid insertion of duplicate data in MDS through Excel

Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.