Visualising Data to make it more Useable
Summarising data and showing it on a map, identified trends and highlighted opportunities to discuss with the sales team.
I used demographic data to redraw the boundaries of sales territories so that the opportunities were more evenly split among the sales team.
Using the population in each area, number of cars registered there and sales in. the previous year, I was able to build up a detailed picture of the true potential of each ground. This data could then be used to manage the time of the sales team.
Focus resources
By highlighting only the biggest potential clients on a sales territory, the image shared to the salesman for that ground could focus their attention on where to direct their time
Granular Level Detail
By taking all the dealers on a sales ground and plotting them in different colors depending on whether they are active or inactive, salesmen could see the areas where time should be spent. The inactive dealer were also provided as a list in excel.
Hotspotting
By plotting the sales in each territory, it was possible to show hotspots of activity. These could be used to identify high performing areas and areas which required attention.