You are here:

Project Executive Overview

The PPA Project Executive Overview dashboard allows Project Executives and Project Managers to monitor allocation and utilization of resources across various portfolios and resource groups. It also allows them to view a breakdown of resources by employment type, role, department, portfolio, and program.

This dashboard consists of the following sections:

# of Resources by Employment Type: This section displays a pie chart where each slice represents a type of employment such as Contractor or Full Time. To view the number of resources belonging to each employment type and their percentage contribution to the total number of resources, hover over the corresponding slice of the pie chart.
Note: Data displayed in the remaining sections of this dashboard are based on the employment type chosen in this section.
Planned Resource Cost Trend: This section displays a line graph showing month-on-month trend of the planned effort cost for resources belonging to the selected employment types.
# of Resources by Resource Role: This section displays a horizontal bar graph showing the number of resources associated with various roles. You can hover over a bar to view the number of resources linked to a specific role.
# of Resources by Dept: This section displays a vertical bar graph showing the number of resources associated with different departments. You can hover over a bar to view the number of resources linked to a specific department.
# of Resources by Portfolio: This section displays a vertical bar graph showing the number of resources associated with different portfolios. You can hover over a bar to view the number of resources linked to a specific portfolio.
# of Resources by Program: This section displays a vertical bar graph showing the number of resources associated with different programs. You can hover over a bar to view the number of resources linked to a specific program.
Skills in demand: This section displays a table listing all skills ranked in descending order based on the Availability Gap (Hours) metric. This table also lists all primary skills along with the number of resources, number of full-time employees and contractors, average hourly rate, project allocation, and project utilization percentage associated with each skill.

Metrics Used:

Metric Name	Description	Formula	Expected Values
No. of Contractors	Total number of contractors who are assigned to projects	Max([No. of Available Resources]) where [Employment Type = CONTRACTOR And Resource Not in (0,-1)]	0 or >0
No. of FTEs	Total number of full time employees who are assigned to projects	Max([No. of Available Resources]) where[Employment Type = FTE And Resource Not in (0,-1)]	0 or >0
No. of Resources	Count of all resources across projects	Max [No. of Resources]	0 or >0
Resource Planned Effort Cost	The planned cost for a resource for a task or project	Sum [Resource Planned Effort Cost]	0 or >0
Project Allocation %	The percentage of hours that are allocated to projects as compared tototal planned hours	[Resource Allocated Hours] / [Resource Planned Effort (Hours)]	0 or >0, closer to 100% is ideal
Project Utilization %	Percentage of actual hours logged by a resource as compared to their allocated hours	([Resource Actual Hours] / [Resource Allocated Hours])	0 or >0, closer to 100% is ideal
Availability Gap %	Percentage of hours where the resource availability is falling short for project demand	([Resource Planned Effort (Hours)] - [Resource Allocated Hours]) / [Resource Planned Effort (Hours)]	0 or >0, closer to 0 is ideal
Avg Hourly Rate	The average rate of work per hour for the project	[Project Actual Cost] / [Project Actual Effort (Hours)]	0 or >0