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

To get the most out of this book

You should have a basic understanding of how businesses operate, including the following:

  • Awareness of how organizations are structured, including different departments and organizational practices
  • Awareness of key processes in organizations such as procure to pay or order to cash
  • Awareness of key systems in organizations such as ERP systems and CRM systems
  • Awareness of data management concepts such as master data management, data ownership, and stewardship

Templates and diagrams

We have made some templates and diagrams available in the book’s GitHub repository here:

The content included is as follows:

File name


Chapter 1 – Data Governance versus Process Speed Diagram (Figure 1.3

A diagram used in the book that people may wish to tailor to their own presentations.

Chapter 2 – Business Case Template (Figure 2.3)

A template created for the book to show how you can provide quantitative calculations for your data quality initiative.

Chapter 2 – Typical One-Page Plan (Figure 2.1)

A one-page plan template that could be used as a starting point.

Chapter 6 – Report Hierarchy Diagram (Figure 6.2)

A diagram used to show how the various data quality dashboards relate to one another. This could be used in a presentation to generate ideas and feedback.

Data Quality Dashboards v2

Power BI reports developed to support the book in the monitoring chapter.

To open this file, you will need to download Power BI Desktop from Microsoft (for free).

Please note, in Power Query, the path to the source data file was removed for security reasons. Please do not apply changes (that is, use Apply Later when you open the report). If you use Apply Now, the data will disappear from the report and it will no longer be possible to explore it.

Data Quality Remediation Prioritization v

Another Power BI report – this time showing the prioritization work for the remediation chapter.

The same notes apply as for Data Quality Dashboards v2 – the source file link was removed, so changes should not be applied.

Tips or important notes

Appear like this.