Beverage Sales Dashboard

Case Statement:

• Get a quick view of the share of F&B spending from existing customers (restaurants) that Shaun's F&B Company is getting, and if there are any opportunities in specific segments.
• What are the adjacent opportunities from the non-commercial establishments to additionally sell into (note that there are no customers currently in the non-commercial segment). Their data of spending are not available, so will be interested in knowing relevant proxies that could indicate opportunities for us.
• Retailers are a different business division and out of scope for me (Shaun), but some of my customers/prospects could be buying from these retailers – so getting a view of retailer presence adjacent to his customers & prospects will help understand how much of these opportunities are being met / unmet.

Process :

• Built interactive dashboard to visualize sales opportunities of F&B manufacturer services in three different bussines segments.
• Used complex parameters to drill down in worksheets and customization using filters and slicers.
• Created connections, join new columns, and enable user-driven parameters for visualizations.
• Used different types of customized visualization (bar chart, pie chart, donut chart, clustered bar chart, map, slicers, tables, etc).