Introduktion til MDS

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)

Copyright 2017 Orange Man · RSS Feed · Log ind · Google+

Organic Themes