Creating a Data Quality Scorecard or Dashboard

Having multiple metrics on each of the seven C’s is perfectly acceptable. In fact, you will earn points with your C-level by understanding that there are different ways to think about each of these. Now that you can describe the quality of the data in seven different ways (maybe with multiple metrics for each one), you should consider making this something that you look at on a regular basis.

Creating a scorecard or dashboard of some kind is actually a really good way to demonstrate to your C-suite that you have great familiarity of the employee data, and that you are monitoring it to ensure that the data-driven decisions that are being made are based on good data.

There are lots of different ways to create scorecards and dashboards, but I’ll share a simple way that can be accomplished with a basic spreadsheet. The goal is to be able to take the seven data quality measures and color code them so that visually, it is...