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