This project provides an in-depth analysis of pizza sales using SQL, uncovering key insights such as total orders, revenue, top-selling pizzas, and category-wise sales. The goal is to optimize inventory, pricing, and marketing strategies based on data-driven findings.
Retrieve total orders and revenue
Identify the highest-priced pizza
Determine the most popular pizza sizes and types
Analyze sales distribution by category and time of day
Assess revenue contributions by pizza type and category
Provide actionable recommendations for growth
Total Orders: 21,350
Total Revenue: $817,860.05
Highest-Priced Pizza: Greek Pizza ($35.95)
Most Popular Size: Large (L) – 18,526 orders
Classic Deluxe (2,453 orders)
Barbecue Chicken (2,432 orders)
Hawaiian (2,422 orders)
Pepperoni (2,418 orders)
Thai Chicken (2,371 orders)
✅ Inventory & Pricing: Optimize Greek Pizza pricing & bundle deals for bestsellers
✅ Size Optimization: Maintain ample stock for Large (L) pizzas & upsell from Medium (M)
✅ Peak Hour Strategy: Adjust staffing & introduce pre-orders for efficiency
✅ Category Promotions: Leverage targeted deals for Classic (26.91%) & Supreme (25.46%) pizzas
✅ Marketing Focus: Promote top revenue-generating pizzas via social media & meal deals
✅ Increase Daily Orders: Launch lunch specials & expand delivery reach