PSA Project Scheduling Risk dashboard

The PSA Project Scheduling Risk dashboard enables you to:

  • View a prioritized list of your projects that are most at risk of going over or under schedule based on hours variance percentage.
  • Track the scheduled versus actual hours variance on your projects, and see how the variance has affected the revenue and costs for the last 13 weeks.
  • Predict risks to the project schedule for the next 13 weeks based on the hours variance for each resource for the last 13 weeks.
Note: The intended user for this dashboard is the project manager or services leader.

The dashboard is available only on the PS Cloud Advanced Analytics app and displays data from the Project Reporting dataset. For more details about the fields used by the dashboard, see Project Reporting Dataset Output Fields.

The dashboard is designed to complement the enhanced Project Management Workspace functionality available in PSA. For more information on this functionality, see Project Management Workspace.

Prerequisites

The PSA Project Scheduling Risk dashboard only displays active projects that have at least one week of historical scheduled and actual hours data and information for individual resources that have submitted at least one week's worth of hours on the project. You must also have at least one EvA record with the Time Period Type of Week. For more information, see Estimates Versus Actuals.

Notes:
  • This dashboard does not support daily bill rates.
  • This dashboard does not calculate revenue hours variance for fixed fee projects.

PSA Project Scheduling Risk Dashboard Guide

The PSA Project Scheduling Risk Dashboard has a revenue view and a costs view, with calculations on each view changing according to your selection of revenue or costs.

PSA Project Scheduling Risk Dashboard with Project Revenue Representation

The revenue view of the dashboard has the following elements.

PSA Project Scheduling Risk dashboard schematic highlighting the key elements of the project revenue view of the dashboard.

Project Costs Representation

The costs view of the dashboard has the following elements that differ from the revenue view.

PSA Project Scheduling Risk dashboard schematic highlighting the key elements of the project costs view of the dashboard.

Note: Toggle between Project Revenue and Project Costs to view the impact of schedule variance on your projects based on either revenue or costs.
PSA Project Scheduling Risk Dashboard Elements
Element Number Name Description Calculation Referenced Calculation Source Dataset
1. View By Project Revenue or Project Costs Picker Defines whether project revenue or project costs data is displayed on the dashboard. Not applicable Not applicable Project Reporting Dataset Output Fields
2.

Project List

Lists your riskiest projects in terms of variance from schedule. The project with the greatest variance is listed at the top.

 Not applicable Not applicable
3.

Sort By Picker

Sorts the project list by variance according to the following Sort By options:

  • Hours Variance % Last 13 Weeks, which is the percentage difference between the scheduled hours and actual hours of the last 13 weeks.
  • Hours Variance Total Last 13 Weeks, which is the total of the difference between the scheduled hours and actual hours of the last 13 weeks.
  • Scheduled Revenue for Next 13 Weeks, which is the scheduled revenue for the next 13 weeks, retrieved from the EvA records.

 Hours Variance % = (EvA Actual Hours - EvA Estimated Hours) / EvA Estimated Hours None
4.

Project Variance Bar

Project variance shown as an absolute value, with over scheduled values displayed in pink and under scheduled values displayed in blue.

A project is over-scheduled when the hours variance is over 0%, which indicates that there are more actual hours than scheduled hours for the last 13 weeks.

A project is under-scheduled when the hours variance is less than 0%, which indicates that there are fewer actual hours than scheduled hours for the last 13 weeks.

EvA Hours Variance filtered by EvA Time Period Type = Week and Project Name, then grouped by End Date (Week)

 

This value is derived by calculating the variance per resource, and aggregating to the project level.

None
5.

Total Hours Variance % (Last 13 Weeks)

Consolidated hours variance percentage for the selected project. 

The colors in the widget are represented in the same way as the legends on the project variance bar.

(Actual Hours - Scheduled Hours) / Scheduled Hours

(EvA Actual Hours - EvA Estimated Hours) / EvA Estimated Hours

or

EvA Hours Variance / EvA Estimated Hours
6.

Line Chart (last 13 weeks)

Displays the Scheduled Hours and Actual hours for the last 13 weeks.

Scheduled hours = EvA Estimated Hours

 

Actual Hours = EvA Actual Hours

 

Revenue Variance = EvA Actual Billable Amount - EvA Scheduled Amount

 None
