Realdolmen Education

Détails

Enhance the quality of your data warehouse by using SQL Server Data Quality Services and Master Data

Ce cours n'est actuellement pas prévu sur le calendrier ouvert, mais peuvent être organisé sur demande.

Demande de cours

Nombre de jours

1 day(s)

Audience

Prerequisites

Objectives

Methods

Instructor-led workshop

Description

When creating a data warehouse quality of the stored data is a typical issue. To prevent storing data multiple times, to prevent storing inconsistent data, to prevent storing similar data at different locations,... Microsoft SQL Server offers 2 services to the data warehouse developer : Data Quality Services and Master Data Services.

In this training we will explain how to set-up, and how to use both services.

Contents

  • SQL Server Data Quality Services
    • Introduction to Data Quality
    • Using Data Quality Services to Cleanse Data
    • Using Data Quality Services to Match Data
  • Master Data services
    • Introduction to Master Data Services
    • Implementing a Master Data Services Model
    • Managing Master Data
    • Creating a Master Data Hub