BI, Big Data, and Data Visualization

SQH15 Utilizing Knowledge with Data Quality Services in SQL Server 2012

11/21/2013

1:30pm - 2:45pm

Level: Intermediate

Arie Jones

Arie Jones

Director of Emerging Technologies

Perpetual Technologies, Inc.

Data operations are not only about getting data in and out of a given system but also ensuring that the data is suitable for usage. We've all heard of the phrase "Bad data in, bad data out" and what good is data to us if we cannot ensure that it is correct. Most of the time we write lots of code within stored procedures and functions to compensate for our lack of a system that can help us out with this part of the data food chain. Lucky for us, Microsoft SQL Server 2012 comes with a product known as Data Quality Services (DQS), whose main goals are not only improve your data quality but also to make it much easier to implement and maintain. In this session, we will be looking at what it takes to get DQS up and running in your environment, how to set up Knowledge Bases, and how to utilize the system with tools like SSIS and Master Data Services.

You will learn:

  • An overview of Data Quality Services and how it can fit within their environment.
  • To competently decide which projects and processes may benefit from DQS and be able to explain it properly to business stakeholders.
  • How to setup, utilize, and administer their first Data Quality Services Knowledgebase.
  • How DQS's use can be extended through the use of Integration Services and Master Data Services