This project focuses on analyzing pizza sales data using SQL to understand revenue generation, order trends, popular pizzas, and customer demand patterns.
This project analyzes pizza sales data using SQL to gain insights into business performance. The analysis focuses on revenue trends, customer demand, popular pizza types, and sales distribution to help improve sales strategy and inventory planning.
The dataset consists of multiple related tables
- Orders
- Order Details
- Pizzas
- Pizza Types
- Total number of orders placed
- Total revenue generated from sales
- Most popular pizza based on quantity sold
- Highest priced pizza
- Sales performance by pizza category and size
- INNER JOINs
- GROUP BY and ORDER BY
- Aggregate functions like SUM and COUNT
- Subqueries
- MySQL server
The analysis highlights top selling pizzas and overall revenue performance, providing insights useful for business growth and decision making.