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

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.

After completing this course, students will be able to:

• Have a basic understanding of the concepts behind master data management.
• Configure Master Data Services.
• 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.
• 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.
• Create and configure versions.
• Navigate the business rules interface.
• Create a business rule.
• Populate a value based on another value.
• Explore and fix validation issues.
• Set up security in MDS.
• Create and configure a subscription view.
• 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.
• Create a new knowledge base.
• Create a DQS Quality Cleansing Project.

Module 1: COURSE OVERVIEW

Module 2: MASTER DATA MANAGEMENT CONCEPTS

Module 3: MICROSOFT MASTER DATA SERVICES OVERVIEW

Module 4: UNDERSTANDING DATA MODELS

Module 5: IMPORTING DATA

Module 6: VERSION MANAGEMENT

Module 7: BUSINESS RULES

Module 8: MDS SECURITY

Module 9: PUBLISHING DATA

Module 10: EXCEL ADD-IN

Module 11: DATA QUALITY SERVICES

Vui lòng bấm "Course Outline" để xem thêm nội dung chi tiết.