Book Image

Practical Data Quality

By : Robert Hawker
Book Image

Practical Data Quality

By: Robert Hawker

Overview of this book

Poor data quality can lead to increased costs, hinder revenue growth, compromise decision-making, and introduce risk into organizations. This leads to employees, customers, and suppliers finding every interaction with the organization frustrating. Practical Data Quality provides a comprehensive view of managing data quality within your organization, covering everything from business cases through to embedding improvements that you make to the organization permanently. Each chapter explains a key element of data quality management, from linking strategy and data together to profiling and designing business rules which reveal bad data. The book outlines a suite of tried-and-tested reports that highlight bad data and allow you to develop a plan to make corrections. Throughout the book, you’ll work with real-world examples and utilize re-usable templates to accelerate your initiatives. By the end of this book, you’ll have gained a clear understanding of every stage of a data quality initiative and be able to drive tangible results for your organization at pace.
Table of Contents (16 chapters)
Part 1 – Getting Started
Part 2 – Understanding and Monitoring the Data That Matters
Part 3 – Improving Data Quality for the Long Term

Designing Failed Data Reports

The Failed Data Report is the final level of detail for the data quality reporting. It is intended to be a completely actionable list of records that need correction. This report does not tend to vary much between organizations – it is a simple list of record-level details.

The following sections will provide details of the report, including its features, elements, and the benefits that they provide.

Typical features of the Failed Data Reports

The Failed Data Reports should provide enough detail to do the following:

  • Quickly and easily identify the record
  • Clearly show the data issue for each record
  • Provide as much assistance as possible to the user in correcting the issue

As already mentioned, the report is typically accessed by drilling through from the Rule Results Report. The user will select a row of the Rule Results Report and click the number of failed records to see the Failed Data Report. It does not have to...