Preparing a sample data quality scorecard in Microsoft Excel

In the previous section, we discussed using data quality frameworks to get a better understanding of the quality of the data we are working with. In this section, we will discuss how to decide which metrics to use and create a sample template in Excel, then apply it to a fictional scenario for a company encountering issues with its data.

Establish the data quality metrics to be used

To prepare a data quality scorecard in Excel, we must first establish the data quality metrics that we will use. We covered them earlier in the chapter and we will create a sample scorecard that includes KPIs for completeness, accuracy, consistency, timeliness, and validity.

Define the scale for scoring KPIs

There are two options we can use when scoring the KPIs. It can either be qualitative or quantitative.

Scoring the KPIs qualitatively involves using the high, medium, and low criteria as follows:

• High: The data receives...