Building Portfolio Health Dashboards

The Portfolio Dashboard Purpose

A portfolio health dashboard answers three questions for the executive team: 1. Are our investments healthy? (Aggregate delivery performance) 2. Are we investing in the right things? (Strategic alignment) 3. Where should we intervene? (Exceptions that need attention)

It's not a detailed delivery report — that's the programme dashboard's job. The portfolio dashboard is a strategic decision tool that operates at the investment level.

Dashboard Architecture

Layer 1: Portfolio Summary (10-second view)

• Overall portfolio health: Single RAG indicator with trend
• Key number: "X of Y programmes on track" or "Portfolio ROI: X%"
• Investment allocation: Pie chart showing spend by strategic theme
• Attention needed: Count of Red/Amber programmes requiring intervention

Layer 2: Programme Performance (2-minute view)

Table of all programmes with:

• Programme name and sponsor
• RAG status (delivery health)
• Budget performance (% spent vs % delivered)
• Milestone status (next milestone, on track?)
• Benefits status (on track to realise?)
• Key risk (top risk per programme, one line)

Sort by RAG (Red first) so attention goes to problems immediately.

Layer 3: Strategic Metrics (5-minute view)

• Capacity utilisation: Demand vs capacity across the portfolio
• Investment by theme: Spend aligned to each strategic objective
• Benefits pipeline: Expected benefits by quarter (forecast vs actual)
• Portfolio velocity: Initiatives completed per quarter (trend)
• Risk exposure: Aggregate risk score across all programmes

Defining Portfolio RAG

Portfolio-level RAG must be defined consistently across all programmes. Without standard definitions, every programme reports Green and the portfolio dashboard is meaningless.

Green (Healthy):

• Delivery on track (milestones within 2 weeks of plan)
• Budget within 5% of forecast
• No critical risks without mitigation
• Benefits on track to be realised
• Team health stable

Amber (At Risk):

• Delivery 2-4 weeks behind plan
• Budget 5-15% over forecast
• Critical risks with mitigation in progress
• Benefits at risk (adoption concerns, dependency issues)
• Team health declining

Red (Intervention Required):

• Delivery >4 weeks behind plan
• Budget >15% over forecast
• Critical risks without effective mitigation
• Benefits unlikely to be realised without significant change
• Team health critical (attrition, burnout, conflict)

The watermelon test: If >80% of programmes are Green for 3+ months, your thresholds are too generous. Recalibrate. A healthy portfolio typically shows 60-70% Green, 20-30% Amber, and 5-10% Red.

Data Sources and Automation

Automated Data (Real-Time)

• Budget actuals from finance systems
• Delivery metrics from Jira/Azure DevOps (velocity, throughput, cycle time)
• DORA metrics from CI/CD pipelines
• Resource allocation from HR/resource management systems

Manual Data (Weekly/Fortnightly)

• RAG status and commentary from Programme Managers
• Risk updates and mitigation progress
• Benefits tracking updates
• Milestone forecast updates

The Data Quality Challenge

Portfolio dashboards are only as good as their input data. Common issues:

• Programme Managers report optimistically (always Green)
• Data is stale (last updated 3 weeks ago)
• Definitions are inconsistent across programmes
• Manual data entry is forgotten or deprioritised

Fix: Automate what you can. For manual inputs, make it part of the governance rhythm (PMO collects every Friday). Challenge RAG assessments that don't match the underlying data.

Using the Dashboard in Governance

Monthly Portfolio Board (90 min)

1. Dashboard walk-through (15 min): Portfolio summary, exceptions highlighted 2. Red programme deep-dive (20 min per Red): What's wrong? What's the recovery plan? What decision is needed? 3. Investment review (20 min): Is allocation still aligned with strategy? Any rebalancing needed? 4. New demand (15 min): New initiatives requesting funding. Prioritisation decision. 5. Benefits check (10 min): Are completed programmes delivering expected benefits?

Quarterly Strategic Review (half day)

• Portfolio performance vs strategic objectives
• Investment rebalancing for next quarter
• Programme start/stop/continue decisions
• Capacity planning for next quarter
• Benefits realisation across the portfolio

Portfolio Metrics That Matter

Delivery health:

• % of programmes on track (Green)
• Aggregate milestone delivery rate
• Portfolio-level budget performance (CPI)

Strategic alignment:

• % of investment aligned to top 3 strategic priorities
• Initiatives without clear strategic linkage (should be zero)

Value delivery:

• Benefits realised vs projected (across completed programmes)
• Time to value (months from approval to first benefit)
• Portfolio ROI (benefits delivered ÷ total investment)

Flow:

• Portfolio throughput (initiatives completed per quarter)
• Average time in delivery (months from start to completion)
• WIP count (active initiatives — should have a limit)

Anti-Patterns

The vanity dashboard: Shows metrics that look good but don't drive decisions (total initiatives ever completed, cumulative investment). Fix: every metric must answer a decision question.

The blame dashboard: Used to identify underperforming Programme Managers rather than underperforming investments. Fix: the dashboard measures investments, not people.

The stale dashboard: Updated monthly at best, showing data that's 3-4 weeks old. Fix: automate real-time data. Manual inputs updated weekly.

The everything dashboard: 50 metrics on one screen with no hierarchy. Fix: 5-7 metrics on the primary view. Everything else is drill-down.

---

Download the [Portfolio Dashboard template](/templates) for a ready-to-use executive portfolio health reporting format.