Platinum Sponsor

Data Quality Services-Making Data Suitable for Business

There are lots of DQ issues we are going to talk about some of the common issues and later on see how we handle them. The biggest issue that customer come to us with is data which is incorrect. What does it mean incorrect –
1.Misspelled names
2.Misspelled addresses – addresses which do not exist, e-mail addresses
 3.Another big problem we address in DQ issues is duplicates. Any company that deals with lots of companies has this problem. For example you can’t imagine how many entries for Boeing can be in a data source. If you have the same entity entered many time with different representations it can be a problem as now you won’t believe what your BI is telling you.
For example what is your total sales ?
Did you count them multiple times?
Did you under count them?
This is a huge problem. You can spend lots of time and money on your BI tools but if your underline data is wrong than it’s a waste of time and money.

This session will show you how to gain back that confidence by employing Data Quality Services from Microsoft.  A Knowledge base driven approach to cleaning your enterprise data.
Presented by Allan Mitchell at SQLBits IX
Tags BI
  • Downloads
  • SpeakerBIO
    Allan is the joint owner of Copper Blue Consulting Ltd.  Copper Blue Consulting focus on getting the right data to the right people at the right time and in the right format.  We are passionate about data integrity and suitability.  We have worked all over the world in a variety of industries.and on projects both large and small.  We specialise in Extract, Transform and Load Complex Event Processing Master Data Management Data Visualisation Operational and Predictive Analytics. We offer training as well as consultancy.
  • Video