The goal is to craft data stories by analyzing data and addressing important questions, such as the busiest days and times, the amount of pizzas made during peak periods, best-selling and worst-selling pizzas, average order value, and how well the seating capacity is being utilized. Join me in this opportunity to turn data into actionable insights and help Plato's Pizza succeed!
Here are the assumptions used for the analysis:
- Pizza Size Serving:
- Small: 1 Person
- Medium: 2 People
- Large: 3 People
- Average Dining Time: 1 Hour
Insights & Recommendations:
- On average, there is very little demand from 9:00 AM to 11:00 AM. Change operating hours to 11:00 AM to 11:00 PM to reduce operating costs.
- Peak hours occur during lunchtime from 11:00 AM to 1:00 PM, and demand before dinner time from 4:00 to 6:00 PM closely follows. Consider the following options to maximize table turnover and reduce customer waiting time:
2.1 Increase seating capacity by reconfiguring the restaurant's layout to maximize space and accommodate more tables and seats.
2.2 Implement a reservation system to manage the flow of customers better and ensure that tables are available even during peak hours.
2.3 Promote off-peak hours via targeted marketing campaigns or discounts/special offers.
2.4 Business expansion by providing takeout or delivery services for those who want to enjoy the food and avoid waiting in long lines during peak hours.