Pizza Sales Dashboard, SQL + Power BI

 

Data Analysis | Dashboarding | Business Insight

This project began with a simple business question: How can we use sales data to improve restaurant decision-making?

Approach:

I explored a Pizza Hut sales dataset to uncover patterns in order volume, sales by category, time-based performance, and customer behavior. I used SQL to clean the data and answer key queries such as top-selling items, peak order times, and sales by size and category.
Once the insights were extracted, I designed an interactive Power BI dashboard to visualize those findings — providing restaurant managers a quick view of KPIs and sales trends in real time

Tools & Technologies: SQL, Power BI, DAX, Excel

Outcome:

  • Delivered a clean dashboard with filters and dynamic charts
  • Helped simulate business decisions like which pizza size to promote, when to offer discounts, and which categories to upsell
  • Improved data storytelling by combining raw query logic with visual business insight