-
order_id: A unique identifier for each pizza order.
-
date: The date when the order was placed.
-
time: The time of day when the order was placed.
-
order_details_id: An identifier for details related to a specific order.
-
pizza_id: A unique identifier for each type of pizza.
-
quantity: The quantity of the specific pizza ordered.
-
pizza_type_id: An identifier for the type of pizza.
-
size: The size of the pizza ordered (e.g., Small, Medium, Large).
-
price: The price of the ordered pizza.
-
name: The name of the pizza.
-
category: The category to which the pizza belongs (e.g., Veg, Non-Veg).
-
ingredients: The ingredients used in the pizza.
-
week: The week of the year when the order was placed.
-
day: The day of the week when the order was placed (e.g., Monday, Tuesday).
-
hour: The hour of the day when the order was placed.
-
month: The month when the order was placed.
In this pizza order analysis, I explored various aspects of customer preferences, order patterns, and sales trends based on a comprehensive dataset. The insights gained from this analysis offer valuable information to enhance decision-making and optimize strategies for our pizza business.
-
Total Sales:
- Our total sales amount to $801944.7, reflecting the revenue generated from pizza orders during the analyzed period.
-
Total Number of Orders:
- With a total of 21350 orders, we have a significant volume of transactions that provide a comprehensive basis for analysis.
-
Average Order Price
- Calculates the average price of an order considering the quantity and price of each pizza.
-
Top 10 Most Popular Pizza Types
- Lists the top 10 most popular pizza types based on the quantity of orders.
-
Most Pizzas Ordered in a Day
- Identifies the day with the highest number of orders.
-
Revenue by Pizza Category
- Calculates the revenue generated by each pizza category.
-
Top Selling Pizzas by Quantity
- Lists the top selling pizzas based on the total quantity sold.
-
Total Orders per Month
- Counts the total orders placed per month.
-
Total Revenue per Month
- Calculates the revenue generated per month.
-
Top Selling Pizza Type per Month
- Identifies the top selling pizza type for each month based on the quantity sold.
-
Busiest Month
- Determines the month with the highest number of orders.
-
Average Order Quantity and Price by Month
- Calculates the average order quantity and price per month.
-
Most Expensive Order
- Finds the order with the highest total price for each month.
-
Orders Count Comparison between Weekends and Weekdays
- Compares the number of orders placed on weekends and weekdays.
-
Average Order Quantity and Price on Weekends and Weekdays
- Calculates the average order quantity and price for weekends and weekdays.
-
Pizza Sales by Pizza Type and Day of Week
- Analyzes pizza sales by pizza type and day of the week.
-
Total Orders by Pizza Size
- Counts the total orders for each pizza size.
-
Revenue by Pizza Size
- Calculates the revenue generated by each pizza size.
-
Time-of-Day Analysis: Orders by Hour
- Analyzes the distribution of orders by hour of the day.
-
Top by Busiest Hours
- Identifies the busiest hours for placing orders.
-
Revenue by Pizza Category and Month
- Calculates the revenue generated by each pizza category for each month.
These insights offer an opportunity to refine our menu offerings, pricing strategies, and marketing campaigns. By tailoring our approach to align with customer preferences and behavior, we can enhance customer satisfaction and drive business growth.