Course Details

Previous Page


Data Quality Services (DQS) and Master Data Services (MDS)


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number


Overview/Description
DQS can help identify duplicate or invalid data entries and values while automatically correcting them. MDS enables data validation and rules to ensure consistency in your data. In this course, you'll explore both of these technologies.

Target Audience
Data warehouse developers and database administrators who create and manage business intelligence solutions as part of their daily tasks, which include implementing data warehouse databases, extracting and transforming data as part of an ETL solution, and data cleansing

Prerequisites
None

Expected Duration (hours)
1.2

Lesson Objectives

Data Quality Services (DQS) and Master Data Services (MDS)

  • start the course
  • list installation prerequisites
  • install DQS
  • add users to DQ roles
  • describe identity analysis
  • install MDS
  • implement MDS
  • create models, entities, attributes, collections, groups
  • define security roles
  • import and export data in MDS
  • create subscription views in MDS
  • implement DQS and MDS in SQL Server 2014
  • Course Number:
    md_idwm_a18_it_enus