This project focuses on analyzing pizza sales data using SQL. We'll explore various aspects of the dataset, including order quantities, revenue, pizza types, and more. The goal is to gain insights that can inform business decisions related to pizza sales.
Before diving into the specific questions, let's briefly describe the dataset:
- Tables: We'll work with several tables, including an
Orders
table, aPizzas
table, and potentially other related tables. - Columns: Key columns include
order_id
,pizza_id
,quantity
,price
,size
, andorder_date
.
-
Retrieve the total number of orders placed
-
Calculate the total revenue generated from pizza sales
-
Identify the highest-priced pizza
-
Identify the most common pizza size ordered
-
List the top 5 most ordered pizza types along with their quantities
-
Total quantity of each pizza category ordered
-
Distribution of orders by hour of the day
-
Category-wise distribution of pizzas
-
Average number of pizzas ordered per day
-
Top 3 most ordered pizza types based on revenue
-
Percentage contribution of each pizza type to total revenue
-
Cumulative revenue generated over time
-
Top 3 most ordered pizza types based on revenue for each pizza category
Summarize the key findings and insights from your analysis. Consider visualizations (e.g., charts, graphs) to enhance understanding.
Feel free to customize the README by adding details about your dataset, SQL environment, and any additional context specific to your project. Good luck with your SQL analytics project! ๐๐ยนยณ
I've provided a high-level overview, but you can expand on each section with more details specific to your project. If you need further assistance or have any specific requirements, feel free to ask! ๐