Producing Eye-Catching Data Quality Dashboards with Tableau

In this post, we discuss how to add some much needed flair to your data quality program using Tableau. Figure 1 shows an overall Data Quality Scorecard for the Client Entity. The scorecard also shows the percentage of compliant and non-compliant records by data quality dimension completeness, conformity, consistency and uniqueness.
As a first step, we assume that you have completed data profiling using manual SQL queries or automated tools such as IBM Information Analyzer, Informatica Data Quality, Trillium TS Discovery or SAP Information Steward. Figure 1 shows an overall Data Quality Scorecard for the Client Entity. The scorecard also shows the percentage of compliant and non-compliant records by data quality dimension – completeness, conformity, consistency and uniqueness. There are additional dimensions such as accuracy, timeliness and synchronization that we do not cover in this dashboard. The scorecard is also color coded by red, yellow and green to show acceptable and unacceptable thresholds.

Image courtesy of information-asset.com