This dataset contains 4 tables in CSV format The Orders table contains the date & time that all 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
For the Maven Pizza Challenge, you’ll be playing the role of a BI Consultant hired by Plato's Pizza, a Greek-inspired pizza place in New Jersey. You've been hired to help the restaurant use data to improve operations, and just received the following note:
Welcome aboard, we're glad you're here to help!
Things are going OK here at Plato's, but there's room for improvement. We've been collecting transactional data for the past year, but really haven't been able to put it to good use. Hoping you can analyze the data and put together a report to help us find opportunities to drive more sales and work more efficiently.
Here are some questions that we'd like to be able 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? How well are we utilizing our seating capacity? (we have 15 tables and 60 seats) That's all I can think of for now, but if you have any other ideas I'd love to hear them – you're the expert!
Thanks in advance,
Mario Maven (Manager, Plato's Pizza)
There were 4 tables Orders, Order_Details, Pizza_types and Pizza_sizes This Data wasn't all that data the main thing i needed to do was merge remodel the data. I merged Orders table with Order details and created a custom column for calculating Profit, I used DAX formular to calculate the total quantity I duplicated Order tables and formed a date tables with that, then i removed the constant "The" in pizza_names cause it will make pizza names too long for my visualizations.
- Plato's has 32 types of Pizza their Top 7 Pizzas are Classic Deluxe, Barbecue Chicken Pizza, Hawaiian, Pepperoni, Thai Chicken, Californi Chicken, Sicilian, Spicy, SouthWest Chicken and Big meat Pizza
- Their 7 worst performing pizzas where Green Garden, Chicken, Italian Vegetable, Chicken Pesto, Spinach, Soppressata, Spinach,Calabrese, Mediterranean and Brie Carre Pizza
- Plato had their Peak Days On Friday and Saturday and their Lowest Days was on Sunday
- Plato had 5 sizes of Pizzas which are Large, Medium, Small, XL, XXL. Generall, Large make up 38.2% of their Revenue followd by Medium which makes up 31.5% and Small a 29.1% Of their Revenue. This means that these are the main sizes that sell the most, XL and XXL sales are almost significant i suggest Plato to remove that from their stock or keep it in really Small quantity
- Their Totals Sales for the year was $817k and they had a total of 50,000 Unique orders for the year
- Their Peak hours Starts from 12pm mid day to 1PM and then it drops for some hours and picks up by 4PM when their customers are going back home from work. Their average sales during the day is
- Plato Make more sales August, July and May