Operational Performance Analysis – Plato’s Pizza Restaurant

This is my submission for Maven Analytics’ Pizza Challenge October 2022. This report summarizes Plato’s Pizza restaurant’s annual performance of the year 2015. Additionally, it makes recommendations to identify opportunities to increase sales and perform more efficiently.

Data Set

Plato’s Pizza is a fictitious Greek-inspired pizza place in New Jersey. The dataset provided in the Data Playground contains one year of sales data. It contains four tables in CSV format.

Task

Create data models and use your data analysis & visualization skills to bring the data to life. Analyze data and create a report to help Plato’s Pizza find opportunities to drive more sales and work more efficiently.

Also, answer the following questions.

1. What days and times do we tend to be busiest?
2. How many pizzas are we making during peak periods?
3. What are our best and worst selling pizzas?
4. What’s our average order value?
5. How well are we utilizing our seating capacity? (we have 15 tables and 60 seats)

eyJrIjoiYmNjNTBhZmEtNTcxMi00NWIwLWEwNDItNDVlZDE1NGIzYWI2IiwidCI6IjdkOThkYTIxLWY2YTktNDAwNC04Y2VhLTY5MmJkNTA2M2M2YSIsImMiOjl9