Created Interactive Dashboard of Food & Beverages Services (Opportunity Analysis of a Major Food and Beverage Manufacturer)
Our client, the sales director of the Major Food and Beverage Manufacturer wants us to report hindsight and insight into his business based on provided datasets. Also, he wants us to create an interactive dashboard to analyze the sales opportunities available in non-commercial sections and adjacent to retail stores to grow his F&B services.
- 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 finance data 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.
- Built an interactive dashboard to visualize sales opportunities of F&B manufacturer services in three different business 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).
- Out of 611 unique restaurants, Shaun's company has a good relationship with restaurants generating sales revenue of =<$500,000 (357 restaurants).
- A total of 326 restaurants have a 50% share of F&B purchases from Shaun's company.
- In the state of MA (Massachusetts), it would be beneficial for Shaun's company to make a good relationship with non-commercial establishments working on a contract basis (49%) in cities like Worcester and Boston where the school ranges between 3-5 and 6-9 having public ownership (48%), providing >2000 meals a day. Also, targeting the same cities where the hospital's bed capacity ranges between 1-50, 51-100, and 101-500, having public ownership.
- Out of 601 retail stores, 308 stores (46%) generate annual sales revenue of <=$500,000, and most of them (259 stores) are located in KY (Kentucky).
- The Grocery (249), Liquor (88), and Convenience stores (84) play a major role, generating sales revenue of <=$500,000 in the state of KY (Kentucky).
- Shaun's company has a good relationship with the restaurants generating sales revenue of =<$500,000 while most have a 50% share of F&B purchases from his company and it should be maintained or increased in the future for growth.
- It would be beneficial for Shaun's company to make a good relationship with non-commercial establishments working on a contract basis (49%) in cities like Worcester and Boston where the school ranges between 3-5 and 6-9 having public ownership (48%), providing >2000 meals a day.
- Out of 661 retail stores, 308 stores generate annual sales of =<$500,000 in three states whereas 259 retail stores (88%) are located in the KY (Kentucky). Hence, based on the good reputation of Shaun's company with the restaurants generating sale revenue of =<$500,000, it would be beneficial for him to develop a good relationship with his customers adjacent to retail stores in KY (Kentucky) making a sale revenue of =<$500,000.