The Training Success (Organization Hierarchy) Trend Analytics workbook investigates how successfully employees are attending training courses over time.

Business Questions

Is the training in my enterprise become more or less successful over time?

Parameters

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

• Start Date

• End Date

• Organization Hierarchy

• Top Organization

• Rollup Organizations - Yes/No

• Area (Geography)

• Country (Geography)

• Region (Geography)

• Location (Geography)

• Job Category

• Job Name

• Grade Name

• Position Name

Worksheets

This workbook has the following worksheets:

• By Year

• By Semi Year

• By Quarter

• By Bi Month

• By Month

The worksheets display one row for each time period. For example, the By Month worksheet displays one row per month.

Headings and Calculations

All worksheets contain the following columns:

• Start Date

  The start date of the time period.

• End Date

  The end date of the time period.

• A time period column

  The heading depends on the selected worksheet; for example, in the by Year worksheet, this column heading is Year.

• Attendees

  The number of attendees of training courses for each time period.

• Successful Attendees

  The number of successful attendees of training courses for each time period.

• Success Rate Percent

  Displays the number of successful attendees as a percentage of the total number of attendees.