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

Overview

Microsoft SQL Server 2012-2014 Master Data Services is a powerful feature designed to help organizations create a structure and hierarchy for data, so that data collected and used across multiple departments, silos and databases is standardized & aligned.

Objectives

At Course Completion
  • Have a basic understanding of the concepts behind master data management.
  • Configure Master Data Services.
  • Create models and entities.
  • Add attributes including domain-based attributes.
  • Add a member via the web interface.
  • Reverse a transaction.
  • Create and configure attribute groups.
  • Create and configure derived hierarchies.
  • Create and configure collections.
  • Create a leaf member with T-SQL.
  • Delete a member with the web interface and examine results in SSMS.
  • View errors in batch files.
  • Load leaf members with SQL Server Integration Services and flat files.
  • Create and configure versions.
  • Navigate the business rules interface.
  • Create a business rule.
  • Populate a value based on another value.
  • Explore and fix validation issues.
  • Set up security in MDS.
  • Create and configure a subscription view.
  • Create a connection to an MDS database using Excel.
  • Publish data to an MDS database using Excel.
  • Filter data using Excel.
  • Save a query to Excel.
  • Create an entity from data in Excel.
  • Create a new knowledge base.
  • Create a DQS Quality Cleansing Project.

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.

Syllabus

Course Overview

  • Introduction
  • Course Materials
  • Facilities
  • Prerequisites
  • What We'll Be Discussing

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

MICROSOFT MASTER DATA SERVICES OVERVIEW

  • Project Implementation
  • Master Data Services Key Terms
  • Master Data Services Web Interface
  • Installing Master Data Services

UNDERSTANDING DATA MODELS

  • Modeling Process
  • MDS Object - Model
  • The Model Object
  • Lab 1: UNDERSTANDING DATA MODELS

Importing Data

  • MDS Entity-Based Staging
  • Lab 1: IMPORTING DATA

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

BUSINESS RULES

  • Business Rules Overview
  • How to Create a Business Rule
  • Conditions and Actions
  • Publish a Business Rule
  • Validation Issues
  • Lab 1: BUSINESS RULES

MDS SECURITY

  • Master Data Services Security Overview
  • Users and Groups
  • Administrators
  • Permission Levels
  • Best Practices
  • Lab 1: MDS SECURITY

PUBLISHING DATA

  • Subscription Views
  • Formats
  • How Subscribing Systems Can Extract Data
  • Creating Views
  • Lab 1: PUBLISHING DATA

EXCEL ADD-IN

  • Creating Connections
  • Publishing Data
  • Filtering Data
  • Saving a Query
  • Create an Entity From Data
  • Settings
  • Lab 1: EXCEL ADD-IN

DATA QUALITY SERVICES

  • Architecture
  • Data Quality Cleansing
  • Microsoft Data Quality Solution
  • Lab 1: DATA QUALITY SERVICES

Training provider

Teaching mode: Classroom - Instructor Led
Duration: 3 days
Gooroo has partnered with the global leaders in IT training to give you access to quality training, personalised to you, targeted at increasing your job opportunities and salary.

Our pricing

We do not display pricing as Gooroo members qualify for special discounts not available elsewhere. You must enquire through Gooroo to get this benefit.

New courses are happening all the time

Our partner's expert training consultant will provide you with the times and all the details you need. Enquire today.

Top skills covered in this course

Data quality
Worldwide
This skill has an average salary of
US$76,645
and is mentioned in
0.61%
of job ads.
Microsoft SQL Server
Worldwide
This skill has an average salary of
US$86,558
and is mentioned in
1.59%
of job ads.
Database
Worldwide
This skill has an average salary of
US$72,045
and is mentioned in
10.69%
of job ads.
SQL Server Integration Services
Worldwide
This skill has an average salary of
US$81,402
and is mentioned in
0.09%
of job ads.