Swiggy Sales Analytics & Business Intelligence Dashboard
An interactive Swiggy Sales Analytics Dashboard developed using Microsoft Excel to analyse sales performance, customer ratings, order trends, food categories, and geographical sales distribution. The dashboard provides actionable business insights through interactive filters, KPI cards, and charts.
Problem
The food delivery business generates large volumes of transactional data across multiple restaurants, food categories, geographical locations, and customer interactions.
Analyzing this data manually makes it difficult to understand overall business performance, identify sales trends, compare geographical performance, and monitor customer satisfaction.
The key challenges included:
- Sales Performance Monitoring: Difficulty tracking total sales, average order value, and order volumes from large datasets.
- Trend Analysis: Limited visibility into monthly, weekly, and daily sales performance.
- Geographical Analysis: Difficulty identifying high-performing states and cities based on sales contribution.
- Customer Satisfaction: Lack of a consolidated view of customer ratings and rating counts.
- Food Category Analysis: Difficulty comparing vegetarian and non-vegetarian sales performance.
- Data Exploration: Limited ability to filter and analyze data based on months, food categories, and restaurant names.
The objective was to transform raw sales data into an interactive dashboard that simplifies business reporting and supports data-driven decision-making.
Solution
Developed an interactive Swiggy Sales Analytics Dashboard using Microsoft Excel, leveraging PivotTables, PivotCharts, and interactive slicers to transform raw transactional data into meaningful business insights.
The solution consists of the following components:
1. Data Organisation and Analysis
Structured the sales dataset using multiple business attributes, including:
- State and City
- Order Date, Day, Month, Quarter, and Week
- Restaurant Name and Location
- Food Category and Dish Name
- Food Type (Veg / Non-Veg)
- Price, Customer Rating, and Rating Count
2. KPI Monitoring
Created KPI cards to provide a consolidated overview of business performance:
- Total Sales: ₹53.01 Million
- Average Rating: 4.34
- Rating Count: 5.59 Million
- Total Orders: 197.43K
- Average Order Value: ₹268.51
3. Interactive Sales Analysis
Implemented multiple visualisations to analyse business performance:
- Monthly Sales Trend
- Daily Sales Trend
- Weekly Sales Performance
- Sales Distribution by Food Type
- State-wise Sales Distribution
- Top 5 Cities by Sales
- Quarterly Sales, Ratings, and Orders Comparison
4. Interactive Filtering
Integrated Excel slicers to enable dynamic data exploration using:
- Months
- Food Categories
- Restaurant Names
Users can apply filters to explore specific business segments and analyse performance from different perspectives.
Tools
- Microsoft Excel
- Excel PivotTables
- PivotCharts
- Excel Slicers
- Data Analysis
- Data Visualization
- Dashboard Design
Result
The dashboard successfully transformed raw Swiggy sales data into an interactive business intelligence solution, providing a consolidated view of sales performance, customer ratings, order distribution, and geographical trends.
Business Benefits
- Centralised Reporting: Consolidated multiple business metrics into one interactive dashboard.
- Improved Visibility: Enabled quick monitoring of sales, ratings, and order performance.
- Trend Identification: Helped identify monthly, weekly, and daily sales patterns.
- Geographical Insights: Enabled comparison of sales performance across different states and cities.
- Category Insights: Provided visibility into vegetarian and non-vegetarian sales contributions.
- Flexible Analysis: Enabled users to explore specific restaurants, months, and food categories using interactive slicers.
- Better Decision-Making: Provided a structured reporting solution to support business performance evaluation and strategic planning.
