Power BI Dashboard for Pizza Sales Analysis with insights on revenue, orders, and best/worst sellers.
Project Overview
This project is a Power BI dashboard that provides a comprehensive analysis of pizza sales data from Jan 2015 to Dec 2015. It helps businesses understand their sales performance, best/worst sellers, and customer ordering trends through interactive visualizations.
✅ Key Features
✔ Total Revenue: ₹817.86K ✔ Average Order Value: ₹38.31 ✔ Total Pizzas Sold: 49,574 ✔ Total Orders: 21,350 ✔ Average Pizzas per Order: 2.32
Dashboard Insights
- Sales Summary
Daily & Monthly Order Trends
Highest orders on Friday and Saturday evenings.
Peak months: July & January.
- Sales Performance By Category:
Classic pizzas contribute the highest sales & orders.
By Size:
Large size pizzas dominate sales (45.89%).
- Best/Worst Sellers
Top 5 Pizzas by Revenue:
The Thai Chicken Pizza, The Barbecue Chicken Pizza, The California Chicken Pizza.
Top 5 Pizzas by Quantity & Orders:
The Classic Deluxe Pizza is the leader.
Bottom 5 Pizzas:
The Brie Carre Pizza has the lowest sales & orders.
Tools & Technologies
Power BI Desktop – for creating the dashboard
Data Cleaning & Transformation: Power Query
Data Modeling: Relationships, DAX measures
Dashboard Preview Sales Performance View
Best/Worst Sellers View
Key DAX Measures
Total Revenue: SUM('Sales'[Revenue])
Average Order Value: DIVIDE([Total Revenue], [Total Orders])
Avg Pizza per Order: DIVIDE([Total Pizzas Sold], [Total Orders])
Business Insights
Focus on promoting Classic pizzas and Large sizes for maximum revenue.
Special marketing campaigns during weekends and peak months.
Improve sales of low-performing pizzas like Brie Carre through discounts or removal from the menu.
⭐ If you like this project, give it a star on GitHub!
#PowerBI #DataAnalytics #BusinessIntelligence