Tool(s): PowerBi

Objective: Analyze historical pizza-order data to identify customer behavior patterns, best-selling pizzas, revenue trends, and overall product performance.

Process:

• Cleaned and structured raw data directly within Power BI.
• Used Power Query for data transformation and filtering.
• Built calculated measures and DAX formulas for deeper insights.
• Designed visuals including bar charts, line graphs, and donut charts.
• Applied slicers and filters for interactive, dynamic reporting.

Result:

• Top Pizza by Revenue: Barbecue Chicken Pizza was the highest earner.
• Category Insights: Classic and Supreme pizzas dominated revenue contribution.
• Size Preference: Large-sized pizzas (L) had the highest number of units sold.
• Customer Preference: Non-vegetarian pizzas made up 75% of total sales.
• Order Behavior:
  • 47.4K orders were single quantity, while 1.89K multiple-quantity orders had higher average value.
• Trend Insights:
  • Revenue peaks observed in April, July, and November, indicating seasonal spikes.
  • Sunday had the highest order volume.
  • Weekday sales made up nearly 75% of all transactions.
  • Classic pizzas led both in quantity sold and total revenue.

Recommendations:

1. Promote Top Performers

   → Feature combo deals for Barbecue Chicken and Classic pizzas.

2. Upsell Larger Sizes

   → Offer party packs or discounts for L and XL sizes.

3. Capitalize on Sunday Orders

   → Introduce Sunday-only family promos or loyalty perks.

4. Grow the Vegetarian Segment

   → Launch a dedicated vegetarian menu or specialty offers.

5. Encourage Bulk Orders

   → Implement bundle pricing to increase order size and revenue.

Screenshots: [Check the Gallery View ]

Download Analysis Doc: Pizza My Heart Detailed Analysis.docx