Shortlisting training channels:
Identified multiple channels through which training takes place and shortlisted key ones required for analysis based on contribution and region level presence.
Data Collection:
Training details of various channels were procured from their respective cubes/data sources.
Delivery region/country level details were collected for all channels.
Visualization:
The client should get a holistic view of the contribution of multiple channels across multiple geos across the globe.
Prominent regions/countries should be visually highlighted.
Created a heat map view to better convey the insights; prominent regions were highlighted using box and whisker plot algorithm.
Automation:
Generation of WW heat map involved a lot of manual work, and it was difficult to scale the execution based on client requirements.
Created an automated algorithm using python to generate the heat map based on input training numbers.
Helped client in getting a holistic, easily consumable view on distribution of trainings through multiple channels across geos.
Enabled client to redesign their marketing, promotion and budgeting strategy tailor made to cater the specific demands of customers across the globe.