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.