Swiggy Power BI Dashboard – A Complete Overview
Introduction
This Power BI dashboard is designed to analyze Swiggy’s sales, user behavior, and revenue trends. The dashboard provides key insights into orders, user engagement, city-wise performance, and yearly trends. It helps Swiggy make data-driven decisions and improve operational efficiency.
1. Overview Section – Key Metrics at a Glance
The overview section highlights the most important performance indicators for Swiggy:
-
Total Orders Count: 150K → Total number of food orders placed.
-
Total Users Count: 100K → Number of unique users who have placed orders.
-
Top 10% Users Contribution: 100K → The number of users contributing to the top 10% of orders.
-
Total Rating Count: 148K → The number of ratings received for orders, showing customer feedback engagement.
👉 Why it matters?
This section provides a quick view of how Swiggy is performing in terms of customer engagement and order volume.
2. Sales Insights – Category-Wise Breakdown
The dashboard categorizes sales into vegetarian, non-vegetarian, and other food items, providing revenue insights for each.
-
Vegetarian Sales: 987M → Revenue generated from vegetarian food.
-
Non-Vegetarian Sales: 206M → Revenue from non-veg dishes.
-
Other Food Sales: 987M → Sales from additional categories like beverages, desserts, etc.
-
Average Prices for Each Category:
-
Veg: ₹182.11
-
Non-Veg: ₹55K
-
👉 Why it matters?
Swiggy can identify which food categories generate the most revenue and adjust pricing or promotions accordingly.
3. City-Wise Revenue Analysis – Top Performing Locations
The city-wise breakdown of revenue helps Swiggy understand which locations contribute the most to sales. The top cities include:
-
Tirupati: 43M
-
Electronic City: 29M
-
Baner, Pune: 27M
-
Raipur: 23M
-
Malviya Nagar: 17M
-
Sultanpur: 15M
-
Vastrapur, Ahmedabad: 13M
-
Indirapuram: 13M
-
Navrangpura: 12M
-
Rohini, Delhi: 12M
👉 Why it matters?
Swiggy can focus on high-revenue cities and expand its services or offer special promotions in these areas.
4. Sales Trend Over the Years – Analyzing Growth & Decline
The line chart at the bottom of the dashboard shows total sales amount by year. The trend indicates:
📉 A declining trend in total sales from 2018 to 2021. This decline might be due to various factors like market saturation, competition, or the impact of COVID-19.
👉 Why it matters?
Swiggy can analyze the reasons for the decline and implement strategies to boost sales, such as marketing campaigns, discounts, or expanding to new regions.
5. Interactive Filters – Customizing Insights
The filters on the right side allow users to analyze sales based on different rankings:
-
Default View → Shows the complete dataset.
-
Top 10 Cities → Displays cities with the highest revenue.
-
Top 20 Cities → Expands the view to more locations.
-
Top 30 & Top 100 → Further detailed insights.
-
Top 5 Cities → Highlights only the top-performing locations.
👉 Why it matters?
Filters help decision-makers focus on specific data points and analyze performance based on different levels of granularity.
Conclusion – How This Dashboard Helps Swiggy?
This Power BI dashboard simplifies complex business data and offers insights into Swiggy’s performance. It helps in:
✅ Understanding user engagement through order and rating data.
✅ Identifying high-revenue food categories and setting competitive pricing.
✅ Analyzing city-wise performance to focus on top-performing locations.
✅ Tracking yearly sales trends to make strategic decisions.
✅ Using filters to customize insights for better business intelligence.
This dashboard is a powerful tool for Swiggy’s management team to make data-driven decisions and improve overall business performance! 🚀
No comments:
Post a Comment