PSA Project Scheduling Risk Dashboard

The PSA Project Scheduling Risk dashboard contains the following pages, charts, tables, local filters, and components:

This Dashboard enables you to:

  • View a prioritized list of your most risky projects by scheduling variance.
  • Track the scheduled versus actual hours variance on your projects and how that has affected the revenue 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.

Prerequisites for this Dashboard

Refer to these prerequisites before you start using the Project Scheduling Risk Dashboard.

  • Only active projects are included.
  • Each project must have at least one week of history in order to be included.
  • For any individual resource to be included in the variance calculations, the resource must have at least one week of history on the project.
  • You must have at least EvA record of EvA time period type equal to week.
  • This dashboard does not support daily bill rates.
PSA Project Scheduling Risk Dashboard Elements
Element Number Name Description Calculation Referenced Calculation Source Dataset

1

Project List

A list of your riskiest projects in terms of their schedule inaccuracy. The list reorders according to the selection. 

    

Project Reporting

2

Sort By Picker

Sorts the project list according to the sort option picked from the list. 

Note: The project with the highest variance is listed at the top of the project list.

      
 

Hours Variance % Last 13 Weeks

Percentage difference between the scheduled hours and actual hours of the last 13 weeks.

      
 

Hours Variance Total Last 13 Weeks

Total of the difference between the scheduled hours and actual hours of the last 13 weeks.

      
 

Scheduled Revenue for Next 13 weeks

The scheduled revenue for the next 13 weeks retrieved from the EvA records.

      

3

Project Variance Bar

The % variance is calculated on an absolute basis.

EVA Hours Variance filtered by EVA Time Period Type=Week and Project Name, Grouped by End Date (Week)

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

  
 

Over Schedule

A project is over-scheduled when:

  • The hours variance is over 0%. 
  • There are more actual hours than scheduled hours for the last 13 weeks. 

It is represented in pink color.

Note: This percentage changes depending on your selection in the Hours Variance % Last 13 Weeks option.
      
 

Under Schedule

A project is under-schedule when:

  • The hours variance is less than 0%. 
  • There are fewer actual hours than scheduled hours for the last 13 weeks.

It is represented in blue color.

Note: This percentage changes depending on your selection in the Hours Variance % Last 13 Weeks option.
      

4

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 HoursClosed EvA Actual Hours - Scheduled HoursClosed EvA Estimated Hours) / Scheduled HoursClosed EvA Estimated Hours

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

Or

EvA Hours Variance / EvA Estimated Hours

 

5

Line Chart (last 13 weeks)

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

Scheduled hours:

EvA Estimated Hours

Actual Hours:

EvA Actual Hours

Revenue Variance:

EvA Actual Billable Amount-EvA Scheduled Amount

   

6

Prediction Flag

The prediction for the next 13 weeks starts from the current week + 12 weeks ahead. 

      

7

Line chart (next 13 weeks)

Displays the Scheduled HoursClosed EvA Estimated Hours and Predicted hoursClosed EVA Estimated Hours - (Average Variance % for last 13 weeks* EVA Estimated Hours) for the next 13 weeks.

Scheduled Hours:

EVA Estimated Hours

Predicted Hours:

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

   

8

Last 13 Weeks Hours Variance Impact on Revenue

Displays hours variance for the last 13 weeks impact on total revenue along with the revenue variance percentage.

Last 13 weeks Actual Revenue - Last 13 weeks Estimated Revenue

EvA Actual Billable Amount - EvA Scheduled Amount

 

9

Next 13 weeks Predicted Revenue Variance

Displays revenue variance for the next 13 weeks based on the variance for the last 13 weeks along with the predicted revenue variance percentage.

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 HoursClosed EvA Estimated Hours * Bill Rate

Next 13 weeks Predicted Revenue

Predicted Hours Variance * EVA Scheduled Bill Rate

Next 13 weeks Scheduled Revenue

EVA Total Hours*EVA Scheduled Bill Rate

Predicted Hours Variance

EVA Scheduled Hours - Predicted HoursClosed EVA Estimated Hours - (Average Variance % for last 13 weeks* EVA Estimated Hours)

 

10 

Predicted Impact on Revenue

Displays the impact of the selected project’s predicted revenue variance on the total of all projects scheduled revenue in the project list.

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

(Predicted Hours*ValueEVAScheduledBillRate)

Filter: Selected Project/EvA Scheduled Amount

Filter: All projects on the dashboard

  

11

Legends
 

Actual Hours

Total actual hours for the project.

 EvA Actual Hours    
 

Predicted Hours

Total predicted hours for the project.

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 hoursClosed EVA Estimated Hours - (Average Variance % for last 13 weeks* EVA Estimated 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 hoursClosed EVA Estimated Hours - (Average Variance % for last 13 weeks* EVA Estimated Hours) for all the resources in the project are consolidated to arrive at the predicted hours for a project.

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

Scheduled Hours

Total scheduled hours across the last 13 weeks and the next 13 weeks.

 EvA Estimated Hours    
 

Hours Variance % 

The difference between actual and estimated (scheduled) hours as a percentage of estimated hours.

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

The PSA Project Scheduling Risk dashboard displays data from the Project Reporting dataset.

For more details about the fields used by the PSA Project Scheduling Risk dashboard, see Project Reporting Dataset Output Fields.

Filters

The filters panel can be used to tailor the data displayed in the dashboard.

Name

Description

Filter Source Information

Hour Variance %

Displays the past 13 weeks variance of scheduled versus actual hours. It filters out projects which have a variance below this threshold. The variance is listed as an absolute value in this filter.

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

Project Billing Type

Displays data based on billing type.

Dataset Field: Project Billing Type

Region Level

Displays available levels for regions.

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

Region

Displays regions at the level selected in Region Level.

Uses field selected in Region Level, shows all values available, and Global Region.

Practice Level

Displays available levels for practices

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

Practice

Displays practices at the level selected in Practice Level.

Uses the field selected in Practice Level, shows all values available, and Global Practice.

Group Level

Displays available levels for groups.

Group Level 01, Group Level 02.

Group

Displays groups at the level selected in Group Level.

Uses the field selected in Group Level, shows all values available, and Global Group.

Project

Displays data for a specified project.

Project Name

Account Name

Displays the data for a specified account name.

Account Name

Project Manager Name

Displays the data for a specified project manager name.

Project Manager Name

Resource

Displays the data for a specified resource name.

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.

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

The dashboard is available only on the PS Cloud Advanced Analytics app.

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.
  • To filter the projects on the basis of Fixed Fee, on the Project Billing Type option select Fixed Fee.