Microtek Learning Logo

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

4.8
(4.8)

According to studies, data ages at a rate of 2% per month. All companies must rely on accurate information and make sure that data consistency and integrity are maintained across all applications.

  • Accredited By : Microsoft Partner Logo
  • Category : SQL

Course Price : $1595 Per Participant

Course Description

According to studies, data ages at a rate of 2% per month. All companies must rely on accurate information and make sure that data consistency and integrity are maintained across all applications.

Microsoft SQL Server 2012-2014 includes Master Data Services, a powerful tool designed to help an organization construct a framework and hierarchy for data so that information gathered and used across numerous departments, silos, and databases are uniform and coordinated.

This ensures that several databases may communicate with one another. Excel and Data Quality Services can be integrated to create a whole end-to-end system.

 

Training Exclusives

  • Live instructor-led interactive sessions with Microsoft Certified Trainers (MCT).
  • Access to Microsoft Official Courseware (MOC).
  • Real-time Virtual Lab Environment.
  • Experience 24*7 Learner Support.
  • Self-paced learning and flexible schedules.
Microsoft Course Microsoft Course
500+

Courses

experience experience
20+

Years of Experience

learners learners
95K+

Global Learners

What you will learn

  • green-tick Master Data Services configuration.
  • green-tick Establish entities and models.
  • green-tick Utilizing the web interface, add a member.
  • green-tick Put an action back.
  • green-tick Establish and set up attribute groups.
  • green-tick Construct and set up derived hierarchies.
  • green-tick Construct and set up collections.
  • green-tick Using T-SQL, create a leaf member.
  • green-tick View batch file errors.
  • green-tick Versions can be made and configured.
  • green-tick Navigate the interface for business rules.
  • green-tick Make a corporate rule.
  • green-tick Fill a value with data based on another value.
  • green-tick Examine and address validity problems.
  • green-tick Set up MDS security.
  • green-tick Set up and customize a subscription view.
  • green-tick Utilize Excel to filter data.
  • green-tick Query saved to Excel.
  • green-tick Excel data can be used to create an entity.
  • green-tick Assemble a fresh knowledge foundation.
  • green-tick DQS Quality Cleansing Project creation
  • green-tick Add attributes, such as those that are domain-based.
  • green-tick Excel can be used to establish a connection to an MDS database.
  • green-tick Data can be published from Excel to an MDS database.
  • green-tick Use flat files and SQL Server Integration Services to load leaf members.
  • green-tick Utilize the web interface to remove a member, then check the outcomes in SSMS.
  • green-tick Possess a fundamental knowledge of the ideas underlying master data management.

Prerequisites

  • There are no prerequisites for this course.

Who should attend this course?

Project managers who need to understand how to use Master Data Services as well as SQL professionals, data analysts, business intelligence developers, and data stewards are the target audience for this course.

Microsoft Learning Partner

Microtek Learning is a Microsoft Certified Partner for Learning Solutions. This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).

Schedules

Oops! For this course, there are currently no public schedules available. Clicking on "Notify Me" will allow you to express your interest.

For dates, times, and location customization of this course, get in touch with us.

You can also speak with a learning consultant by calling 800-961-0337.

Curriculum

This module explains how the class will be structured and introduces course materials and additional administrative information.

