- 0:00–0:06
Start with the measure • Quality depends on the reporting use. • Sum order amounts • Fixed snapshot + period • Check order IDs • Illustrative SAR amounts · not revenue
The measure is the sum of hypothetical order amounts in SAR, not recognised revenue. The route fixes a source snapshot and period, then checks order IDs before calculating.
- 0:06–0:12
Inspect the join • Order amounts can repeat at shipment grain. • 4 source orders • 7 left-join rows • O-1 · 100 • O-2 · 100 • O-3 · 250 • O-4 · 500 • SAR 950 → naive SAR 1,550
Four source orders stay visible: O-1 100, O-2 100, O-3 250 and O-4 500 SAR. Copies fan into seven left-joined rows in multiplicities 2, 1, 3 and 1. No source amount changes. O-4 is retained once without a matching shipment because this example confirms the shipment source is complete and O-4 has none. The original sum is SAR 950; summing repeated joined amounts naively gives SAR 1550. These are hypothetical order amounts, not revenue or client results.
- 0:12–0:18
Use the record key • Equal amounts do not make two orders duplicates. • O-1 • O-2 • 100 SAR • Equal amounts, different order IDs • 100 + 100 = 200 SAR
Two different order identifiers, O-1 and O-2, remain separate above equal SAR 100 amounts. The two amounts contribute SAR 200 together; matching amounts are not a duplicate-record key.
- 0:18–0:24
Show missing states honestly • Unavailable is not zero. • Zero • Unknown • Not applicable • Unavailable • Failed source import → Unavailable • Four distinct states
Four reviewed symbols name zero, unknown, not applicable and unavailable. A failed source import connects to unavailable. It does not turn into zero or any of the other two states.
- 0:24–0:30
Retain and rerun evidence • Record the definition, period, role and owner. • Correction to verify • Rerun source checks • Rerun model checks • Definition · period · role · owner • Check another permitted role • Keep evidence · result pending
A correction branches into source and model checks, with definition, period, role and owner recorded. Another permitted role is checked as well. Evidence must be retained and rerun after changes; no successful acceptance result is claimed.
A silent 30-second explanation in five six-second beats. Order amounts can repeat across shipment detail; reconciliation returns to the intended record grain.
Read the article: Dashboard Data Quality: Check the Records Behind the Chart