ElviraSH's avatar
ElviraSH
Advocate I
1 year ago

Earned Value Management Report

Key Metrics and Visuals

The report presents core EVM metrics, including:

  • Planned Value (PV): Shown in a line chart, this represents the authorized budget assigned to scheduled work over time, giving users a clear view of planned progress.
  • Earned Value (EV): Another key line chart tracks the value of work actually performed, allowing easy comparison with the PV to understand performance against the plan.
  • Actual Cost (AC): A stacked bar chart visualizes the actual costs incurred, facilitating a comparison with earned value to track cost performance.
  • Cost Performance Index (CPI): Displayed in a KPI card with visual thresholds, this metric provides a snapshot of cost efficiency, with intuitive color coding to indicate whether the project is under or over budget.
  • Schedule Performance Index (SPI): Similar to CPI, this gauge visual highlights the project’s schedule efficiency, enabling quick identification of schedule issues.

Trend Analysis

To track performance over time, the dashboard includes:

  • CPI and SPI Trends: Line graphs showing how cost and schedule efficiency evolve throughout the project’s lifecycle, offering clear visual indicators of improvements or declines.
  • Cost and Schedule Variance: Charts for cost variance (CV) and schedule variance (SV) are available, illustrating periods of over or underperformance, helping to pinpoint critical phases or activities.
  • Forecasting Metrics: The report includes projections for Estimate at Completion (EAC) and Estimate to Complete (ETC), displayed in line charts that predict the total cost and future expenditures of the project based on current performance.

 

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi, How did you choose the color theme fot this report. Are you using 3rd party application or did you do it all by yourself?

    Also, can I please get this pbix file and data for self practice?

    • ElviraSH's avatar
      ElviraSH
      Advocate I

      Hi,

      I did it by myself by customising a standard theme. 
      I cannot share the pbix. 

  • Hello, good evening, sir. Could you please send me the name of this visual in Power BI? I'd really like to use it in my models.
    Please.

  • RazJ's avatar
    RazJ
    New Member

    Well Done, are you able to share the schema?