
Product case study
From $149 one-timePOWER BI EXECUTIVE CONTROLSپک داشبورد مدیریتی Power BI
Executive clarity from Primavera P6 and MSP schedules, presented in Power BI.
A production-grade Power BI template (.pbit) that transforms complex P6 and MSP schedule data into decision-ready executive dashboards. Delivers interactive S-curves, milestone slip heatmaps, Earned Value KPI drilldowns, and portfolio WBS rollups — all without custom backend servers or expensive enterprise middleware.
Product snapshot
- Platform
- Power BI Desktop / Power BI Service
- Data Sources
- Primavera P6 (XER/Excel) & MS Project (MPP/XML)
- Key Features
- Dynamic S-Curve, Milestone Heatmap, EVM Drilldown
- Delivery
- Pre-configured .pbit + DAX Model Guide
The product question
Why do executive project dashboards take weeks to refresh and still fail to show root causes?
Project directors rarely have the time or P6 expertise to interrogate multi-thousand-activity schedules. Instead, planning teams spend days manually formatting slide decks and static PDF charts that are already outdated upon delivery. When a milestone slips, senior leadership cannot easily see whether it was caused by engineering approvals, procurement lead times, or civil construction delays. Off-the-shelf BI tools often stumble over schedule logic, calendar shifts, and proper cumulative progress weighting.
Key product decisions
01A parameterised template, zero recurring cloud rent
Rather than locking the client into a subscription software-as-a-service, the solution is distributed as a clean, documented .pbit template. The client connects their native exports and retains full data sovereignty within their existing Microsoft ecosystem.
02Pure DAX schedule mechanics
Schedule data requires careful time-intelligence calculations that respect project data dates, baseline variances, and working calendars. The template features optimized DAX measures for SPI, CPI, To-Complete Performance Index (TCPI), and cumulative progress curves that adjust dynamically to any WBS slicer.
03Milestone slip matrix instead of plain lists
A table of delayed milestones tells what is late; a timeline matrix reveals the systemic pattern of slippage across reporting periods. Executives can immediately pinpoint whether slips are accelerating and identify cascade risks on the critical path.
04Dual light and dark executive themes
Engineered to fit high-stakes boardrooms and corporate monitoring screens, with high-contrast data visualisations that prevent misinterpretation and meet corporate accessibility standards.


Current outcome
Current outcome
A high-performance executive dashboard suite deployed across multi-million dollar engineering and construction projects. Directors gain instant visibility into cost and schedule variance across contractors, whilst planners save 15+ hours every monthly reporting cycle.
My role
Data modeling, Power BI template architecture, DAX measure formulation, UI/UX dashboard layout, and P6/MSP export integration testing.
Next step
The pack includes the unlocked .pbit template, sample datasets, DAX formula cheat-sheet, and comprehensive onboarding documentation. Tailored customisations and enterprise gateway setups are available.