|
|
|
|
 |
|
| |
| Online Course Availability |
|
6 Months (180 days) course availability with an expected completion time of about 7 hours. |
| |
| Prerequisites |
|
Basic proficiency with PCs and corporate master data. |
| |
| Who Should Register |
|
Financial Analysts, Functional Managers and IT Professionals |
| |
| Content |
|
Through a combination of online video lecture, demonstration, and self-paced practice, MDS1001 students learn the basic functions of the Microsoft MDS Explorer as well as how to work with Version Management. The Explorer allows end-users to maintain the members in a master model—entities, hierarchies, collections and related members and attributes. |
| |
| Benefits |
|
Students will attain the skills necessary to effortlessly manage master data models and hierarchies in one centralized location for all subscribing systems. |
| |
| Course Tuition |
|
$549.95 (corporate customers see discount form above) |
| |
MDS1001 is broken down into seven chapters. This allows the student to pace themselves as necessary, thus ensuring that they understand each concept as well as the functionality of the Explorer and Version Management areas within the Microsoft SQL Server 2008 R2 product.
Chapter 0: Course Introduction
- Course introduction
- Objectives and expectations
- MDS overview
Chapter 1: MDS Installation
- Database & web application requirements
- The objectives and expectations of the class
- Product overview
Chapter 2: Explanation of the Environment
- MDS architecture
- Administrative overview
- MDS terminology and concepts
- MDS application basics
Chapter 3: Managing Entities
- Entity member types
- Attributes and types
- Hands-on exercises managing entity members & attributes
Chapter 4: Managing Hierarchies
- Hierarchy functionality and types
- Hierarchy modeling
- Hands-on exercises managing hierarchies
Chapter 5: Creating Collections
- The purpose and role of collections in MDS
- How to use collections for ad-hoc analysis
- Hands-on exercises managing collections
Chapter 6: Version Management
- Versions & the version control model
- Hands-on exercises managing the version lifecycle
|
|
|
|
|
|
|
|
|
|
|
 |
|
| |
| Online Course Availability |
|
6 Months (180 days) course availability with an expected completion time of about 10 hours. |
| |
| Prerequisites |
|
MDS1001 or demonstrated Microsoft MDS product skills and knowledge. |
| |
| Who Should Register |
|
System Administrators and Master Data Model Administrators |
| |
| Content |
|
Through a combination of online video lecture, demonstration, and self-paced practice, MDS1002 students will understand the concepts behind the application and gain an in-depth knowledge of all the administrative functions. MDS1002 students will also learn how to administer and maintain their product environment, including modeling guidelines, the initial data import, application security, and exporting data for subscribing systems. |
| |
| Benefits |
|
Students will attain the skills necessary to apply best-practice master data management principles to the product's centralized repository. |
| |
| Course Tuition |
|
$549.95 (corporate customers see discount form above) |
| |
MDS1002 is broken down into seven chapters. This allows the student to pace themselves as necessary, thus ensuring that they understand the structural concepts of System Administration, Integration Management, Business Rules, and Security within Microsoft SQL Server 2008 R2.
Chapter 0: Course Introduction
- Course introduction
- Objectives and expectations
- MDS overview
Chapter 1: MDS Installation
- Database & web application requirements
- The objectives and expectations of the class
- Product overview
Chapter 7: Modeling Guidelines
- Concept overview of model components
- The recommended process for developing models
- Model development best practices
Chapter 8: Model Building
- The master data model and relationships
- Using entities as attributes
- Maintaining master data models and objects
- Hands-on exercises and real-world scenarios creating a master data model from scratch
Chapter 9: Integration Management
- Populating staging tables & importing data
- Hands-on exercises importing data into MDS
- Data export and subscriptions
- Hands-on exercises building subscription views
Chapter 10: Business Rules
- Using rules to define, validate and verify data
- Business rule design and application
- Validation issues and notifications
- Hands-on exercises creating business rules
Chapter 11: Security & Permissions
- Security model and inheritance
- Effective permissions (resolving assignments)
- Hands-on exercises assigning user and group permissions
|
|
|
|
|
|
|