Worked example: data readiness for a “Sales by SKU” report
A team builds a standard report and checks whether data exists for every field. The list and availability are illustrative.
Figures
- Report fields
- date, store, SKU, quantity, net amount, discount, returns
- Available in the ERP
- 6 of 7 fields
- Readiness (calculation)
- 6 / 7 ≈ 86%
- What is missing
- returns are not linked to the original sale
Lesson
A report with one missing field gives a wrong total, so close the data gap first and only then draw the report. Record the source and the owner for each field.