Maven Pizza Challenge - Maven Analytics | Power BI Project
For the Maven Pizza Challenge, playing the role of a BI Analyst by Plato's Pizza, a Greek-inspired pizza place in New Jersey. Designed a dashboard to analyze & help the restaurant use data to improve operations. Found some useful insight & answer for the question provided in the challenge by creating the interactive dashboard in Power BI.
The data was provided by Maven as a part of the challenge. It was contained in 4 .csv files, named Orders, Order Details, Pizzas, and Pizza type. The dataset was already clean so there was no need to do anything else in this step of the process.
About the dataset:
- 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 analysis I have imported tables in power BI. I have done the data modeling in Power BI by connecting the 4 tables based of primary & foreign key. After connecting the table I did the analysis for the given problem statements by maven analytics. Below is the Power BI dashboard which I have created to show the analysis for the Maven Pizza challenge.
DASHBOARD
- Plato's Pizzas is open from 9:00 a.m. to 11:00 p.m. every day of the week.They have 4 pizza categories and 32 pizza types in 5 different sizes.
- A total of 21.35K pizza orders were placed, and a total of 48.75K pizzas were sold, with an average of 2.32 pizzas per order.
- The busiest day is Friday because the majority of orders are placed on this day, and the busiest time for the store is between 12 and 1 p.m.
- Classic-type pizza is the category that is ordered by most of the customers (29.9%), followed by supreme, veggie, and chicken. Large-size pizza is preferred by most of the customers, followed by medium, small, XL, and XXL.
- The bestselling pizza was the "Classic Deluxe Pizza" (2453 orders), and the lowest selling pizza was the "Brie Carre Pizza" (490 orders).
No comments: