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_mitchell.jpg
    elastIO focusses on search and data integration. Text data is increasing at an incredible rate.  Being able to derive meaning and intelligence from free text is hard but necessary if businesses are to get any ROI from things such as weblogs.  Search can offer your users a much better experience over your websites enabling them to find the things they need quicker. We have extensive experience in elasticSearch, SolR and Azure Search. Data will always need to flow from one place to another.  This could be the overnight batch job which takes data from an OLTP system and puts it into a Data Warehouse having first done some cleansing and conforming or it could be the sensors on your machinery in the warehouse which are constantly emitting data and you need to reason over those events and perhaps take action. We are experts in SSIS, Azure Streaming Analytics, Storm, Azure Machine Learning and Azure Data Factory   
  • Video