Cena tečaja * 900,00 €
Obseg v dneh 2
Število ur 18

Trenutno nimamo razpisanih terminov za ta tečaj. Prijavite se na seznam interesentov in obvestili vas bomo o prvem možnem terminu.
Prijavite se na seznam interesentov

* Cena je brez DDV

Data Quality and Master Data Management with SQL Server 2012 – 2016 DW-DQMDM12-401-EN-1

2 Days DW-DQMDM12-401-EN

Data is the key asset of a company. Companies want to gather information from the data; therefore, they start BI projects. However, most of the BI projects have to deal with Data Quality (DQ) problems.
Data quality can be a huge obstacle for a successful BI project. Of course, the 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 become familiar with 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.

  • 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.

  • Course Objectives
    Upon completion of this course, the student will be able to:
    • Describe what master data is
    • Define master data management activities
    • Understand data quality problems
    • Install Data Quality Services (DQS)
    • Create DQS knowledge base and projects
    • Deploy Master Data Services (MDS)
    • Manage master data with MDS
    • Profile data with SQL Server toolsin order to find areas of low data quality
    • Control data quality over time
    • Merge data from multiple independent sources through identity mapping
    • De-duplicate master data.

    Course Summary 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


  • Dejan Sarka

    Sarka Dejan

    Data Quality and Master Data Management with SQL Server 2012 – 2016