Executive dashboards for a healthcare group
Board and hospital leads share one Power BI model. Each person sees only the site they may open.
- Client
- UK Healthcare Group
- Industry
- Healthcare
- Services
- 1 Azure services
Challenge
Each hospital sent its own spreadsheet, and the board pack used a different waiting-list number from the site report.
Solution
We built a Power BI semantic model on the agreed activity tables, with row-level security by site and a short set of reports for the board.
Results
- One waiting-list figure in the board pack
- Site leads see only their own hospital
- Refresh failures alert the data team the same morning
Services used
Planning a similar project?
Tell us the systems you run today and the figure or feed you need. We will reply within one working day.
