Case studies
Projects show what was built. Case studies show why, what changed, and what it was worth. Each one is written from the outcome backwards, with no programme data.
Replacing a static RAID spreadsheet with a dashboard a board can interrogate
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 governance tracker that carries its own audit trail
A 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 ProgrammeWorkforce data automation and £280k of validated savings
Routine 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 templateRedesigning project reporting for an NHS enabling works programme
Each 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.