DQS Training

Microsoft SQL Server Data Quality Services for Data Cleansing & Data Deduplication with Data Quality Client & SSIS tools

Ratings 4.09 / 5.00
DQS Training

What You Will Learn!

  • Creating Domains
  • Creating Knowledgebase
  • Data Cleansing
  • Data Deduplication
  • DQS Adminstration

Description

The topics which are covered in this online video training course on DQS are


DQS Introduction

DQS Terminologies

DQS Architechture

DQS Installation


Data Cleansing

Data Source used for Demonstration

Domains and Knowledge Base

Cleansing Project

SSIS Package for Data Cleansing


Data Deduplication

Matching Policies

Deduplication Project


Advanced DQS

Term Based Relations

Composite Domains

Creating Regular Expressions Rules in a domain

Domain DataTypes

Import Knowledge Base & Domains

Export Knowledge Base & Domains

Open Delete Rename Unlock Knowledge Base & Projects

Purpose of each DQS Databases

Backup and Restore DQS Databases

DQS Configurations

DQS Activity Monitor

Who Should Attend!

  • Beginners who want to learn Microsoft Data Quality Services
  • It will be value addition skill for Microsoft BI developers
  • Consultants who want to take data cleansing tasks
  • IT Students who want to create one quick IT Project and submit to their college
  • One or two questions are asked about DQS in Microsoft SSIS Certification exams as well

TAKE THIS COURSE

Tags

  • Data Quality Management

Subscribers

271

Lectures

20

TAKE THIS COURSE



Related Courses