Pizza Sales Data Analysis 

Description

  • Dashboard Welcome to Pizza Sales Data Analysis...
  • Multiline_chart This is an End-to-End Data Analysis on the Pizza Sales Dataset using Power BI and SSMS (SQL Server Management Studio).
  • View_list This Dashboard offers:
    • swap_horiz Navigator button to switch between pages (Home & Best/Worst Sellers).
    • calendar_today Range dialer for specific date analysis.
    • filter_list Category filter dropdown to analyze specific Pizza categories.

Insights From The Data Analysis 

BUSIEST DAYS & TIMES

  • DAYS:

    Orders are Highest on weekends, Friday/Saturday evenings.

  • MONTHLY:

    There are Maximum orders from month of July and January.

SALES PERFORMANCE

  • CATEGORY:

    Classic Category contributed to Maximum sales & total orders.

  • SIZE Large:

    Size contributed to Maximum sales.

BEST SELLERS PIZZA

  • REVENUE:

    The Thai Chicken Pizza Contribute to maximum Revenue.

  • QUANTITY:

    The Classic Deluxe Pizza Contributes to maximum Total Quantities.

  • TOTAL ORDERS:

    The Classic Deluxe Pizza Contribute to maximum Total Orders.

WORST SELLERS PIZZA

  • REVENUE:

    The Brie Carre Pizza Contribute to minimum Revenue.

  • QUANTITY:

    The Brie Carre Pizza Contributes to minimum Total Quantities.

  • TOTAL ORDERS:

    The Brie Carre Pizza Contribute to minimum Total Orders.