Implementing Master Data Services in Microsoft SQL Server 2008 R2 

2-Day (COURSE-DB-MDS) Overview SQL Server Master Data Services helps enterprises standardize the data that their people rely on to make critical business decisions. As the server and application sprawl across organizations continues, there has never been a more important time to aim for a single version of the truth and to improve both operational and reporting consistency. SQL Server Master Data Services provides a central hub for storing master data, an extensible platform for building solutions on the hub, a web-based portal for managing the master data and the core elements of a stewardship process for ongoing management of that data. Description During this 2-day course, you will learn to effectively use SQL Server Master Data Services in your organisation. At the completion this course, you will understand how to explain,design, develop, deploy, Master Data Services. In this course you will gain an understanding of the role of master data and of the value provided to an organization by quality master data. You will also see how to design a master data solution and gain an insight into implementing one.   For details on booking courses or seminars, please visit our booking page. Audience The primary audience for this clinic is developers, database administrators and business analysts that need to have an understanding of the capabilities provided by Microsoft SQL Server Master Data Services and the process involved in implementing it.  Prerequisites This course requires that you meet the following prerequisites: Basic understanding of relational databases (necessary). Basic understanding of domain or dimensional modelling (preferable). Basic understanding of web services (preferable).   Course Objectives This course objectives are: Explain the importance of and value provided by master data management and the features  provided by Microsoft SQL Server Master Data Services. Explain the core concepts in designing master data management solutions. Describe the process involved in implementing a solution using Microsoft SQL Server Master Data Services. Course Outline Day 1 Course Introduction Module 1 - Introduction to SQL Server Master Data Management What is Master Data Management? Challenges to implementing Master Data Management SQL Server Master Data Services Lab 1 - Examining the Master Data Portal Module 2 - Working with Master Data Analytic vs operational master data management Stewardship process for master data Working with master data in the Master Data Manager portal Lab 2 - Working with Master Data in the Master Data Manager portal Module 3 - Designing Master Data Services Solutions Governing principles for master data management Maintaining and assessing data quality Understanding models Importing and exporting models Understanding entities and attributes Lab 3 - Working with models, entities and attributes Module 4 - Working with Hierarchies and Collections Derived hierarchies Explicit hierarchies  Recursive hierarchies Collections Lab 4 - Working with Hierarchies and Collections Day 2 Module 5 - Ensuring Data Validity Understanding Business Rules Understanding model versions Validating models Lab 5 - Working with Business Rules Module 6 - Integrating with Other Applications Understanding MDS integration points Exploring subscription views Integrating with Analysis Services Calling MDS web services Lab 6 - Creating an Analysis Services Dimension from a Subscription View Module 7 - Master Data Services Security User and group level security Model security Hierarchy security Lab 7 - Securing Master Data Module 8 - Implementing Notifications and Workflow Configuring Notifications Configuring Workflow Integration with SharePoint Lab 8 - Implementing Notifications and Workflow