I conducted an Exploratory Data Analysis on a Pizza Sales restaurant. This project involved examining and analyzing the dataset using SQL to extract valuable insights and trends related to Total revenue, Total Orders, Average revenue per order, order time, monthly and daily sales analysis and more. The EDA aimed to uncover patterns and correlations within the data, providing a foundation for data-driven decision-making. It will help the store owner understand the sales, profits, stock requirement for products and much more to take better decisions and be well prepared with the business.
Dataset Link: https://github.com/Swapppyy/Data-Analysis-of-Pizza-Sales
View my Work over here: My Queries
-
Total 49574 pizzas are sold
-
Average order value is around 38.31$
-
Pizzas are ordered more in the afternoon as their lunch meal.
-
July and May are the months where the maximum amount of orders are placed.
-
The most ordered Pizza is the Big Meat Pizza (Small)
-
The Thai chicken pizza generates a whooping revenue of 43435$ but the most sold pizza is The classic Deluxe Pizza
-
Garlic, Tomatoes and Red Onions are the ingredients which are mostly used while making pizzas.
Checkout my Live Dashboard published over here: Pizza Sales Dashboard