Lessons

  • Introduction
  • Course Materials
  • Facilities
  • Prerequisites
  • What We'll Be Discussing
  • Lab 1: COURSE OVERVIEW

    After completing this module, students will be able to:

  • Successfully log into their virtual machine.
  • Have a full understanding of what the course intends to cover.
  • In this introductory module, we will introduce the need for Master Data Management and discuss a number of high-order concepts introducing the subject area.

    Lessons

  • 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
  • Lab 1: MASTER DATA MANAGEMENT CONCEPTS

    After completing this module, students will be able to:

  • Have a basic understanding of the concepts behind master data management.
  • In this module we will examine a master data management project implementation and describe the concept of the different systems involved. We will then move into key objects within MDS that are critically important for understanding MDS.

    Lessons

  • Project Implementation
  • Master Data Services Key Terms
  • Master Data Services Web Interface
  • Installing Master Data Services
  • Lab 1: MICROSOFT MASTER DATA SERVICES OVERVIEW

  • Configuring Master Data Services
  • After completing this module, students will be able to:

  • Configure Master Data Services.
  • We touched on the basics of the MDS object model already and covered core concepts such as entities, attributes, members and hierarchies. In this module we will expand on that and take an in-depth look at all the objects in the MDS model. In addition we will examine modeling concepts and deployment.

    Lessons

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

  • Create Model and Entities
  • Adding Attributes Including Domain-Based Attributes
  • Adding a Member Via the Web Interface
  • Reversing a Transaction
  • Attribute Groups
  • Derived Hierarchies
  • Collections
  • After completing this module, students will be able to:

  • 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.
  • The objective of this module is to learn how to load data into MDS.

    Lessons

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

  • Create a Leaf Member with T-SQL
  • Delete a Member with the Web Interface and Examine Results in SSMS
  • Viewing Errors in Batch Files
  • Loading Leaf Members with SQL Server Integration Services and Flat Files
  • After completing this module, students will be able to:

  • 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.
  • In this module we will learn how to work with versions. The ability to version MDS models enables functionality such as what if scenarios, testing and others.

    Lessons

  • Understanding Versions
  • Web Interface
  • Version Statuses
  • Copying a Version
  • Locking. Unlocking and Committing Versions
  • Version Flags
  • Ancestry
  • Validating Versions
  • Lab 1: VERSION MANAGEMENT

  • Versions
  • After completing this module, students will be able to:

  • Create and configure versions.
  • The goal of this module is to gain an understanding of the business rules interface and how to implement business rules into your model. It is important that you know the interface requires some getting used to and is perhaps not the friendliest interface that you have ever used. Pay particular attention to how often you need to save your business rules.

    Lessons

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

  • Business Rules Interface
  • Create a Business Rule
  • Populate a Value Based on Another Value
  • Validation Issues
  • After completing this module, students will be able to:

  • Navigate the business rules interface.
  • Create a business rule.
  • Populate a value based on another value.
  • Explore and fix validation issues.
  • The goal this module is to gain an understanding of the security in MDS. The security in some ways follows other security paradigms that you may be used to. Such as the concept of read, write, and deny permissions. However, the concepts such as granting permission to the model object for all groups of users so they can view the model may be foreign to you. Also make sure that you understand that MDS does not control security; that it is controlled by active directory. It is within active directory that the passwords and usernames are stored along with the user groups.

    Lessons

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

  • Setting up Security in MDS
  • After completing this module, students will be able to:

  • Set up security in MDS.
  • The objective of this module is that you understand the types of subscription views that are available.

    Lessons

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

  • Creating a Subscription View
  • After completing this module, students will be able to:
  • Create and configure a subscription view.
  • The objective of this module is to help you understand the Excel Master Data Services Add-in, which is the best feature that was added with the SQL 2012 release.

    Lessons

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

  • Creating a Connection
  • Publishing Data
  • Filtering Data
  • Saving a Query
  • Create an Entity From Data
  • After completing this module, students will be able to:

  • 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.
  • The objective of this module is for you to understand Data Quality Services and how to use it in conjunction with Master Data Services.

    Lessons

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

  • Create a New Knowledge Base
  • DQS Quality Cleansing Project
  • After completing this module, students will be able to:

  • Create a new knowledge base.
  • Create a DQS Quality Cleansing Project.
  • Course Details

    • skill skill-green
      Skill Level: Intermediate
    • enroll enroll-green
      Enrolled: 1685
    • duration duration green
      Duration: 3 Days

    Talk to Learning Advisor