Bernalo · case studies Get in touch →
← All case studies
Technology & programme

The finding was already calculated. It just wasn't first.

A redesign of the UK government's flagship major-projects report — the headline finding on project delivery confidence existed in the document, just after a cross-tab table that needed its own reading key.


The pattern

Tracking how a portfolio's delivery-confidence ratings move year over year is exactly the kind of finding a minister or committee wants in one glance. When that finding requires decoding a cross-tab table via a footnote titled "reading key" before it means anything, the report has done the hard analytical work and then hidden the payoff.

Exhibit C

The DCA transition matrix

Figure 9, page 13
Infrastructure and Projects Authority, Annual Report on Major Projects 2023-24. Reused under OGL v3.0, © Crown copyright.
Before
RedAmberGreenExempt
Red12900
Amber10122131
Green0480
Exempt1317
needs a "reading key" footnote to parse
After

64%

of projects held their rating year over year

10%
64%
Improved — 22 projects Stayed the same — 142 projects Worsened — 14 projects Exempt — 8 projects
PDF ↗ Read the full 56-page report

The percentages shown here already appear in the report, in a small summary table directly below the cross-tab — this redesign just leads with them instead.

What changed
  • 01

    Led with the already-calculated finding

    The 64% figure existed in the report already — it just followed the cross-tab instead of leading it.

  • 02

    Composition instead of a matrix

    A proportional breakdown needs no reading key — it shows parts of a whole directly.

  • 03

    Detail stays available, not gone

    The full cross-tab remains in the source report for anyone who wants project-level movement.

Why this matters

The analysis was already done

This wasn't a case of missing insight — the IPA had already calculated the headline number. The only fix needed was sequencing: put the answer before the working, not after it.

Have a report like this?

Send the page. I'll show you what it could look like.

If you've got a programme report, portfolio review, or board pack where the finding is already calculated but buried in a table, I'll take one page and redesign it — no cost, no obligation — the same way as above.