Projects / PRJ-04
TPMA explorer
An explorer for types of potentially mitigable activity, the hospital activity that could be avoided, redirected or delivered more efficiently, to inform how a new hospital is sized.
- Ref
- PRJ-04
- Status
- Awaiting data
- Data
- Waiting on the dataset to be shared through internal channels. Nothing is published until then.
- Stack
- Power BI · DAX
- Last updated
- 02 Nov 2026
The question
When a new hospital is being planned, the bed and theatre numbers rest on a forecast of future activity. Part of that activity does not have to happen in a hospital at all. The size of that part, and how confident anyone can be about it, changes the size of the building.
Background
TPMA stands for types of potentially mitigable activity. The Strategy Unit identifies 34 of them across inpatient, outpatient and emergency care, each one a category of hospital activity that could be reduced through prevention, de-adoption, redirection or substitution, or efficiency. Not all of it can or should be avoided, which is exactly why it needs exploring rather than a single headline number.
Status
The report scaffold is built. The explorer is waiting on the dataset, which will come through internal channels. When it lands the first three views will be volume by TPMA, trend over time and variation by geography, built so a non-analyst can get from “how much” to “which activity” in two clicks.