learning-it by example

Back to the video

A Data Quality Scorecard That Shows a Hidden Failure

Orders averaged 97.7 percent, amber. One critical check made it red.

Video #210 ยท Data governance

Steps in the video

  1. 0:00 The orders scorecard said amber at 97.7 percent. One check said it was red.
  2. 0:34 The idea
  3. 1:13 Setup
  4. 1:38 The data
  5. 2:02 The checks
  6. 2:27 The scorecard
  7. 2:57 Print it
  8. 3:33 What this does not show
  9. 4:05 Mistakes to avoid
  10. 4:30 My take and next steps
  11. 4:55 Recap

Files

  • checks.py (18 lines)
  • data.py (14 lines)
  • run.py (10 lines)
  • scorecard.py (27 lines)

Download the code (zip)

Tested with

Python 3.12.15

What this does not show

Three made-up tables with planted faults; the colour limits are one vendor's example, the critical rule is my own, and a pass rate says nothing about impact.

Sources

Learning IT by Example.