
Portfolio Health Dashboard Builder
Synthesize defense portfolio data into executive health dashboards in 30 minutes
What You Can Do
You consolidate disparate program data—PDRs, CDRs, budget burn-downs, risk registers, and resource plans—into unified health metrics and executive narratives. Claude identifies hidden schedule bottlenecks, resource contention, and cascading risks across your portfolio, then generates comparison matrices and decision-ready recommendations for steering committees in a fraction of traditional synthesis time.
Features
consolidates status reports, schedules, budgets, and risk registers from 5-15 concurrent defense programs into structured portfolio format
detects resource conflicts, schedule bottlenecks, and interdependencies that may cascade across programs
generates natural-language summaries with decision-critical insights for steering committees and budget reviews
produces standardized KPI summaries (schedule variance, budget execution, technical risk scores, resource utilization)
creates rapid trade-study frameworks for portfolio rebalancing and milestone-gate decisions
flags emerging risks and variance patterns before escalation, with portfolio-level trend analysis
surfaces shared resource contention and suggests reallocation scenarios
outputs consistently formatted executive briefs ready for stakeholder distribution
Example Output
Portfolio Health Snapshot (Q4 2024)
Overall Health: YELLOW (2 programs at risk)
| Program | Schedule | Budget | Tech Risk | Resource Load |
|---|---|---|---|---|
| SENTINEL | On Track | +3% variance | MEDIUM | 92% |
| APEX-II | -2 weeks | -8% favorable | HIGH | 103% |
| GUARDIAN | On Track | +12% variance | LOW | 67% |
Critical Issues:
- ✓ APEX-II schedule slip cascading to SENTINEL integration phase (4-week exposure)
- ✓ Avionics engineering team 103% allocated; recommend resource swap with GUARDIAN subsystem team
- ✓ Supply chain risk emerging on power distribution units (2 suppliers, 16-week lead time)
Recommendation: Accelerate GUARDIAN milestone 2 by 3 weeks to create resource buffer; redirect avionics talent to APEX-II critical path.
What's Included
- SKILL.md: Portfolio Health Dashboard Builder skill instruction file
- Portfolio Data Intake Template: standardized form for program status, budget, schedule, and risk inputs
- Executive Dashboard Framework: pre-formatted HTML/markdown templates for health snapshots and KPI summaries
- Risk Aggregation Checklist: cross-program dependency mapping and risk cascade detection workflow
- Comparison Matrix Generator: structured prompts for trade-study analysis and rebalancing recommendations
Who It's For
- Portfolio Managers — coordinating 5-15 concurrent aerospace & defense programs requiring monthly synthesis and executive reporting
- Program Directors — consolidating subprogram health data into portfolio-level steering committee briefings
- Portfolio Risk Officers — aggregating risk registers and identifying cross-program vulnerabilities and cascading threats
- Defense Budget/Finance Analysts — synthesizing program budget variances and resource utilization for executive investment reviews
- Schedule/Integration Leads — tracking interdependencies and bottlenecks across concurrent development and production programs
Best For
- Monthly portfolio health synthesis and executive steering committee briefings
- Quarterly portfolio rebalancing and milestone-gate trade-study analysis
- Budget execution reviews and variance analysis across concurrent programs
- Schedule risk early-warning trending and bottleneck identification
- Resource conflict resolution and reallocation scenario planning
- Cross-program dependency mapping and integration risk assessment







