Pizza Sales Analysis
Excel Dashboard & SQL Insights for Sales Performance
Excel Overview Dashboard
Project Overview
- Objective: Analyze pizza sales data to monitor business performance and customer preferences.
- Tools Used: Excel (Dashboard), SQL (Data QA & Analysis)
Problem Statement
The project aimed to extract actionable insights from pizza sales data. Using Excel for interactive dashboards and SQL for backend data validation, key business indicators were calculated and visualized to understand sales patterns, customer behavior, and performance of pizza categories and sizes.
KPIs Calculated
- Total Revenue
- Average Order Value
- Total Pizzas Sold
- Total Orders
- Average Pizzas Per Order
Dashboards & Visualizations
Daily & Hourly Trends
- Daily Orders Trend: Bar chart to highlight day-wise order volume
- Hourly Orders Trend: Line chart to identify peak order hours
Category & Size Performance
- Pizza Category Sales %: Pie chart of sales distribution by category
- Pizza Size Sales %: Pie chart showing preferred sizes
- Pizzas Sold by Category: Funnel chart to compare total pizzas sold by category
Product Performance
- Top 5 Best Sellers: Bar chart for highest-selling pizzas
- Bottom 5 Worst Sellers: Bar chart for least-selling pizzas
Key Insights
- Sales peaked during lunch and dinner hours, with 7 PM being the busiest time.
- Large-sized pizzas were the most preferred, contributing to over 50% of total sales.
- Classic and Veggie pizza categories performed best in terms of volume and revenue.
- Average order value remained consistent across weekdays but rose slightly during weekends.
- ‘Deluxe Veggie’ and ‘BBQ Chicken’ were the top-selling pizzas, while ‘Spinach Alfredo’ had the lowest sales.