Course Code: 1200

55073 Master Data Services, Data Quality Services with SQL 2012-2014 and Excel

Class Dates:
2/23/2022
4/27/2022
Length:
3 Days
Cost:
$1495.00
Class Time:
Technology:
Database
Delivery:
Instructor-Led Training, Virtual Instructor-Led Training

Overview

  • Course Overview
  • Change - Service Descriptive Changes Microsoft 611420 55073 Master Data Services, Data Quality Services with SQL 2012-2014 and Excel .

  • Audience
  • This course is intended for SQL Professionals, Business Intelligence Developers, Data Analysts and Data Stewards and Project Managers that need to learn how to utilize Master Data Services.

Prerequisites

  • Basic computer skills, knowledge of Excel.

Course Details

  • Module 1: COURSE OVERVIEW
  • Introduction
  • Course Materials
  • Facilities
  • Prerequisites
  • What We'll Be Discussing
  • Lab : COURSE OVERVIEW
  • Module 2: MASTER DATA MANAGEMENT CONCEPTS
  • What is Master Data Management?
  • The Need for Master Data Management
  • Data Quality
  • Master Data vs. Transactional Data
  • Master Data Management Team
  • Master Data Management Architectures
  • The MDM Extract-Transform-Load
  • Lab : MASTER DATA MANAGEMENT CONCEPTS
  • Module 3: MICROSOFT MASTER DATA SERVICES OVERVIEW
  • Project Implementation
  • Master Data Services Key Terms
  • Master Data Services Web Interface
  • Installing Master Data Services
  • Lab : MICROSOFT MASTER DATA SERVICES OVERVIEW
  • Module 4: UNDERSTANDING DATA MODELS
  • Modeling Process
  • MDS Object - Model
  • The Model Object
  • Lab : UNDERSTANDING DATA MODELS
  • Module 5: IMPORTING DATA
  • MDS Entity-Based Staging
  • Lab : IMPORTING DATA
  • Module 6: VERSION MANAGEMENT
  • Understanding Versions
  • Web Interface
  • Version Statuses
  • Copying a Version
  • Locking. Unlocking and Committing Versions
  • Version Flags
  • Ancestry
  • Validating Versions
  • Lab : VERSION MANAGEMENT
  • Module 7: BUSINESS RULES
  • Business Rules Overview
  • How to Create a Business Rule
  • Conditions and Actions
  • Publish a Business Rule
  • Validation Issues
  • Lab : BUSINESS RULES
  • Module 8: MDS SECURITY
  • Master Data Services Security Overview
  • Users and Groups
  • Administrators
  • Permission Levels
  • Best Practices
  • Lab : MDS SECURITY
  • Module 9: PUBLISHING DATA
  • Subscription Views
  • Formats
  • How Subscribing Systems Can Extract Data
  • Creating Views
  • Lab : PUBLISHING DATA
  • Module 10: EXCEL ADD-IN
  • Creating Connections
  • Publishing Data
  • Filtering Data
  • Saving a Query
  • Create an Entity From Data
  • Settings
  • Lab : EXCEL ADD-IN
  • Module 11: DATA QUALITY SERVICES
  • Architecture
  • Data Quality Cleansing
  • Microsoft Data Quality Solution
  • Lab : DATA QUALITY SERVICES