Context
Each contractor sent in progress and costs in their own format, on their own timetable, and split the work up in their own way. Leaders spent their meetings arguing about whose numbers were right instead of what to do about them.
My contribution
I agreed one standard layout for everyone's data, built the steps that convert each contractor's report into it, and designed the Power BI dashboards on top. I also set up a way for teams to add their commentary so it sits beside the numbers it explains.
Approach
Most of the work is agreement, not technology. Everyone reports on the same date. Everyone's work is mapped to one shared list. Data is checked when it arrives, and anything wrong goes back to the contractor to fix rather than being patched quietly. Commentary is stored separately, and each contractor only sees their own.
The interactive example below walks through this with made-up data.
Outcome
Leaders saw one clear picture of time and cost, and meetings moved on to what to do about it. Specific measures will be added here once verified and approved for publication.
Reflection
The hardest part was never the dashboard. It was getting everyone to agree what each number means. Next time I'd agree and publish those definitions before building anything.