Map the real close
We traced every export, handoff and reconciliation to see exactly where time and trust were lost.
CECorona Energy
Energy Finance Data automation
Unifying 17 data sources into one governed layer
A leading energy supplier consolidated fragmented trading, billing and finance data into a single Microsoft Fabric semantic model, and gave the team a month-end they could finally trust.
One source of truthThe outcome, in numbers
Measured against the position we started from, in the first year after go-live.
17
Disconnected systems unified into one model£0.6M
Annual saving in recovered finance time9 → 2
Days to a board-ready month-endThe challenge
A confident month-end was almost impossible
Trading, billing and finance data lived in 17 disconnected systems. Every close began with the same ritual: export, reshape, reconcile and hope. By the time the numbers agreed, the month they described was already old news.
The team wasn’t short on talent, they were short on a single version of the truth. Senior analysts spent their first two weeks each month rebuilding the same workbooks instead of explaining what the numbers actually meant.
- 17 source systems with no shared definitions, so the same metric rarely matched twice
- A nine-day close driven by manual exports and fragile spreadsheet chains
- No audit trail, so questions in the boardroom were answered a week later
How we approached it
From tangled exports to one governed layer
We delivered in two-week sprints, putting a working report in front of finance early rather than saving a big reveal for the end.
Unify the sources
All 17 systems were brought into one governed Microsoft Fabric model with shared, agreed definitions.
Automate the busywork
Power Automate took over posting and reconciliation, so the close runs itself and leaves an audit trail.
Report with confidence
Role-secured Power BI dashboards where every figure traces back to source, ready before the meeting.
What we built
One model, one dashboard, one number everyone trusts
A governed semantic layer feeds a live board pack that assembles itself each morning, with drill-down to the transaction behind every figure.
Governed semantic layer
Shared definitions across trading, billing and finance so a number means the same thing everywhere.
Automated daily refresh
Data lands and reconciles before 6am, so the team starts the day on current reality.
Full traceability
Every figure drills back to source, so boardroom questions are answered in the room.
The results
A month-end the whole business trusts
- One governed source of truth across the entire business
- Close cut from nine days to two, with time back for analysis
- £0.6M in recovered finance time each year
- Board questions answered live, from data everyone believes
For the first time, we walk into the board meeting knowing every number will hold up. Finance spends its energy on the story now, not on rebuilding the spreadsheet.
Corona Energy
Does this sound familiar?
If you recognise these challenges in your own numbers, let’s have a quick call. We’ll talk through what the solution could look like for your business and how to get clarity and confidence back in your data, with no slides and no sales pitch.