Manufacturing · Case study
“Every report started with a manual export from SAP.”
A manufacturing and service group moved 40 reports off manual exports and onto one Microsoft Fabric model.
40 → 0
reports fed by manual SAP exports
3
business units on one model
5
people on the client's data team run it
The problem
The reports stopped when one person was away.
Every morning, one person exported SAP data into Excel files, and the reports read from those files:
When that person was away, the reports stopped
Nobody could say which export a number came from
So finance checked the important numbers again by hand before each meeting.
At a glance
Manufacturing and service group
Head of data, finance, the client's data team
Microsoft Fabric, Power BI, SAP as the source
Pipelines, lakehouse, one semantic model, report migration, training
What we built
Pipelines, one model, and a team to run it.
1
A foundation that loads itself
Nothing waits for an export anymore. One semantic model on top serves finance, sales and service.
2
Numbers checked against SAP
Before an old report was switched off, its totals were compared with SAP. A report moved only when every total matched.
3
A team that runs it
The client's five-person data team runs the pipelines and the model. We trained them on the new setup at handover, and every change goes through test before it reaches a report.
The outcome
