Summary

This Power BI project portfolio dashboard by Abigail Adeleye provides a consolidated view of 97 projects for PMO leaders and portfolio managers. It brings project health, progress, schedule and cost variance, risks, resource capacity, and expected benefits into one interactive report.

The dashboard was created for the FP20 Analytics and ZoomCharts Challenge 41, which focused on project portfolio performance analysis.

Key Insights of the Power BI Project Portfolio Variance and Risk Dashboard

The report is structured in three pages: Portfolio Performance, Performance Drivers, and Risk and Action. Its main analysis areas include:

• Portfolio health and progress: monitor the overall health score, actual progress, and the gap between planned and actual delivery.
• Schedule and cost variance: compare project performance and identify initiatives with delays, overruns, or other delivery inefficiencies.
• Performance drivers: analyze results across programmes, business units, delivery locations, and strategic themes.
• Risk and action analysis: compare project-level risk exposure, mitigation activity, resource capacity, and expected benefits.

Interactive ZoomCharts Scatter, Combo, Combo Bar, and Timeline visuals make it easier to identify outliers and investigate the projects that require management attention.

How to Use This Power BI Project Portfolio Variance and Risk Dashboard

Click active chart elements to filter the report and move from the portfolio overview to specific programmes, business units, strategic themes, or projects. Use the variance and risk views to compare underperforming initiatives and prioritize recovery or mitigation actions.

Download the .pbix template to review the report model, calculations, and visual settings in Power BI Desktop, then connect it to your own project portfolio data.