The Training Success (Organization Hierarchy) Status Analytics workbook investigates how successfully employees in different organizations and geographical areas are attending training courses.

Business Questions

How successful is employee training across different organizations or geographical areas?

Which organization is the most successful at training?

Which geographical area is the least successful at training?

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 Organization

• By Geography Area

The worksheets display one row for each grouping. For example, the By Organization worksheet displays one row per organization.

Headings and Calculations

All worksheets contain the following columns:

• A grouping column

  The heading depends on the selected worksheet; for example, in the By Organization worksheet, the heading is Organization.

• Attendees

  The number of attendees on training courses for each group.

• Successful Attendees

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

• Success Rate Percent

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