The Swiggy Sales Analytics Dashboard is an interactive business intelligence dashboard built entirely in Microsoft Excel.
The dashboard transforms raw restaurant and food ordering data into meaningful business insights using Pivot Tables, Pivot Charts, Power Pivot, Slicers, and Dynamic KPI Cards. It enables users to analyze restaurant performance, customer preferences, pricing trends, and ordering patterns through an intuitive and interactive interface.
This dashboard was designed to answer key business questions such as:
- Which restaurants receive the highest customer engagement?
- How do customer orders vary over time?
- Which price range is most common?
- What is the distribution of customer ratings?
- What percentage of dishes are Veg vs Non-Veg?
- Which cities have the highest average restaurant ratings?
- What actionable business insights can be derived from the data?
- State
- City
- Month
- Quarter
- Food Type
- Total Restaurants
- Average Rating
- Average Price
- Total Ratings
- Monthly Order Trend
- Average Price Trend
- Top 5 Restaurants
- Rating Distribution
- Veg vs Non-Veg Analysis
- Top Rated Cities
- Price Distribution
- Price vs Rating (Bubble Chart)
- Weekly Orders
- Business Insights Panel
- ⭐ Average customer rating is 4.34, indicating consistently positive customer satisfaction.
- 💰 Most dishes are priced between ₹201–₹300.
- 🥗 Veg dishes account for 71.2% of listed menu items.
- 🍕 Domino's Pizza records the highest customer engagement based on rating count.
- 📍 Kochi has the highest average restaurant rating among the top cities.
| Tool | Purpose |
|---|---|
| Microsoft Excel | Dashboard Development |
| Pivot Tables | Data Aggregation |
| Pivot Charts | Data Visualization |
| Power Pivot | Data Modeling |
| Slicers | Interactive Filtering |
| Excel Formulas | KPI Calculations |
| Conditional Formatting | Dashboard Styling |
Swiggy-Sales-Analytics-Dashboard
│
├── Dashboard
│ └── Swiggy_Sales_Analytics_Dashboard.xlsx
│
├── Dataset
│ └── Swiggy_Restaurant_Dataset.xlsx
│
├── Images
│ └── dashboard-preview.png
│
└── README.md
- Download the Excel dashboard.
- Open the workbook using Microsoft Excel (2021 or Microsoft 365 recommended).
- Enable editing if prompted.
- Use the interactive slicers to filter the dashboard.
- Explore KPIs, trends, and business insights dynamically.
✔ Dynamic KPI Cards
✔ Interactive Slicers
✔ Executive Dashboard Design
✔ Business Insights Panel
✔ Multiple Chart Types
✔ Professional Theme
- Data Cleaning
- Data Analysis
- Dashboard Design
- Business Intelligence
- Data Visualization
- KPI Development
- Excel Automation
- Pivot Tables
- Power Pivot
- Storytelling with Data
Harshith Narayan N
Aspiring Data Analyst passionate about transforming raw data into actionable business insights through dashboards, analytics, and visualization.
- 💼 LinkedIn: (https://www.linkedin.com/in/harshith-narayan-n-79196b1b7/)
- 📧 Email: harshith0041@gmail.com
If you found this project helpful or interesting:
⭐ Star this repository
🍴 Fork it
📢 Share your feedback