Competence Levels (Organization Hierarchy) Detail Analytics Workbook

The Competence Levels (Organization Hierarchy) Detail Analytics workbook displays the competence levels attained by individuals in the enterprise for a competence.

Business Questions

Which people are the most proficient and which people are the least proficient in a competence?

Parameters

Before running the worksheets you must enter a value for the following parameters:

Use the following parameters to further restrict the values in the workbook:

Worksheets

This workbook has the following worksheets:

By Person with Rank Worksheet

The by Person with Rank worksheet lists each individual who have the selected competence, and shows you both the proficiency level they have achieved, and the proficiency level translated into a proficiency rank. You define proficiency levels against a competence for a job.

Proficiency ranks translate the proficiency levels into a more even spread of values. These values can provide a more consistent method for assessing proficiency ratings across competencies.

Headings and Calculations

The Person with Rank worksheet contains the following columns:

By Person Worksheet

The by Person worksheet examines the people who hold the selected competence and their proficiency levels.

Headings and Calculations

This worksheet uses the following calculations:

Related Topics