Problem

A café shop was struggling to manage their menu design due to a lack of data-driven insights. They were unsure which products were the most profitable, leading to excess inventory costs and inefficient menu design. The team needed a solution that would provide them with clear insights into their product sales data.

Solution

I began by analysing the restaurant's sales data, income, and quantities sold in order to identify top selling items and seasonal patterns. This information would be used to inform product selection, ordering, and menu design.

The dashboard gives clear insights into their product sales data. This allowed them to make data-driven decisions when it came to managing their inventory costs and designing menus aligned with customer demand.

Impact

Increased profitability by 10%
Improved menu design based on customer demand

Quote of how incredible of an impact this had.

Café chain Product Sold Analysis