The Workforce Separation by Competence (Organization Hierarchy) Trend Analytics workbook compares employees' competencies, to the rate of separation over time.

Business Questions

Does the level of employee competencies bear any relation to the rate of separation from my enterprise?

Workbook Parameters

You must enter a value for the following parameters:

• Start Date

• End Date

• Organization Hierarchy

• Top Organization

• Rollup Organizations - Yes/No

• Workforce Measurement Type

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

• Geography Area

• Geography Country

• Geography Region

• Geography Location

• Job Category

• Job

• Grade

• Position

Worksheets

This workbook has the following worksheets, each representing a time period, or a time period and another structure:

• By Year

• By Semi Year

• By Quarter

• By Bi Month

• By Month

The worksheet matrix reports display one row for each time period. For example, the by Month worksheet displays one row for each month.

Workbook Headings and Calculations

The matrix reports contain the following columns:

• A time period column

  The heading depends on the selected worksheet, for example, in the by Month worksheet, this column is named "Month".

• Start Date

  The start date of each time period.

• End Date

  The end date of each time period.

• Competence columns (one column per defined competence)

  The number of people in each time period who have separated from the workforce and hold the competence.