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.
Course Price : $1595 Per Participant
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.
Courses
Years of Experience
Global Learners
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.
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).
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.
This module explains how the class will be structured and introduces course materials and additional administrative information.
Lessons
Lab 1: 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.
Lessons
Lab 1: MASTER DATA MANAGEMENT CONCEPTS
After completing this module, students will be able to:
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
Lab 1: MICROSOFT MASTER DATA SERVICES OVERVIEW
After completing this module, students will be able to:
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
Lab 1: UNDERSTANDING DATA MODELS
After completing this module, students will be able to:
The objective of this module is to learn how to load data into MDS.
Lessons
Lab 1: IMPORTING DATA
After completing this module, students will be able to:
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
Lab 1: VERSION MANAGEMENT
After completing this module, students will be able to:
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
Lab 1: BUSINESS RULES
After completing this module, students will be able to:
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
Lab 1: MDS SECURITY
After completing this module, students will be able to:
The objective of this module is that you understand the types of subscription views that are available.
Lessons
Lab 1: 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.
Lessons
Lab 1: EXCEL ADD-IN
After completing this module, students will be able to:
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
Lab 1: DATA QUALITY SERVICES
After completing this module, students will be able to:
©2023 Microtek Learning – All Rights Reserved