A plug-and-play Excel dashboard for SPI, CPI, risk exposure, utilization and milestone health — plus a step-by-step guide to rebuild the exact same thing as a live Power BI report, with every DAX measure written out for you.
Use the Excel dashboard on its own — it's the whole product for most PMOs — or follow the guide to rebuild the same thing as a live Power BI report.
A working dashboard with realistic sample data already loaded across three sample projects — delete the samples, paste in your own, done.
9-page guide: what each KPI means and why it's on the dashboard, how the data model fits together, and a full written walkthrough for Power BI Desktop.
Each one maps to a different way a project quietly goes wrong — behind schedule, over budget, unmanaged risk, team over/under-loaded, or a missed milestone nobody flagged in time.
Above 1.0 = ahead of schedule, below = behind. The number that catches slippage before the go-live date does.
Above 1.0 = under budget for the work delivered. The first number every sponsor asks for.
Pairs with SPI — 60% complete can still be dangerously behind if the pace doesn't match.
Should trend down over the life of a project, not up. A single 5×5 risk stands out immediately.
Over 100% flags burnout risk. Under flags idle time or unlogged off-plan work.
Calculated live off one Report Date cell — no more manually re-tagging status every Monday.
A stylized preview of the Dashboard tab — real KPI cards, real chart types, illustrative numbers.
Same structure whether you stay in Excel or move to Power BI.
Drop your details and I'll follow up with how to buy and get it delivered.
No. The Excel file works fully on its own — every KPI card and chart is a native Excel formula. Power BI is an optional upgrade path covered in Section 5 of the guide.
No — you build the Power BI report yourself using the written walkthrough and the ready-to-paste DAX measures in the workbook. This keeps the toolkit editable and version-independent instead of locking you to one Power BI Desktop release.
Not yet — the guide is a detailed written walkthrough instead, which most buyers find faster to follow at their own pace and easier to keep open side-by-side with the workbook. If that changes, existing buyers get the update free.
Yes — the sample data already models three concurrent projects rolling up into one dashboard. Add or remove ProjectIDs freely.
ACMPro — 25 years across IT and project management, corporate training and Power BI / analytics programmes. This toolkit is the same framework taught in those sessions, packaged to use immediately.