Master Data Services, Data Quality Services with SQL 2012-2014 and Excel (55073)
About this Course
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.
Audience Profile
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.
At Course Completion
- 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.
Course Outline
Module 1: COURSE OVERVIEW
Lessons
- Introduction
- Course Materials
- Facilities
- Prerequisites
- What We'll Be Discussing
Lab : COURSE OVERVIEW
- There are no exercises for this module.
- Successfully log into their virtual machine.
- Have a full understanding of what the course intends to cover.
Module 2: MASTER DATA MANAGEMENT CONCEPTS
Lessons
- What is Master Data Management?
- The Need for Master Data Management
- Data Quality
- Master Data vs. Transactional Data
- Master Data Management Team
- Master Data Management Architectures
- The MDM Extract-Transform-Load
Lab : MASTER DATA MANAGEMENT CONCEPTS
- There are no exercises for this module.
- Have a basic understanding of the concepts behind master data management.
Module 3: MICROSOFT MASTER DATA SERVICES OVERVIEW
Lessons
- Project Implementation
- Master Data Services Key Terms
- Master Data Services Web Interface
- Installing Master Data Services
Lab : MICROSOFT MASTER DATA SERVICES OVERVIEW
- Configuring Master Data Services
- Configure Master Data Services.
Module 4: UNDERSTANDING DATA MODELS
Lessons
- Modeling Process
- MDS Object - Model
- The Model Object
Lab : UNDERSTANDING DATA MODELS
- Create Model and Entities
- Adding Attributes Including Domain-Based Attributes
- Adding a Member Via the Web Interface
- Reversing a Transaction
- Attribute Groups
- Derived Hierarchies
- Collections
- 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.
Module 5: IMPORTING DATA
Lessons
- MDS Entity-Based Staging
Lab : IMPORTING DATA
- Create a Leaf Member with T-SQL
- Delete a Member with the Web Interface and Examine Results in SSMS
- Viewing Errors in Batch Files
- Loading Leaf Members with SQL Server Integration Services and Flat Files
- 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.
Module 6: VERSION MANAGEMENT
Lessons
- Understanding Versions
- Web Interface
- Version Statuses
- Copying a Version
- Locking. Unlocking and Committing Versions
- Version Flags
- Ancestry
- Validating Versions
Lab : VERSION MANAGEMENT
- Versions
- Create and configure versions.
Module 7: BUSINESS RULES
Lessons
- Business Rules Overview
- How to Create a Business Rule
- Conditions and Actions
- Publish a Business Rule
- Validation Issues
Lab : BUSINESS RULES
- Business Rules Interface
- Create a Business Rule
- Populate a Value Based on Another Value
- Validation Issues
- Navigate the business rules interface.
- Create a business rule.
- Populate a value based on another value.
- Explore and fix validation issues.
Module 8: MDS SECURITY
Lessons
- Master Data Services Security Overview
- Users and Groups
- Administrators
- Permission Levels
- Best Practices
Lab : MDS SECURITY
- Setting up Security in MDS
- Set up security in MDS.
Module 9: PUBLISHING DATA
Lessons
- Subscription Views
- Formats
- How Subscribing Systems Can Extract Data
- Creating Views
Lab : PUBLISHING DATA
- Creating a Subscription View
- Create and configure a subscription view.
Module 10: EXCEL ADD-IN
Lessons
- Creating Connections
- Publishing Data
- Filtering Data
- Saving a Query
- Create an Entity From Data
- Settings
Lab : EXCEL ADD-IN
- Creating a Connection
- Publishing Data
- Filtering Data
- Saving a Query
- Create an Entity From Data
- 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.
Module 11: DATA QUALITY SERVICES
Lessons
- Architecture
- Data Quality Cleansing
- Microsoft Data Quality Solution
Lab : DATA QUALITY SERVICES
- Create a New Knowledge Base
- DQS Quality Cleansing Project
- Create a new knowledge base.
- Create a DQS Quality Cleansing Project.
Sorry! It looks like we haven’t updated our dates for the class you selected yet. There’s a quick way to find out. Contact us at 502.265.3057 or email info@training4it.com
Request a Date