Portfolio / Rev 2026 Mahe Mishra, home

Projects / PRJ-04

Awaiting data

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.