- Project Name: Pizza Sales Report
- Tools Used: Power BI, SQL
- Dashboard Link: Click Now
The aim of this project is to analyze key indicators for pizza sales data to gain insights into business performance. Specifically, the following metrics were calculated:
- Total Revenue: The sum of the total price of all Pizza orders.
- Average Order Value: The average amount spent per order, calculated by dividing total revenue by the total number of orders.
- Total Pizza Sold: The sum of the quantities of all pizzas sold.
- Total Orders: The total number of orders placed.
- Average Pizzas per Order: The average number of pizzas sold per order, calculated by dividing the total number of pizzas sold by the total number of orders.
Various charts were created to visualize different aspects of pizza sales data:
- Daily Trend for Total Orders
- Monthly Trend for Total Orders
- Percentage of Sales by Pizza Category
- Percentage of Sales by Pizza Size
- Total Pizzas Sold by Pizza Category
- Top 5 Best Sellers by Revenue, Total Quantity, and Total Orders
- Bottom 5 Best Sellers by Revenue, Total Quantity, and Total Orders
Rec.mp4
- Days: Orders are highest on weekends, particularly Friday/Saturday evenings.
- Monthly: Maximum orders are from the months of July and January.
- Category: Classic Category contributes to the maximum sales & total orders.
- Size: Large size pizza contributes to maximum sales.
- Revenue: The Thal Chicken Pizza contributes to maximum revenue.
- Quantity: The Classic Deluxe Pizza contributes to maximum total quantities.
- Total Orders: The Classic Deluxe Pizza contributes to maximum total orders.
- Revenue: The Brie Carrer Pizza contributes to minimum revenue.
- Quantity: The Brie Carre Pizza contributes to minimum total quantities.
- Total Orders: The Brie Carrer Pizza contributes to minimum total orders.
- Total Revenue: $817.86k
- Average Order Value: $38.31
- Total Pizza Sold: 49,574
- Total Orders: 21,350
- Average Pizzas Per Order: 2.32
This report provides a comprehensive analysis of pizza sales data, highlighting key metrics, charts, and insights to aid in understanding business performance.