Portfolio / Rev 2026 Mahe Mishra, home

Projects / PRJ-02

In progress

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

  1. 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.
  2. 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.
  3. Model. A star schema with four fact tables (portfolio, RAID log, actions, weekly history) sharing workstream, owner role and date dimensions.
  4. Pages. Portfolio overview, RAID exposure, mitigation journey, action ageing, and budget against forecast.
  5. 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

How this is generated

Open risks

45

+1 vs last week w/c 31 Aug: 38 open risks w/c 7 Sept: 40 open risks w/c 14 Sept: 41 open risks w/c 21 Sept: 40 open risks w/c 28 Sept: 39 open risks w/c 5 Oct: 40 open risks w/c 12 Oct: 40 open risks w/c 19 Oct: 40 open risks w/c 26 Oct: 42 open risks w/c 2 Nov: 43 open risks w/c 9 Nov: 44 open risks w/c 16 Nov: 45 open risks

High exposure

11

No change vs last week w/c 31 Aug: 7 high exposure risks w/c 7 Sept: 10 high exposure risks w/c 14 Sept: 12 high exposure risks w/c 21 Sept: 12 high exposure risks w/c 28 Sept: 10 high exposure risks w/c 5 Oct: 10 high exposure risks w/c 12 Oct: 9 high exposure risks w/c 19 Oct: 9 high exposure risks w/c 26 Oct: 9 high exposure risks w/c 2 Nov: 10 high exposure risks w/c 9 Nov: 11 high exposure risks w/c 16 Nov: 11 high exposure risks

Overdue actions

7

+1 vs last week w/c 31 Aug: 4 overdue actions w/c 7 Sept: 4 overdue actions w/c 14 Sept: 7 overdue actions w/c 21 Sept: 9 overdue actions w/c 28 Sept: 2 overdue actions w/c 5 Oct: 5 overdue actions w/c 12 Oct: 7 overdue actions w/c 19 Oct: 7 overdue actions w/c 26 Oct: 6 overdue actions w/c 2 Nov: 7 overdue actions w/c 9 Nov: 6 overdue actions w/c 16 Nov: 7 overdue actions

Forecast against budget

+£5.4m

1.11% on £490m
Open risks by residual exposure
  • High, 15 to 25 11
  • Medium, 8 to 14 19
  • Low, 1 to 7 15
Projects by delivery confidence
  • Red 1
  • Amber 1
  • Green 6
  • Not started 1
Top five risks by residual score
Ref Risk Workstream Score Trend
R-051 Legacy system decommissioning dependencies not mapped Digital and IT 25 Stable
R-053 Network hardware lead times extend Digital and IT 25 Stable
R-011 Funding drawdown profile misaligned with spend Finance and Commercial 20 Falling
R-045 Training plan for new building not resourced Clinical Mobilisation 20 Stable
R-061 Design freeze slips due to late clinical change requests (fit-out) Main Build 20 Stable

Raw data portfolio.csvraid_log.csvactions.csvweekly_history.csv