This project focuses on analyzing pizza sales data using MySQL to uncover key business insights related to sales performance, customer demand, order patterns, and product popularity. The goal is to transform raw transactional data into meaningful, decision-ready insights that can help a pizza business improve revenue, inventory planning, and operational efficiency.
This project is designed with a real-world business mindset
- Analyze overall sales performance and order volume
- Identify best-selling and least-selling pizzas
- Understand customer ordering behavior by time, size, and category
- Evaluate category-wise and size-wise demand
- Support business decisions using data-driven insights
The dataset contains detailed pizza order information, including:
- Order details (Order ID, Date, Time)
- Pizza names and categories
- Pizza sizes
- Quantity ordered
- Price and total sales
Dataset Used: Pizza Sales Dataset
SQL Queries Used: Pizza Sales Queries
Presentation (PPT): Pizza Sales Presentation
Interactive Dashboard: Pizza Sales Performance Dashboard (Power BI)
- SQL (MySQL)
- MySQL Workbench
- Data Aggregation & Joins
- Subqueries & CTEs
- Date & Time Functions
- Power BI (for dashboard visualization)
The Power BI dashboard created from the SQL analysis provides:
- Total Orders, Total Sales, and Average Orders per Day
- Orders distribution by hour
- Category-wise sales contribution
- Size-wise order comparison
- Quantity sold by pizza category
Dashboard View:
- Peak ordering hours are during afternoon and evening time slots
- Classic and Supreme categories contribute the highest order volume
- Large (L) size pizzas are the most frequently ordered
- Certain pizzas consistently outperform others in both quantity and revenue
These insights can help businesses optimize menu strategy, pricing, staffing, and inventory planning.
Pizza_Sales-SQL-Project/
│── data/
│── sql/
│── dashboard/
│── assets/
│── README.md
- Import the dataset into MySQL
- Run the provided SQL queries using MySQL Workbench
- Analyze results and export data if required
- Load processed data into Power BI for visualization
- Strong SQL querying and optimization
- Business-oriented data analysis
- Translating raw data into actionable insights
- Dashboard design and data storytelling
Samruddhi Savale Aspiring Data Analyst | SQL | Python | Power BI | Excel | Data Visualization | Data Cleaning
- GitHub: https://github.com/Samruddhi-Savale/Pizza_Sales-SQL-Project.git
- LinkedIn: https://www.linkedin.com/in/samruddhi-savale-7119a4284/
This project is licensed under the MIT License.