Weekly management reporting depended on spreadsheets that brought together information from plant, labour, project, and schedule data sources that were not naturally aligned.
The spreadsheets had accumulated structural fragility over time. Formulas that referenced fixed row positions broke without warning when someone inserted or deleted a row, and the error often went unnoticed until a report produced an obviously wrong number. There was no version control — multiple copies of the same file circulated across the team, and it was rarely clear which version reflected the current week’s data or the most recent structural change.
Data quality problems ran deeper than formatting. The weekly reports required manual joins across separate sheets — plant records from one source, labour allocations from another, project assignments from a third. Each join was an opportunity for misalignment. Assets were referenced by slightly different identifiers across systems, staff names did not always match between the scheduling sheet and the payroll export, and the rules for how to handle part-week allocations were undocumented and applied inconsistently.
The business needed a dashboard that could turn fragmented operational data into a repeatable reporting view for management, without hiding the realities of inconsistent upstream systems.