Who asked: Kofi Mensah, head of operations at Orchard Lane Fulfilment.
Why: the Monday operations meeting needs the same numbers every week, worked out the same way, instead of three spreadsheets that disagree.
The data: shipments, one row per shipment in March 2026: warehouse, carrier, ship date, promised date, delivered date (missing for two still in transit) and items.
What done looks like: lateness per delivered shipment, weekly on-time rates per warehouse with Monday weeks, carrier KPIs, a chart against the 90 percent target, the worst week, and the list of overdue shipments still in transit.
Operations dashboards live or die on definitions. Before any chart, decide what "on time" means (on or before the promised date), which shipments count (only those delivered), what a week is (Monday to Sunday here), and how to treat the ones still in transit. Write those decisions into the code, so the dashboard says the same thing every Monday. Each step adds to the same script.