Introduction to data quality reporting
Data quality reporting should provide an entire hierarchy of reporting – from a high-level summary, down to the individual rows of failed data. These different levels of reporting are aimed at different stakeholders of varied seniority.
This is to cover the diverse requirements of different users of the reporting. For example, a list of failed records is very useful for an operational person who has been asked to make corrections, but would not serve a Chief Data Officer very well. A level of aggregation is required for a senior stakeholder so that they can see an overall picture of the data in the area(s) that they are responsible for.
This section will outline the types of reporting required, who they are aimed at, and how they might look.
Different levels of reporting
In my experience, there are three main levels of reporting required in a data quality initiative. These are mentioned in the following table: