Beskrivelse
Kurset henvender sig til data-ansvarlige, Data Stewards og Business Intelligence konsulenter, samt andre der arbejder med data og ønsker at komme igang med Master Data Services.
Der vil være stort fokus på hands-on og øvelser undervejs.
Forudsætninger:
- Generelt kendskab til data og muligvis også Master Data.
- Medbring egen laptop med Master Data Services 2016, SQL Server 2016, Management Studio 2016 og Excel 2013 eller 2015 installeret.
Kursus agenda:
Modul 1: Introduction to Master Data Mangement
-
Master Data Management
-
MDM Services and Data
-
MDM Hub and Patterns
Modul 2: Master Data Services Basics
- Master Data Services Overview
- MDS Architecture
- Requirements
- Installation
- Master Data Services Add-in for Excel
Modul 3: Building a MDS Model
- Models
- Entities
- Attributes
- Leaf and Consolidated Members
- Hierarchies
- Collections
- Model Deployment
Modul 4: Staging and Load
- Loading data to MDS
- Staging Tables
- Stored Procedures for Staging
- Loading data with SSIS
Modul 5: Business Rules
- Why Business Rules?
- Business Rules Components
- Business Rules Architecture
Modul 6: Data Extract
- Subscription Views
- Types of Subscription Views
- Subscription View Maintenance
Modul 7: Security Management
- Who is Secured
- What is Secured
- Permissions
- Guidelines and Best Practices
Modul 8: Real Life MDM/MDS Scenarios
- How can SQL Server and MDS be used in Real Life Scenarios….
- Real Life Scenario 1 (RLS1)
- Real Life Scenario 2 (RLS2)
- Real Life Scenario 3 (RLS3)