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

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

---

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

Expertise Level
Intermediate