Case 02 / Power BI

Where the handover schedule is lost

Cycle-time analysis across the handover bundles, measured against the agreed standards and reported to the Ministry of Finance as program owner.

Role
Analysis, dashboards, reporting
Reported to
Ministry of Finance (program owner)
Sample
22 to 79 bundles per measure
Tools
Power BI, Excel

Finding

Waiting, not review, is the bottleneck. Consultant review typically takes 2 to 10 days. Time spent waiting between steps makes up most of the elapsed time, and in the worst bundles runs to hundreds of days.

Consultant review2 to 10 d
Longest waits314 to 495 d

Bar lengths are drawn to the same scale. The longest waits are the four highest values across the sampled bundles.

HLGA release against the 3-day standard

6 daysMedian release time, against a 3-day standard
32 daysMean release time, pulled up by a long tail
11×2,263 days used across 70 bundles, against 210 at standard
31% on time or early69% later than the standard
At standard210 d
Actual2,263 d

Steps after acceptance

Acceptance to site observation. 22 bundles, sorted. Mean 32 days, total 707 days.
Acceptance to report issue. 34 bundles, sorted. Median 52 days, mean 95. Four bundles took 327 to 642 days.
13 daysMedian acceptance to site visit, 79 bundles
30 daysMean for the same 79 bundles; total 2,336 days
4bundles above 300 days that distort the mean

How I report it

  • Median and mean together. The median is the typical bundle, the mean shows what the tail costs.
  • Every duration against its standard (3 days for HLGA, for example), so the gap is visible.
  • Outliers handled one by one. A bundle at 600 days is a case to resolve, not an average to explain.
  • Waiting time as its own measure, separate from review time, so each side can see what it owns.

Dashboard

Screenshot slotReplace with an anonymised Power BI page: KPI tiles, S-curve, approval trend.
Handover KPI dashboard. Package status, approval rates, delay trends and S-curves.

Charts use samples of the program with bundle names and codes removed. Sample sizes are stated under each chart.