LOCAL GOVERNMENT CASE STUDY
Transforming council-wide reporting from Business Objects to Power BI
The Challenge
Trafford Council was working with a complex and fragmented reporting landscape built on legacy Business Objects reports across multiple service areas, including Children’s Services, Adult Social Care, Education, and Information Governance.
Reporting was difficult to maintain, slow to adapt, and inconsistent across teams, making it harder for decision-makers and frontline staff to access trusted, timely insight.
The Solution
Flow Data delivered a modern Power BI reporting platform underpinned by well-designed data models, supporting consistent reporting across multiple service areas.
A key outcome was the SEND Power BI app, built on a single underlying data model and bringing together 14 strategic and operational reports in one place.
The Impact
- Trusted, consistent reporting across services
- Reduced reliance on manual spreadsheets
- Improved confidence in data and insight
- Reporting used from frontline staff through to Director level
- Stronger internal data capability and governance
“The SEND Power BI app has been a game-changer for us, bringing together strategic and operational reporting from a single data model.”
Thomas Stephenson, Data Manager — Trafford Council
The Approach
- Stakeholder engagement across services
- Designing reusable, structured data models
- Migrating reports from Business Objects to Power BI
- Establishing reporting standards and governance
- Training and supporting internal teams