The Agenda

Agenda Home
SQLBits 2024 runs from Tuesday 19th – Saturday 23rd March.

Take Good care of your Data: Introducing SQL 2012 DQS &MDS

Description

DQS and MDS are here!!!

With SQL 2012, you’ll be able to take much better care of your Data. The new exciting Data Quality Services and the improved Master Data Services in conjunction with SSIS provides the IT and IW with an attractive
solution that allows full lifecycle data management.

Data Quality Services (DQS) is a new innovative knowledge driven solution that enables the organization to define, manage, control and measure the quality of its business data. The solution allows definition and
utilization of internal and external (using Windows Azure Marketplace) Domain specific Knowledge, that is used for cleansing and matching, while providing a compelling and intuitive usage scenario that is
designed for the Information Worker.
In the session we’ll review the solution concepts, describe and demo Knowledge Management , Cleansing, Matching and SSIS integration and share customer stories and best practices.

Master Data Services in 2012 is enhanced with additional functionality and with the new MDS Excel Add-in that enhances the IW ability to manage the full Master Data lifecycle and react to changes, using his most
common working tool – the Excel worksheet. This new functionality provides the IW with an optimized experience to manage and enrich his Master data while collaborating with the organization Information Management group.

In SQL 2012 - DQS & MDS introduce a very attractive offer to every IT information management group that will improve the Data Quality and Management in a highly efficient and productive manner.

Learning Objectives

Previous Experience

Tech Covered

Azure, SSIS, master data, Data Quality Services