You are here:

Project Analysis

The PPA Project Analysis dashboard allows a Project Manager to monitor the performance of the selected projects based on cost, effort and schedule variances on a month-on-month basis. The Project Manager may also view information such as variances in cost, effort and schedule, number of project milestones that were not met, and actual percentage of projects that are completed.

Note: This dashboard is currently not available as the Snapshots feature is in development

This dashboard contains the following sections:

Project Performance: Project manager can view the month-on-month performance of the selected projects based on cost, effort, and schedule variance.
Note: This dashboard is currently not available as the Snapshots feature is in development
Tasks Sorted By Variance: This section displays a grid listing all tasks associated with the selected projects sorted in descending order based on their Schedule Variance %.
Tasks Schedules: This section displays a table with all tasks associated with the selected projects along with attributes and metrics such as the Project Task State, Planned Effort (Hours), Actual Effort (Hours) and Effort Variance (Hours).
Resources Timeline: This section provides a week-on-week breakdown of the project utilization of all resources associated with the project tasks selected in the Tasks Sorted By Variance section. In this section, you can view the Resource Planned Effort, Resource Actual Hours and Overtime Hours metrics for all resources associated with the selected project tasks.

Metrics Used:

Metric Name	Description	Formula	Expected Values
EVM_Cost Variance %	The percentage difference between actual cost and earned value of the project.	Avg([Project Cost Variance %])	0 % to 100 %
EVM_Schedule Variance %	The percentage difference between the Actual and the Planned duration of a project.	Avg([Project Schedule Variance %])	0 % to 100 %
EVM_Effort Variance %	The percentage difference between actual and planned efforts of a project.	Avg([Project Effort Variance %])	0 % to 100 %
No. of Milestones Slipped	Number of milestone tasks that breached the respective planned end date.	Count([No. of Project Tasks]) where [Project Task Is Milestone Slipped= Y]	0 or >0, closer to 0 is ideal
Actual % Complete	Percentage of work in the project that has completed	Sum ([Project Actual % Complete])	0 % to 100 %
Schedule Variance %	The percentage difference between the Actual and the Planned duration of a project.	Avg([Project Schedule Variance %])	0 % to 100 %
Planned Effort (Hours)	The number of hours planned for a resource, for a project.	Sum([Project Planned Effort (Hours)])	0 or >0
Actual Effort (Hours)	The actual number of time (in hours) spent by a resource on a project	Sum([Project Actual Effort (Hours)])	0 or >0
Effort Variance (Hours)	The effort difference between the actual and the planned effort of a project.	([Project Actual Effort (Hours)] - ([Project Planned Effort (Hours)] * [Project Actual % Complete]))	0 or >0
Resource Planned Effort (Hours)	The hours planned for a resource for a task or project	Sum [Resource Planned Effort (Hours)]	0 or >0
Resource Actual Hours	Amount of actual project work logged by the resource using timesheets	Sum (Resource Actual Hours)	0 or >0, greater than 0 is ideal
Overtime Hours	The extra hours clocked in by a resource for a project. Number of hours spent by a resource beyond the allocated time is considered to be overtime hours	IF (([Resource Actual Hours] > [Resource Planned Effort (Hours)]) THEN ([Resource Actual Hours] - [Resource Planned Effort (Hours)]) ELSE 0)	0 or >0, closer to 0 is ideal