BFVZ PowerHealth

BFVZ POWERHealth is a schedule health analysis visual for Power BI that performs automated DCMA 14-point assessments across multi-project programs. THE PROBLEM Project controls teams spend hours every update cycle manually evaluating schedule quality — checking for missing logic, negative float, overallocated resources, and missed baselines across hundreds or thousands of tasks. The results live in spreadsheets that are outdated by the time they reach leadership. Meanwhile, schedulers know their resource plan is infeasible but have no fast way to identify which conflicts are resolvable and which require management decisions. WHO THIS IS FOR POWERHealth is built for project controls professionals, PMO analysts, program managers, schedulers, and construction managers who manage CPM-driven schedules and need to assess, communicate, and act on schedule health — without leaving Power BI. It serves any industry that uses predecessor-linked scheduling: energy, utilities, telecom, pipeline, water infrastructure, data center construction, oil and gas, transportation, and commercial building programs. WHAT IT DOES Connect your schedule data and instantly see a weighted health grade, 14 traffic-light metrics, and a sortable risk register — all updating in real time as your data changes. Dashboard and Grading — All 14 DCMA metrics evaluated against configurable thresholds with weighted scoring. Letter grade (A through F) and numeric score. Program-level aggregation with task-count-weighted averaging. Project comparison table with timeline bars showing actual vs baseline progress. Risk Classification — Every task classified into four severity tiers (Critical, At Risk, Watch, Healthy) based on 16 risk codes. Click any metric card to filter the register to that metric's flagged tasks. Sortable columns, severity filtering, and milestone performance tracking. Critical Path Analysis — Built-in CPM engine with phase-bridging, constraint-aware CPLI (FNLT/MFO deadlines drive float calculations), CP compression ratio, and near-critical path identification. Resource Leveling — Identifies overallocated resources, visualizes weekly utilization across your entire resource pool, and generates tri-strategy optimization recommendations (push, pull, compress). Full-program auto-solve with cascade detection. Accept or reject each recommendation individually. Unresolvable conflicts are diagnosed with specific reason codes and corrective actions. Lookahead Filtering — Configurable 2-week, 4-week, and 6-week lookahead windows with schedule compliance tracking. Replicates the standard construction lookahead practice inside Power BI. CSV Exports — Five export functions (status summary, risk register, optimization plan, leveling recommendations, unresolvable conflicts) generate copy-paste-ready output for Excel. Optimization exports include current and proposed dates so schedulers can apply shifts directly in Primavera P6 or Microsoft Project. Educational Tooltips — Every metric, KPI, risk code, and recommendation includes plain-language explanations. Three tooltip modes (Educational, Informational, Metrics Only) let teams learn as they work. 108 configurable properties across 12 format pane sections. Dark and light themes. Adjustable DCMA thresholds, scoring weights, and grade boundaries to match your organization's standards. Requires Power BI Desktop or Power BI Service. Schedule data with task IDs, dates, predecessors, and progress. Optional: baseline dates, resource assignments, constraint types.