Pizza Sales | Business Insights

From Data to Business Decisions

Data extracted & analyzed using SQL, then modeled & visualized in Power BI

Orders stable, avg 2+ pizzas/order → opportunity for Upselling

Revenue ≈ Cost → Profit Margin needs improvement

Classic → highest sales volume, Large sizes preferred

Peak months: July – May – January

Highest demand on weekends

Top Pizzas: Classic Deluxe, Pepperoni,

Hawaiian, Barbecue Chicken, Thai Chicken

Low Performing: Brie Carre, Mediterranean, Calabrese, Spinach Supreme, Soppressata

Chicken pizzas → highest revenue

Veggie & Special → lowest revenue

Key Takeaways:

Classic → Volume Driver

Chicken → Profit Driver

Veggie & Special → Low Demand

Recommendations:

Maximize Top Products → Bundles & Upselling

Protect High-Revenue Products →

Premium positioning & pricing

Take Action on Low Performers → Offers, Bundles, or Discontinue

Manage Menu as Portfolio → Volume, Profit, Experimentation

Dashboards don’t create value. Decisions do