Projects / PRJ-02
PMO central portfolio dashboard
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.
- Ref
- PRJ-02
- Status
- In progress
- Data
- Synthetic programme regenerated every Monday. The benchmark layer uses public NISTA major projects data, published under the Open Government Licence v3.0.
- Stack
- Power BI · DAX · Power Query · Python · GitHub Actions
- Last updated
- 02 Nov 2026
The problem it solves
A PMO usually reports from four places at once. The portfolio register says what each project costs and when it finishes. The RAID log says what might go wrong. The action tracker says who promised what. The finance report says where the money went. Each is maintained separately, so the board pack is stitched together by hand every cycle and is out of date by the time it is read.
The central dashboard puts all four into one model with shared dimensions, so a question like “which workstream has the most high-exposure risks, the most overdue actions and the biggest forecast overspend” is one click, not an afternoon.
How it is built
- Data. The synthetic programme engine runs a fictional £490m hospital programme forward one week every Monday and publishes four CSVs to /data/ on this site.
- Ingest. Power BI reads those files straight from the web, so a scheduled refresh picks up the new week without a gateway or a manual upload.
- Model. A star schema with four fact tables (portfolio, RAID log, actions, weekly history) sharing workstream, owner role and date dimensions.
- Pages. Portfolio overview, RAID exposure, mitigation journey, action ageing, and budget against forecast.
- Benchmark. NISTA publishes a Red, Amber or Green delivery confidence rating for every project on the Government Major Projects Portfolio each year. The overview sets the synthetic portfolio’s mix against the published one, so the numbers have a real-world reference point.
Status
The data engine is live and the snapshot below is rebuilt from it on every deploy. The Power BI report pages are in build on personal hardware. The .pbix and a walkthrough of the model and measures will be published here when they are ready.
Live snapshot
Synthetic data, regenerated every Monday
Halden Vale Health Campus Programme
As at Mon 16 Nov 2026 · Week 28 · 9 projects
Open risks
45
High exposure
11
Overdue actions
7
Forecast against budget
+£5.4m
| Ref | Risk | Score | Trend |
|---|---|---|---|
| R-051 | Legacy system decommissioning dependencies not mapped | 25 | Stable |
| R-053 | Network hardware lead times extend | 25 | Stable |
| R-011 | Funding drawdown profile misaligned with spend | 20 | Falling |
| R-045 | Training plan for new building not resourced | 20 | Stable |
| R-061 | Design freeze slips due to late clinical change requests (fit-out) | 20 | Stable |
Raw data portfolio.csvraid_log.csvactions.csvweekly_history.csv