In this project, we are conducting an Exploratory Data Analysis for pizza sales to enable the business owners make informed decisions regarding the making of pizza. This EDA will enable them to know the best or the worst performing pizza according to revenue, total quantity, and total orders. It will also enable them to know during which months are the sales high and which pizza sizes sell more than others.
The dataset is obtained from kaggle which entails pizza sales for the year 2015.
Before doing the EDA, the data was cleaned using mysql to ensure the dataset did not have missing values and had been properly formatted and ready for analysis.
The following questions need to be addressed during the analysis:
- What is the total revenue?
- What is the average order value?
- What is the total pizzas sold?
- What is the number of orders placed?
- What is the average number of pizzas sold per order
Visualizaton is conducted in Microsoft Power BI and the Key Performance indicators are revenue, quantity and orders.