7.

Prediction Flag

Indication of where the prediction for the next 13 weeks begins on the line chart. Prediction starts from the current week and projects 12 weeks into the future. 

 Not applicable Not applicable
8.

Line chart (next 13 weeks)

Displays the Scheduled Hours and Predicted hours for the next 13 weeks.

Scheduled Hours = EvA Estimated Hours

 

Predicted Hours =

EvA Estimated Hours - (Average Variance % for the last 13 weeks * EvA Estimated Hours)

This value is derived by calculating the variance per resource, and aggregating to the project level.

 None
9.

Chart legend

Legend for the information displayed on the chart, which consists of the following:

  • Actual Hours for the last 13 weeks

  • Scheduled Hours for the last 13 weeks and next 13 weeks

  • Predicted Hours for the next 13 weeks. This calculation is performed at the resource level and aggregated for the project.

    The resource's hours average variance % for the past 13 weeks is applied to the scheduled hours for the next 13 weeks, and a predicted hours value is calculated.

    For example: Resource A had an average of +20% variance for the last 13 weeks and the resource is scheduled for 5 hours per day for the next 13 weeks. So, the predicted hours for Resource A will be: 5*80% = 4 hours per day. The predicted hours for all the resources in the project are consolidated to arrive at the predicted hours for a project.

Actual Hours = EvA Actual Hours

 

Scheduled Hours = EvA Estimated Hours

 

Predicted Hours = EvA Estimated Hours - (Average Variance % for the last 13 weeks * EvA Estimated Hours)

 None
10.

View project details

Click to view more details about the selected project. You can drill down further to view information to role and resource level. For more information, see Viewing Project Details.

 Not applicable Not applicable
11.

Filters

Filter panel used to tailor the data displayed in the dashboard. For further information on the filters that can be applied to the dashboard, see the Managing Filters.

Not applicable

 Not applicable
Calculations for Revenue
12a.

Last 13 Weeks Hours Variance Impact on Revenue

Revenue calculation, displaying hours variance impact on revenue for the last 13 weeks and revenue variance as a percentage.

Last 13 weeks Actual Revenue - Last 13 weeks Estimated Revenue

EvA Actual Billable Amount - EvA Scheduled Amount

  
12b.

Next 13 weeks Predicted Revenue Variance

Predicted revenue calculation, displaying predicted revenue variance for the next 13 weeks and predicted revenue variance as a percentage. Predicted revenue calculations are based on the revenue variance for the last 13 weeks.

Next 13 weeks Predicted Revenue Variance = Next 13 weeks Predicted Revenue - Next 13 weeks Scheduled Revenue

 

Next 13 weeks Predicted Revenue = Next 13 weeks Predicted Hours * Scheduled Bill Rate

 

Next 13 weeks Predicted Hours = Next 13 weeks Scheduled Hours + (Next 13 weeks Scheduled Hours * Last 13 weeks Hours % Variance)

 

Next 13 weeks Scheduled Revenue = Scheduled Hours * Scheduled Bill Rate

Next 13 weeks Predicted Revenue Variance =

Predicted Hours Variance * EvA Scheduled Bill Rate

 

Where Predicted Hours Variance = Predicted Hours - Scheduled Hours

 

Where Predicted Hours = EvA Estimated Hours * variance for the last 13 weeks

 

Where variance for the last 13 weeks = the sum of EvA Actual Hours over the last 13 weeks / EvA Estimated Hours over the last 13 weeks

 

 

Next 13 weeks Scheduled Revenue

EvA Total Hours * EvA Scheduled Bill Rate

 
12c.

Predicted Impact on Revenue

Predicted revenue calculation displaying, as a percentage, the impact of the selected project’s predicted revenue variance on the total scheduled revenue of all projects in the project list.

Predicted Revenue Variance for this project / Scheduled Revenue for all projects

None
Calculations for Costs
13a.

Last 13 Weeks Hours Variance Impact on Costs

Costs calculation, displaying hours variance impact on total costs for the last 13 weeks and costs variance as a percentage.

Last 13 weeks Actual Costs - Last 13 weeks Estimated Costs

 (EvA Actual Hours * Assignment Cost Rate) - (EvA Estimated Hours * Assignment Cost Rate)  
13b.

Next 13 Weeks Predicted Cost Variance

