Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Online Course

Data Cleansing with Data Quality Services (DQS)

Microsoft via edX

(0)
  • Provider edX
  • Cost Free Online Course (Audit)
  • Session Self Paced
  • Language English
  • Effort 2-3 hours a week
  • Duration 4 weeks long
  • Learn more about MOOCs

Taken this course? Share your experience with other students. Write review

Overview

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.

Syllabus

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

Taught by

Peter Myers and Cari Mason

Help Center

Most commonly asked questions about EdX

Reviews for edX's Data Cleansing with Data Quality Services (DQS) Based on 0 reviews

  • 5 star 0%
  • 4 star 0%
  • 3 star 0%
  • 2 star 0%
  • 1 star 0%

Did you take this course? Share your experience with other students.

Write a review

Class Central

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free

Never stop learning Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free