Maven data analytics Challenge submission.
Information about the challenge provided on Maven analytics below.
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
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)
Interactive dashboard below;
0 Comments
Dear reader, if you think of a different or an alternative way to achieve this solution, kindly share you idea in the comment section. Thank you.