Quarterly compensation for thousands of frontline staff.
Data landed in finance from dozens of teams via email, in Excel, unvalidated. Every month-end took roughly two weeks and produced errors that finance then had to chase. Reworked as a validated pipeline with error-catching before the data reached finance.
Month-end processing dropped from two weeks to one to two days.
The dashboards became one of the five most-viewed inside the company. The real problem wasn’t the data pipeline — it was the change-management around dozens of supplying teams. Stabilise the humans, then the data stabilises.