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

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...

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