Training & Exams

Data Quality and Master Data Management with SQL Server 2012.

About This Course

Course Code
TPDQMDM12

Course Type
Specialist

Vendor
SolidQ

Duration
2 Days

RRP
£1,055.00

Course Overview
Download

Overview

The data is the key asset of a company. Companies want to gather information from the data; therefore, they start BI projects. However, most of BI projects have to deal with problems with Data Quality (DQ). Data quality can be a huge obstacle for a successful BI project. Of course, line of business applications suffer from poor data quality as well.
Every company has part of the data which is used everywhere, in every transaction, like customers data, products data and similar. Such data is called master data. People who manage master data are often called data stewards. Processes and activities for maintaining master data are known as Master Data Management (MDM). In this course, you are going to learn MDM problems and solutions and introduce Microsoft tools for DQ and MDM, including Data Quality Services (DQS) and Master Data Services (MDS).

Target Audience

This course is intended for data stewards, business intelligence application developers and advanced administrators.

Objectives

Upon completion of this course, the student will be able to:

Course Outline

Module 01: Introduction to Data Quality and Master Data Management
Module 02: Installing and Maintaining Data Quality Services (DQS)
Module 03: Installing and Maintaining Master Data Services (MDS)
Module 04: Managing Master Data with MDS
Module 05: Data Cleansing with DQS
Module 06: Data Profiling with SQL Server Tools
Module 07: Identity Mapping and De-Duplicating
Module 08: Data Quality and Master Data Management with Excel

Prerequisites

Before attending this seminar, it is recommended that students have at least moderate experience with transactional applications, data warehousing, reporting and On-Line Analytical Processing. The attendees should be familiar with the Transact-SQL language. Knowledge of a .NET language like C# or VB.NET is welcome as well.

About This Course

Course Code
TPDQMDM12

Course Type
Specialist

Vendor
SolidQ

Duration
2 Days

RRP
£1,055.00

Course Overview
Download