Tilbud

Introduktion til Master Data Services

Underviser
Start
september 30, 2019 09:00
Slut
september 30, 2019 16:00
Adresse
Frederiksgade 71, 8000 Aarhus C.   Vis kort

4.500 DKK 3.500 DKK

Status

Detaljer

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)

Yderligere information

Længde

1 dag