Analysis of a year's worth of sales data for a fictional pizza place. The goal is to identify sales trends, best-selling items, and peak operational hours to optimize business operations.
- Database: MySQL
- Tool: MySQL Workbench
- Query Language: SQL (Joins, Aggregations, Group By, Window Functions)
Based on the SQL analysis, here are the major findings:
- Total Revenue: $817,860.05
- Average Order Value: $38.31
- Top Revenue Generator: The Thai Chicken Pizza ($43,434)
- Best Selling Pizza (Qty): The Classic Deluxe Pizza (2,453 sold)
- Insight: While "Thai Chicken" brings the most money, "Classic Deluxe" is the most popular choice among customers.
- Busiest Time: 12:00 PM (Lunch Hour) with 2,520 orders.
- Second Peak: 1:00 PM & 6:00 PM (Dinner Rush).
- Recommendation: Staffing should be maximum during 12 PM - 1 PM to handle the lunch rush efficiently.
data/: Contains the raw CSV files (Orders, Pizza Types, etc.).pizza_analysis.sql: The complete SQL script containing all queries.
Created by Tejas Padole