This Power BI dashboard provides a comprehensive analysis of a Pizza Restaurant Chain’s sales performance across multiple branches, managers, pizza categories, and time periods.
The dashboard is built to help business stakeholders monitor revenue trends, quantity sold, branch-wise performance, and managerial efficiency, enabling data-driven strategic decisions.
Analyze total sales and quantity sold across branches
Identify top-performing pizza types
Track monthly sales and quantity trends
Evaluate branch-wise and manager-wise performance
Monitor average sales amount to support pricing strategies
Enable leadership to make data-backed operational decisions
🍕 Certain pizza categories contribute the highest share of total revenue
🏬 A few branches consistently outperform others in sales and quantity
📈 Monthly sales trends show steady growth over time
👔 Manager performance varies significantly by branch
📦 High quantity sold does not always equal higher revenue, highlighting pricing impact
| Aspect | Details |
|---|---|
| Tools Used | Power BI, Microsoft Excel |
| Dataset | Pizza Sales Dataset |
| Report File | Pizza Sales Performance Dashboard.pbix |
| Visuals Used | Bar Charts, Line Charts, Pie Charts, KPI Cards, Map |
| Purpose | Business Performance Analysis & Reporting |
- Data Cleaning & Transformation using Power Query
- Data Modeling with proper table relationships
- DAX Measures created for KPIs:
- Total Sales
- Total Quantity
- Average Sales Amount
- Interactive slicers for Branch, Manager, and Pizza Type
- Executive-friendly KPI dashboard design
- Business storytelling using impactful visuals
💰 Total Sales
📦 Total Quantity Sold
📊 Average Sales Amount
🏬 Sales by Branch
🍕 Sales by Pizza Type
📅 Monthly Sales & Quantity Trends
👔 Manager Performance Analysis
This dashboard empowers business users to:
Identify high-revenue pizza categories
Optimize branch-level operations
Improve manager performance tracking
Support better inventory & pricing decisions
Gain quick insights through interactive analytics
Created by: Riddhi K
📧 Email: khanvilkarr02@gmail.com
🔗 LinkedIn: http://www.linkedin.com/in/kriddhi
⭐ If you find this project useful, feel free to give it a star!