RAID dashboard in Power BI
Interactive risk and issue reporting for a £1B+ NHS redevelopment programme, replacing static spreadsheet tracking. Version 3 is built, three pages around the RAID review.
Register / Mahe Mishra / South Yorkshire, UK
Power BI, DAX, Python and SQL, running the reporting on a £1B+ NHS capital programme.
I am Mahe Mishra, at North West Anglia NHS Foundation Trust on the Hinchingbrooke Hospital Redevelopment Programme, a £1B+ NEC scheme. I build the dashboards, trackers and automation that tell a programme board the truth.
Interactive risk and issue reporting for a £1B+ NHS redevelopment programme, replacing static spreadsheet tracking. Version 3 is built, three pages around the RAID review.
One view of every project, risk, action and pound across a PMO. Built in the open on a synthetic programme that moves forward every Monday.
The fortnightly action tracker for an enabling works governance group, built so every row carries its own audit trail and the chair sees what lands before the next meeting.
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.
Automated recurring HealthRoster workforce data workflows and management information reporting for an NHS trust, cutting 25 to 30 percent of the time spent on routine reporting.
A Python engine that runs a fictional £490m hospital programme forward one week every Monday, so every dashboard on this site has moving data and none of it is real.
A fictional £490m hospital programme that moves forward every Monday on its own. Every risk, action and figure below is synthetic, rebuilt by a scheduled job, and published as open CSVs that the dashboards read from.
Synthetic data, regenerated every Monday
As at Mon 16 Nov 2026 · Week 28 · 9 projects
Open risks
45
High exposure
11
Overdue actions
7
Forecast against budget
+£5.4m
A £1B+ redevelopment programme's RAID log could list risks but could not say what had changed. A Power BI prototype on dummy data was endorsed, taken forward, and earned named ownership of RAID reporting.
Fortnightly meeting record turned into a chair-ready trackerA fortnightly governance group needed an action tracker the chair could trust without re-reading the meeting. A small set of hard rules did more than any formula.
£280k validated workforce savings for the Cost Improvement ProgrammeRoutine HealthRoster reporting was eating time and introducing rekeying errors. Python automation cut 25 to 30 percent of the workload, and workforce analysis for the Trust's Cost Improvement Programme delivered £280k of validated savings.
11 enabling works projects, one metrics-led templateEach enabling works project reported fortnightly on two narrative slides, so nobody could see at a glance whether a project was safe, on budget or on time. A metrics-led template, designed with the workstream chair, puts health and safety, finance, programme, change control and risk on the page.
Analysis
Reporting
PMO
Build
Open to conversations about PMO data, BI and analyst roles. The fastest route is email.
mahaswar.mishra@gmail.com