fbpxl
Private Onsite | 2 Days Classroom

 Data Quality and Master Data Management with SQL Server

Data Quality Services, Master Data Services, and other SQL Server tools for data quality. Dealing with data quality issues is one of the most complex tasks in IT business.

Learn how to raise and maintain data quality with SQL Server tools.

Upcoming Dates

There are no scheduled classes for this course at the moment. Please, send us an information request to find out more.

Course Delivery Options

Private Onsite.

The course will take place in your company’s facilities. We limit attendance to no more than 20 students in order to maintain a good level of interactivity.

2 Days Classroom.

The course will take place in a classroom with no more than 20 students in order to maintain a good level of interactivity.

Pre-requisites

Attendees should understand relational databases and have a working knowledge with SQL Server.
After this Course
Data is the key asset of any organization. Companies want to gather information from the data, so they start business intelligence (BI) projects. However, most of the BI projects also have to deal with data quality problems. Data quality can represent a tremendous obstacle to the success of any BI project. Line of business (LOB) applications will certainly suffer from poor data quality as well.

Every company has some data that is used everywhere, in every process, in every transaction, such as customer or product data. This type of data is referred to as master data. People in charge of managing master data are usually referred to as data stewards. The processes and activities required to maintain master data is collectively referred to as master data management (MDM). In this course, you are going to learn about typical MDM problems and solutions. You will also become familiar with Microsoft tools for data quality and MDM, including Data Quality Services (DQS) and Master Data Services (MDS).

“The instructor has an incredible amount of knowledge and gives a very polished presentation”

Course Outline
Module 1. Introduction to Data Quality and Master Data Management
Lab 01: Checking for Data Quality Issues and Defining Master Data
Module 2: Installing and Mantaining Data Quality Services
Lab 02: Installing and Administering DQS
Module 3: Installing and Implementing Master Data Services
Lab 03: Installing MDS and Creating and Populating an MDS Model
Module 4: Managing Master Data with MDS
Lab 04: Importing and Exporting Data, Managing Security, and Using the MDS Add-in for Excel
Module 5: Data Cleansing with DQS
Lab 05: Creating a DQS Knowledge Base and Project and Using the DQS Cleansing Transformation
Module 6: Data Profiling with SQL Server Tools
Lab 06: Using the Linear Regression and Regression Trees algorithms
Module 7: Identity Mapping and De-Duplicating
Lab 07: DQS Matching and the SSIS Fuzzy Lookup Transformation
Module 8: Data Quality and Master Data Management with Excel
Lab 08: DQS Matching and Data Profiling with PowerPivot

Contact us

Do you want more info about these courses?

  • By submitting this information, you acknowledge that you have read the Privacy Policy and that you consent to our data processing in accordance with this Statement.

Invite & Earn

X
Signup to start sharing your link
Signup