PSA Utilization Dashboard

The PSA Utilization dashboard enables you to:

  • View the Total Utilization percentage KPI.
  • View the PSA scheduled hours.
  • Compare the scheduled hours with the actual hours logged.
  • See which resource has been over or under allocated and the utilization rate for the resource.

This dashboard is created as part of the PS Cloud Advanced Analytics app and displays data from the Utilization dataset. For more details of the fields used by the PSA Utilization dashboard, see Utilization Dataset PS Cloud Analytics Output Fields.

PSA Utilization Dashboard Guide

The PSA Utilization dashboard displays:

  • Data for the current fiscal quarter by default
  • Only current region, practice, and group values for resources

PSA Utilization dashboard schematic highlighting the key elements of the dashboard

PSA Utilization Dashboard Elements

Element Number

Name

Description

Calculation

Referenced Calculation

Source Dataset

1. View By Picker for Utilization By RPG Bar Chart

Defines the data displayed in the Utilization By RPG bar chart.

Note: You can only select the region, practice, or group that the calculation is run by. For example, if the calculation is run by region, you cannot select practice or group.
Utilization grouped by resource region and selected level. Displays utilization by region. Utilization Dataset PS Cloud Analytics Output Fields
Utilization grouped by resource practice and selected level. Displays utilization by practice.
Utilization grouped by resource group and selected level. Displays utilization by group.
2. Utilization By RPG Bar Chart Displays the total scheduled and actual hours for the value selected in the view by picker (1).

Region = Scheduled Hours + Actual Hours grouped by Region Level 00 and Region Level 01, filtered by Time Period Type = Week, Month, or Quarter and Has Resource = No, where RHierarchyDepth = 01, Region Level 00 ≠ N/A, and Utilization End Date = This fiscal quarter.

Data displayed responds to selections.

None

Practice = Scheduled Hours + Actual Hours grouped by Practice Level 00 and Practice Level 01, filtered by Time Period Type = Week, Month, or Quarter and Has Resource = No, where RHierarchyDepth = 01, Practice Level 00 ≠ N/A, and Utilization End Date = This fiscal quarter.

Data displayed responds to selections.

None

Group = Scheduled Hours + Actual Hours grouped by Group Level 00 and Group Level 01, filtered by Time Period Type = Quarter, Week, or Month and Has Resource = No, where RHierarchyDepth = 01, Group Level 00 ≠ N/A, and Utilization End Date = This fiscal quarter.

Data displayed responds to selections.

None
3. Utilization KPI Total utilization as a percentage. Total Utilization = (sum of Billable Hours + sum of Credited Hours) / (sum of Calendar Hours - sum of Excluded Hours). None
4. Utilization Time Period Stacked Chart

Displays total scheduled hours and total actual hours by month.

Scheduled Hours and Actual Hours grouped by Utilization End Date = Year-Month, filtered by Time Period Type = Week, Month, or Quarter, Has Resource = Yes, and Utilization End Date = This fiscal quarter.

Data displayed responds to selections.

None
5. View By Picker for Utilization By Resource or Role Bar Chart Defines the data displayed in the Utilization By resource or role bar chart.

Resource

Displays data by resource.

 

Role Displays data by role.
6.

Utilization By Resource or Role Bar Chart

Displays the total scheduled and actual hours for the value selected in the view by picker (5).

Scheduled Hours and Actual Hours grouped by Resource Name or Role Name, filtered by Time Period Type = Week, Month, or Quarter, Has Resource = Yes, and Utilization End Date = This fiscal quarter.

Data displayed responds to selections.

None
7. Utilization Rate Time Period Line Chart Displays utilization target rate and target attainment rate by month. Target Rate = Target Hours / (Calendar Hours - Excluded Hours) grouped by Utilization End Date = Year-Month, filtered by Has Resource = True. None

Target Attainment Rate = Target Rate / (Billable Hours + Credited Hours) / (Calendar Hours - Excluded Hours) grouped by Utilization End Date = Year-Month, filtered by Has Resource = True.

None