Level: Intermediate

Thomas LeBlanc

Data Warehouse Independent Consultant

Data on the Geaux

Is there data scattered all over your enterprise? Has your boss asked you to help your users create and manage one source of common data? Are there different spellings of values in the same column of a table? Can you use help from algorithms to find the best match? Is the Customer or Product table in multiple databases with different columns? Do you need help managing the Data Warehouse?

This session will jump into SQL Server 2016 with DQS and MDS. You use the Data Quality projects in Integration Services (SSIS) to rank values and help with misspelled data. You'll help your users manage the DQS projects giving them management access to data quality and moving that responsibility to the business where it should be.

Next, you'll use MDS to help consolidate dimensions scattered in multiple databases to form a true Conformed Dimension area. MDS will help your company move away from spreadsheets or flat files to manage critical information for analytics. These features were added to SQL Server in version 2012 and have been upgraded in 2014 and 2016 to help enterprises with the task of Master Data Management.

You will learn:

• How to use Data Quality Services to cleanse data with DQS and SSIS
• How to create a Master Data Management system with MDS in SQL Server 2016 to consolidate multiple data sources