The Employee Training Attendance Success (Organization Hierarchy) Template Analytics workbook provides two worksheets, one for investigating training success over yearly periods, the other providing a detailed analysis of training success in the workforce. These worksheets help you to create reports to analyze the success of your training courses. Training success is defined as the percentage of training courses that are successfully completed.

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 includes the following worksheets:

• By Year

• By Detail

By Year Worksheet

The By Year worksheet enables you to see training success for each year.

Worksheet Headings and Calculations

This worksheet contains the following columns:

• Start Date

  The start date of the time period.

• End Date

  The end date of the time period.

• Year

  The time period for which this worksheet is run.

• Attendees

  The number of attendees on training courses for each group.

• Successful Attendees

  The number of successful attendees on training courses for each group.

• Success Rate Percent

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

Detail Worksheet

The Detail worksheet calculates the training success rates for training classes with the same start and end dates, for attendees in each organization, location, job, grade, and position.

Worksheet Headings and Calculations

This worksheet contains the following columns:

• Training Class Start Date

  The date the class started.

• Training Class End Date

  The date the class ended.

• Attendees

  The number of attendees of classes with the same start and end dates, who are in the same organization, location, job, grade, and position, calculated using the selected workforce measurement value.

• Successful Attendees

  The number of attendees successfully completing the training class, for each organization, location, job, grade, and position, calculated using the selected workforce measurement value.

• Success Rate Percent

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

• Organization

  The organization of the attendees.

• Location

  The location of the attendees.

• Job

  The job held by the attendees.

• Grade

  The grade held by the attendees.

• Position

  The position of the attendees.