This project analyzes pizza sales data using SQL in MySQL Workbench to uncover valuable business insights from transactional sales data.
A relational database was created by importing four CSV datasets and establishing relationships between them. SQL queries were used to analyze customer ordering patterns, product performance, sales trends, and revenue generation, helping answer real-world business questions through data analysis.
- Create a relational database from multiple datasets.
- Perform business-driven sales analysis using SQL.
- Analyze customer ordering behavior and product performance.
- Generate meaningful insights to support business decision-making.
The project is based on four related datasets:
| Table | Description |
|---|---|
| Orders | Contains order date and time information. |
| Order Details | Stores pizza quantities for each order. |
| Pizzas | Contains pizza sizes and prices. |
| Pizza Types | Contains pizza names, categories, and ingredients. |
- MySQL Workbench
- SQL
- CSV Dataset
- Git & GitHub
- SELECT
- WHERE
- ORDER BY
- GROUP BY
- HAVING
- Aggregate Functions
- INNER JOIN
- Multiple Table Joins
- Subqueries
- Common Table Expressions (CTEs)
- Window Functions
- Date & Time Functions
This project answers the following business questions:
- Retrieve the total number of orders placed.
- Determine the hourly distribution of orders.
- Calculate the average number of pizzas ordered per day.
- Identify the highest-priced pizza.
- Determine the most common pizza size ordered.
- Find the top 5 most ordered pizza types.
- Calculate the total quantity ordered by pizza category.
- Determine the distribution of pizza types by category.
- Calculate the total revenue generated.
- Identify the top 3 revenue-generating pizza types.
- Calculate the percentage contribution of each pizza category to total revenue.
- Analyze cumulative revenue over time.
- Identify the highest revenue-generating pizza within each category.
- Total Orders: 21,350
- Total Revenue: $817,860.05
- Peak Order Time: 12 PM – 1 PM
- Average Pizzas Ordered per Day: 138
- Highest-Priced Pizza: The Greek Pizza ($35.95)
- Most Ordered Pizza Size: Large (L)
- Most Ordered Pizza Type: The Classic Deluxe Pizza
- Highest Quantity Ordered Category: Classic
- Highest Revenue-Generating Pizza: Thai Chicken Pizza
- Highest Revenue Contribution: Classic Category (26.91%)
SQL-Pizza-Sales-Analysis
│
├── Dataset
│ ├── orders.csv
│ ├── order_details.csv
│ ├── pizzas.csv
│ └── pizza_types.csv
│
├── SQL Scripts
│ ├── data_file.sql
│ └── queries.sql
│
├── Report
│ └── SQL_Pizza_Sales_Analysis_Project.pdf
│
├── Images
│
└── README.md
The complete project report provides a detailed explanation of the project, including the dataset, SQL queries, outputs, business questions, methodology, and key insights.
📥 View the complete project report here:
➡️ SQL Pizza Sales Analysis Report
Uma Suryavanshi
Aspiring Data Analyst passionate about SQL, Power BI, Excel, and Python, with a strong interest in transforming raw data into meaningful business insights.