Welcome to the Pizza Sales Analysis project! I dove into the delicious world of pizza, crunching the numbers to uncover hidden insights that could help our pizza business soar. From identifying top-selling pizzas to understanding peak order times, this analysis serves as the perfect recipe for business growth. Ready to explore the data behind your favorite pizzas? Let’s dig in!
SQL for data analysis
The goal of this analysis is to uncover key business insights from pizza sales. Through SQL queries, we’ve explored ordering patterns, popular pizza types, and customer preferences. Specifically, we aimed to:
Identify top-selling pizza categories (e.g., Chicken, Veg, Gourmet).
Analyze order frequency based on time of day and day of the week.
Understand revenue contributions from different pizza sizes (Small, Medium, Large).
Uncover ordering trends that could help optimize the menu and improve operations.
Our dataset is as rich as a cheesy pizza with all the right ingredients! It includes:
Tables Overview:
Orders: Captures each order’s date and time.
Order Details: Contains information about each pizza ordered, including quantity and pizza type.
Pizza Types: Describes each pizza’s name, category, and ingredients—everything from the spicy “Mexicana” to the savory “Chicken Alfredo.”*
Pizzas: Lists each pizza’s size and price, helping us break down sales by size.
Just like perfecting a pizza dough, working with raw data requires effort! Here’s what we tackled:
Editing Formats: Standardizing date and time formats for seamless analysis.
Handling Missing Values: Some orders were incomplete (missing pizzas or quantities), which we either removed or filled with default values based on the context.
Data Cleaning: We removed duplicates and incorrect entries, ensuring our analysis only used accurate and relevant data.
To assess our pizza business, we focused on these KPIs:
Total Sales: Overall revenue from all pizza orders.
Total Orders: How many pizzas were sold during the time frame.
Top Pizza Categories: Breakdown of pizza orders by category (Chicken, Veg, Gourmet, etc.).
Top-Selling Sizes: Which pizza sizes (Small, Medium, Large) are most popular.
Revenue Per Order: Average revenue generated per pizza order.
🏆Top-Selling Pizza Categories
Chicken Pizzas lead the pack, with the "Thai Chicken Pizza" being a crowd favorite.
Veggie Pizzas like "Italian Supreme" are popular among health-conscious customers.
Recommendation: Promote best-sellers like Chicken Pizzas during peak hours and create combo offers to drive more sales.
🕒 Order Patterns by Time of Day
Peak times: Lunchtime (12–2 PM) and dinner (6–9 PM) see the highest order volumes.
Insight: Most customers order larger pizzas during dinner, likely for family meals or parties.
Recommendation: Increase staff and prep time during these busy hours, especially for large pizza orders.
📊 Revenue Breakdown by Size
Large pizzas generate the highest revenue, though medium pizzas are the most frequently ordered.
Recommendation: Introduce upsell offers to encourage customers to upgrade from medium to large pizzas. Bundling deals could also work wonders!
🏅 Top 3 Pizzas by Sales br>
Thai Chicken Pizza (Large)
Italian Supreme (Medium)
Five Cheese Pizza (Large)
Recommendation: Feature these top performers prominently in your menu and promotions. Consider limited-time flavors or add-ons to capitalize on their popularity.
That's it for now! I might revisit this and expand it as I grow my skillset.