Power BI • SQL Server • DAX • Power Query
Pizza Sales Analysis Dashboard
An end-to-end business intelligence project analyzing pizza sales transactions to identify revenue performance, ordering patterns, product demand, category contribution, and underperforming items.
Executive KPI Summary
Core measures calculated using SQL and modeled visually in Power BI.
Daily Order Trend
Friday generated the highest total orders, followed by Thursday and Saturday.
Monthly Order Trend
July and January are the strongest months by order volume.
Sales by Category
Classic contributes the highest revenue and the highest quantity sold.
Sales by Size
Large pizzas dominate revenue contribution.
Best and Worst Sellers
Product-level ranking by revenue, quantity, and total orders.
Top 5 by Revenue
| # | Pizza | Revenue |
|---|---|---|
| 1 | The Thai Chicken Pizza | $43,434.25 |
| 2 | The Barbecue Chicken Pizza | $42,768.00 |
| 3 | The California Chicken Pizza | $41,409.50 |
| 4 | The Classic Deluxe Pizza | $38,180.50 |
| 5 | The Spicy Italian Pizza | $34,831.25 |
Bottom 5 by Revenue
| # | Pizza | Revenue |
|---|---|---|
| 1 | The Brie Carre Pizza | $11,588.50 |
| 2 | The Green Garden Pizza | $13,955.75 |
| 3 | The Spinach Supreme Pizza | $15,277.75 |
| 4 | The Mediterranean Pizza | $15,360.50 |
| 5 | The Spinach Pesto Pizza | $15,596.00 |
Top 5 by Quantity
| # | Pizza | Quantity |
|---|---|---|
| 1 | The Classic Deluxe Pizza | 2,453 |
| 2 | The Barbecue Chicken Pizza | 2,432 |
| 3 | The Hawaiian Pizza | 2,422 |
| 4 | The Pepperoni Pizza | 2,418 |
| 5 | The Thai Chicken Pizza | 2,371 |
Bottom 5 by Orders
| # | Pizza | Orders |
|---|---|---|
| 1 | The Brie Carre Pizza | 480 |
| 2 | The Mediterranean Pizza | 923 |
| 3 | The Calabrese Pizza | 927 |
| 4 | The Spinach Supreme Pizza | 940 |
| 5 | The Spinach Pesto Pizza | 957 |
Dashboard PDF Preview
Embedded directly from the Power BI PDF export. Open the PDF for the full two-page report.
Business Value
- Supports menu and promotion decisions by identifying revenue leaders and low-performing products.
- Improves staffing and inventory planning by showing peak order days and high-demand months.
- Connects SQL analysis with Power BI visuals to create a repeatable reporting workflow.