Data Quality Scorecard: measure quality against targets, with RAG status and trends
An Excel and Google Sheets scorecard for measuring data quality rules against targets, with Red/Amber/Green status, a dashboard and a monthly trend. It comes with 28 sample rules across 5 datasets.
What's included
- Data Quality Scorecard.xlsx, with 6 tabs: Instructions, Dashboard, Metrics, Dataset Scorecard, Trend and Settings
- Quick Start Guide.pdf, 2 pages
- Six dimensions and room for 200 rules
- Formulas for actual, variance, score, status and trend
- A weighted dataset scorecard, a dashboard with two charts and a trend chart
- Adjustable thresholds and dimension weights
Works with Excel 2016 or later, Microsoft 365, Google Sheets and LibreOffice. No macros.
License: single company. Edit and rebrand for internal use; no resale, sharing or redistribution. Free updates to this version through your Payhip download link.
The Data Governance Starter Pack has all four templates plus a quick start guide for $49, about 40% less than buying them separately.
Designed and reviewed by Keel & Charter. AI tools helped build the spreadsheets, draft the text and lay out the preview images. Preview images show the actual files with sample data.
