Designed a Report to Visualize Training Data in a Concise View

Business Challenge:

The client is a technology giant and provides training on the latest software and services to their customers with the help of partners. The client wanted to visualize training requests in a concise view to help calculate trainers utilized on a weekly basis and plan trainings according to availability of trainers.

TurnB Approach:

  • Consolidated and standardized the various training requests received from each partner into a uniform format.
  • Designed a condensed view of all the trainings, including trainings timings for each solution area.
  • Arranged the trainings in customer-order to help with customer-wise analysis.
  • Calculated the weekly utilization of trainers for each solution area.

Implications:

  • Consolidated view of the scheduled trainings helped to comprehend the upcoming trainings for each customer easily.
  • The designed view helped analyze the week-wise training numbers, estimate the number of trainers required in coming weeks and plan trainings according to trainer’s capacity.
  • Trainer utilization calculation helped in auditing trainer consumption provided by each partner for invoicing the client.
  • The view enabled client to optimize the trainer capacity to be reserved by each partner for next fiscal year.