Costs calculation, displaying predicted costs variance for the next 13 weeks and predicted costs variance as a percentage. Predicted costs calculations are based on the costs variance for the last 13 weeks.

 Next 13 weeks Predicted Costs Variance =

Next 13 weeks Predicted Costs - Next 13 weeks Scheduled Costs

 

Next 13 weeks Predicted Cost =

Next 13 weeks Predicted Hours * Assignment Bill Rate

 

Next 13 weeks Predicted Hours: = Next 13 weeks Scheduled Hours + (Next 13 weeks Scheduled Hours * Last 13 weeks Hours % Variance)

 

Next 13 weeks Scheduled Cost: = Next 13 weeks Scheduled Hours * Assignment Cost Rate

Next 13 weeks Predicted Costs Variance = Predicted Hours Variance * Assignment Cost Rate

 

Where Predicted Hours Variance = Predicted Hours - Scheduled Hours

 

Where Predicted Hours = EvA Estimated Hours * variance for the last 13 weeks

 

Where variance for the last 13 weeks = the sum of EvA Actual Hours over the last 13 weeks / EvA Estimated Hours over the last 13 weeks

 

 

Next 13 weeks Scheduled Costs = EvA Total Hours * EvA Assignment Cost Rate

 
13c.

Predicted Impact on Costs

Costs calculation displaying, as a percentage, the impact of the selected project’s predicted costs variance on the total scheduled revenue of all projects in the project list.

Predicted Costs Variance for this project / Scheduled Costs for all projects

 None

Managing Filters

Your filter selections determine the data displayed on the dashboard charts. By default, the filter panel is hidden in this dashboard, but you can toggle between hiding and displaying the filters panel by clicking . To set or change your filters, use the drop-down options listed in the PSA Project Scheduling Risk Dashboard Filters table.

PSA Project Scheduling Risk Dashboard Filters

Name

Description

Filter Source Information

Hours Variance %

Set the Hours Variance percentage to view projects with variance higher than the selected threshold.

Fixed list: 0+ , 10+ and so on, until 100.

Project Billing Type

Select the billing type that you want to view all projects for, or select "All" to view projects for all billing types.

Dataset Field: Project Billing Type

Region Level

Select the region level that you want to view all projects for.

Region Level 01, Region Level 02, Region Level 03, and Region Level 04.

Region

Select the region within the region level that you want to view all projects for, or select "All" to view projects for all regions for the region level.

Shows Global Region and all values available at the selected region level.

Practice Level

Select the practice level that you want to view all projects for.

Practice Level 01, Practice Level 02, Practice Level 03.

Practice

Select the practice within the practice level that you want to view all projects for, or select "All" to view projects for all practices for the practice level.

Shows Global Practice and all values available at the selected practice level.

Group Level

Select the group level that you want to view all projects for.

Group Level 01, Group Level 02.

Group

Select the group within the group level that you want to view all projects for, or select "All" to view projects for all groups for the group level.

Shows Global Group and all values available at the selected group level.

Account Name

Select the account name you want to view all projects for, or select "All" to view projects for all accounts.

Account Name

Project Manager Name

Select the project manager you want to view all projects for, or select "All" to view projects for all projects managers.

Project Manager Name

Resource

Select the resource you want to view all projects for, or select "All" to view projects for all resources.

Resource Name

Note: The Region, Practice and Group levels support a maximum of 12 levels. The number of levels configured for your org is displayed in the associated picker filter lists.

Suggested Use Cases

You can explore and view the data displayed in this dashboard to analyze the trends and take critical business decisions, such as:

  • Prioritize the projects that have the most variance or have caused the most impact on revenue at a glance.
  • Track the changes in hour variance in the last 13 weeks for problematic projects.
  • Predict the hour variance in the next 13 weeks based on the hour variance in the last 13 weeks.
  • Take necessary actions to mitigate the hour variance in the future and reduce its impact on project revenue.
Note:  

  • Ensure you have the EvA process configured in your org before you start using this dashboard.

  • This dashboard is ideal only for Time and Material projects.

Use case for Fixed Fee projects

  • Fixed Fee projects are those that have a fixed revenue. The hours variance in these projects do not have an impact on revenue. However, if resources work more and submit timecards with more hours than the scheduled hours then the project margin will be lower.