Healthcare
Complete
NHS National Dashboard
Three hundred million rows of national data, in front of trust managers the moment they ask for it.
- Client
- NHS trusts (name withheld)
- Type
- National reporting platform
The problem
Reporting at national scale usually means waiting. The dataset was large enough that a straightforward report would have taken minutes to answer a single question — long enough that people stop asking, and start making decisions without the numbers.
The outcome
Trust managers query the full national dataset and get answers back immediately, with row-level security ensuring each trust sees only its own data. The refresh runs incrementally overnight rather than rebuilding from scratch.
- 300m+
- rows queried instantly
- Nightly
- incremental refresh
Built with
- Power BI
- MSSQL
- DAX
- Azure
- Power Automate
- SharePoint
- Windows Server