• Length:
    4 Weeks
  • Effort:
    2–3 hours per week
  • Price:

    FREE
    Add a Verified Certificate for $99 USD

  • Institution
  • Subject:
  • Level:
    Intermediate
  • Language:
    English
  • Video Transcript:
    English

Prerequisites

  • A basic understanding of the Business Intelligence process.
  • A basic understanding of database design and storage.

Suggested prerequisites / Supporting Material:

About this course

Skip About this course
Is your data messy? Do you need to learn how to clean it up? In this computer science course, we will discuss the discipline of Data Quality Assurance and Data Quality Services (DQS). You will learn why your data needs cleansing, the capabilities and features of DQS, what a DQS solution looks likes and how data cleansing integrates with an Integration Services (SSIS) data flow. We will demonstrate a variety of critical data quality activities such as knowledge discovery, domain management, matching policies for the de-duplication of data, and administration topics covering installation, configuration and security.

What you'll learn

Skip What you'll learn
  • The discipline of Data Quality Assurance
  • SQL Server DQS capabilities and features
  • Creating DQS solutions
  • The SSIS DQS Cleansing component
  • Matching Policies and Projects
  • Administering DQS

COURSE UPDATE: As of March 31, 2017 the Azure Data Market (ADM) will be retired, and topics discussing Reference Data Services will be removed from this latest course update. No changes will be made to previous course instances.

Module 1

  • Introducing DQS
    • Discipline of Data Quality Assurance
    • SQL Server DQS, overview of capabilities and features; concepts; support by SQL Server version and edition
    • Installation and setup
  • Creating DQS Solutions
    • Knowledge bases; Domains; Composite domains; DQ Projects
    • Exploring an existing solution

Module 2

  • Cleansing Data with DQS
    • Rules; Values
    • Creating a knowledge base to cleanse data in a DQ Project
  • Cleansing Data with DQS in SSIS
    • SSIS DQS Cleansing component
    • Integrating cleansing in SSIS data flow
    • Creating knowledge base, cleanse data in a DQ Project and SSIS data flow

Module 3

  • Matching Data with DQS
    • Matching policies; Matching projects
    • Creating a matching policy, and de-duplicating data in a DQ project
    • De-duplicating data in a DQ Project 
  • Administering DQS
    • Installation; Configuration; Security
    • Install, configure and secure a DQS instance

Module 4

Final Assessment

Meet your instructors

Peter Myers
Consultant, Trainer and Presenter
Bitwise Solutions
Cari Mason
Content Developer
Microsoft
Joey Chemis
Data Scientist and Software Engineer
Microsoft
Oliver Engels
CEO
oh22data AG

Pursue a Verified Certificate to highlight the knowledge and skills you gain $99.00

View a PDF of a sample edX certificate
  • Official and Verified

    Receive an instructor-signed certificate with the institution's logo to verify your achievement and increase your job prospects

  • Easily Shareable

    Add the certificate to your CV or resume, or post it directly on LinkedIn

  • Proven Motivator

    Give yourself an additional incentive to complete the course

  • Support our Mission

    EdX, a non-profit, relies on verified certificates to help fund free education for everyone globally