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.