Start here: what these KPIs are for
Project management KPIs compare plan versus actual work, cost, schedule, risks, and resource use.
Use these pages when you need to explain a KPI to a beginner, build it in Excel, validate the inputs, or recreate the same logic in Power BI. Each page includes a plain-English definition, real-life example, Excel formula, DAX measure, interpretation notes, and common mistakes.
Best fora project status dashboard
Main questionWhether the project is on track or needs corrective action
Recommended viewTrend + target + segment
Project Management KPI list
📅
Change Request Rate
Change Requests / Total Requirements
📅Cost Performance Index
Earned Value / Actual Cost
📅Milestone Hit Rate
Milestones Hit / Planned Milestones
📅Project Budget Burn
Actual Cost / Budget
📅Project Cost Variance
Earned Value - Actual Cost
📅Project Schedule Variance
Earned Value - Planned Value
📅Resource Utilization
Billable or Productive Hours / Available Hours
📅Risk Closure Rate
Closed Risks / Identified Risks
📅Schedule Performance Index
Earned Value / Planned Value
📅Task Completion Rate
Completed Tasks / Total Tasks
How to use these KPI formulas
- Pick one KPI and confirm the business definition.
- Add the inputs to a clean Excel table, one row per period or segment.
- Paste the formula from the KPI page and format the result correctly.
- Add a target or benchmark column so the number has context.
- Link related KPIs together instead of judging one metric alone.