Maven Pizza Challenge

In this project, I played the BI Consultant hired by Plato's Pizza, a Greek-inspired pizza place in New Jersey. I've been hired to help the restaurant use data to improve operations.

Notebook Viewer

Some questions that we'd like to answer:

• What days and times do we tend to be busiest?
• How many pizzas are we making during peak periods?
• What are our best and worst selling pizzas?
• What's our average order value?

About the dataset

• This dataset contains 4 tables in CSV format
• The Orders table contains the date & time that all 5,238 table orders were placed
• The Order Details table contains the different pizzas served with each order in the Orders table, and their quantities
• The Pizzas table contains the size and price for each distinct pizza in the Order Details table, as well as its broader pizza type
• The Pizza Types table contains details on the pizza types in the Pizzas table, including their name as it appears on the menu, the category it falls under, and its list of ingredients

Answers

• The busiest day is Friday with an order count of 8,106.
• More than 1000 pizzas are made during peak periods. For January record, 1,410 pizza was made in the period of 12 pm - 3 pm while in February, 1,275 pizza was ordered during the same period (early afternoon)
• The 3 best-selling pizzas include The Classic Deluxe, The Barbecue Chicken Pizza, and The Hawaiian Pizza.
• The 3 worst-selling pizzas include The Soppressatan Pizza, The Spinach Pesto Pizza, and The Spinach Supreme Pizza.
• The average order value is approximately $17.

Summary

• The earliest open hour is 09:52 am and the latest closing hour is 23:05 pm
• The average quantity of pizza ordered is very high around 10 a.m and reduces as the hour goes by.
• Average sales are high on Tuesdays and Thursdays.
• The highest sale was made in July with an average of $4,301, while the least sale was made in October with an average of $3,797.
• Small size pizza from the veggie category is the most purchased pizza.

Recommendation

• Replace the worst-selling pizza with a new pizza type.
• The shop is open early for more sales in the morning.
• Do a promo or sales discount with the best-selling pizza to attract more customers.