Applied Master Data Services and Data Quality Services

Applied Master Data Services and Data Quality Services

Organizations that invest in master data management and improving the quality of their informational assets will be best positioned to reap the huge data dividend! SQL Server and this class will help you get started. Use Master Data Services (MDS) to manage your master and referenced data and Data Quality Services (DQS) to externalize rule management to business users.

This two-day class is designed to help you become proficient with SQL Server 2016 Master Data Services (MDS) and Data Quality Services (DQS). IT and business users learn how to design MDS models and extend them with business rules, attribute groups, and hierarchies. IT will learn how to integrate MDS with upstream and downstream systems and how to enforce secured access. Business users will learn how to use Excel to manage data with the tool they love most! Then, the class teaches how to create DQS knowledge bases, perform matching and cleansing tasks, and integrate DQS with SSIS packages to automate data quality processes. The class can be customized to target separately pro and business user audiences.

Audience

  • IT and BI pros
  • Data stewards and business users
  • In general, anyone interested in managing master data and improving data quality

Prerequisites

  • Experience navigating the Microsoft Windows environment

Hardware and software requirements

  • Windows 7 or above
  • SQL Server with MDS and DQS
  • Detailed software setup instructions will be sent before the event