Tag Archives: duplication

Building A Business Case For Data Quality: Create The Business Case

Building A Business Case For Data Quality, 7 of a 7-part series

Finally, you need to create a business case and present the finding of the data quality checkup. There are two levels of presentation that typically take place after the data quality assessment. The first is a technical presentation to IT giving all the details of completeness, conformity, consistency, accuracy, duplication, and integrity characteristics of the data. IT needs to understand the types of issues in order to figure out what needs to be repaired and have an idea what can be fixed and what it might cost.

The more important presentation is what impact these issues are having on the business. Does the lack of accuracy in the data affect the accuracy of business decisions? How does the completeness of the data affect insurance ratings, loan applications, or well drilling decisions?  Are your customer’s committing a crime? (more…)

Posted in Data Quality | Tagged , , , , , , | 1 Comment

Building A Business Case For Data Quality: Categorize The Anomalies

Building A Business Case For Data Quality, 5 of a 7-part series

Once you finish your initial assessment, you need to summarize a very long list of potential issues you discovered. This is where you should group the issues to make the presentation of the results more meaningful. For example, you can group items by table—these are X number of issues found affecting Y percent of records per table. Sometimes I group them into the following types of characteristics:


  • Is all the requisite information available?
  • Are all the address fields populated?
  • Are data values missing or in an unusable state?
  • Are the phone numbers populated?
  • Do all the inpatient claims contain an admission date? (more…)
Posted in Data Quality | Tagged , , , , , , | Leave a comment