Reader small image

You're reading from  Practical Data Quality

Product typeBook
Published inSep 2023
PublisherPackt
ISBN-139781804610787
Edition1st Edition
Right arrow
Author (1)
Robert Hawker
Robert Hawker
author image
Robert Hawker

Robert Hawker started his career as a chartered accountant before making the leap into data in 2007. He led data teams within two global implementations of SAP, looking after master data management, data ownership and stewardship, metadata management, and, of course, data quality over a 14-year period. He moved into analytics in 2017 and now specializes in Microsoft Power BI training, implementation, administration, and governance work. He lives in the UK and shares his experiences through conference and blogs.
Read more about Robert Hawker

Right arrow

Overall remediation process

The overall process of remediation is typically cyclical in nature. It is usually not possible to work on all the issues uncovered by data quality reporting at the same time. The remediation is usually handled in tranches.

Our process for remediation has the following steps:

Figure 8.1 – End-to-end process of remediation

Figure 8.1 – End-to-end process of remediation

The following table provides a more detailed description of each step:

lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
Practical Data Quality
Published in: Sep 2023Publisher: PacktISBN-13: 9781804610787

Author (1)

author image
Robert Hawker

Robert Hawker started his career as a chartered accountant before making the leap into data in 2007. He led data teams within two global implementations of SAP, looking after master data management, data ownership and stewardship, metadata management, and, of course, data quality over a 14-year period. He moved into analytics in 2017 and now specializes in Microsoft Power BI training, implementation, administration, and governance work. He lives in the UK and shares his experiences through conference and blogs.
Read more about Robert Hawker

Step Name

Description

Prioritize

Identification of the most important data quality failures so that these can be targeted early.

Identify the approach

There are a number of different ways to remediate data. Here are some examples:

  • Manual record-by-record corrections
  • Collection/upload of data from a third party
  • Automatic...