Providing Technology Training and Mentoring For Modern Technology Adoption
Studies show that data decays at about 2% a month all organizations need to work from reliable information while ensuring that the integrity of information and consistency of data is constant across different applications. Microsoft SQL Server 2012-2014 Master Data Services is a powerful feature designed to help an organization create a structure and hierarchy for data, so that data collected and used across multiple departments, silos and databases is standardized and aligned. This ensures that different databases are interoperable. When combined with Data Quality Services and Excel a complete end to end system is available.
After completing this course, students will be able to:
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.
This module explains how the class will be structured and introduces course materials and additional administrative information.
Lab : COURSE OVERVIEW
After completing this module, students will be able to:
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.
Lab : MASTER DATA MANAGEMENT CONCEPTS
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.
Lab : MICROSOFT MASTER DATA SERVICES OVERVIEW
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.
Lab : UNDERSTANDING DATA MODELS
The objective of this module is to learn how to load data into MDS.
Lab : IMPORTING DATA
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.
Lab : VERSION MANAGEMENT
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.
Lab : BUSINESS RULES
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.
Lab : MDS SECURITY
The objective of this module is that you understand the types of subscription views that are available.
Lab : PUBLISHING DATA
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.
Lab : EXCEL ADD-IN
The objective of this module is for you to understand Data Quality Services and how to use it in conjunction with Master Data Services.
Lab : DATA QUALITY SERVICES