This dashboard provides a comprehensive overview of Zomato's user performance, offering insights into key metrics such as sales, user activity, and city-level performance. The dashboard is designed to help stakeholders understand user trends, identify areas of strength and weakness, and make data-driven decisions to optimize business strategies.
1. Overview:
-
Displays high-level metrics like total amount, quantity, ratings, and orders.
-
All SaleCityAmount: Presents a bar chart ranking cities by total sales amount.
-
Sale by Year: Shows the trend of total sales amount over the years 2017-2020.
-
Food Category Distribution: Displays the distribution of orders across Non-Veg, Veg, and Others categories.
2. User Performance: -
Gain/Lost Users: Visualizes the number of users gained and lost, indicating user growth and churn.
-
User by Age: Presents the distribution of users across different age groups.
3. City Performance: Sale_Value by city: Shows the top cities ranked by total sales value. -
Ratings by city: Presents the cities with the highest number of ratings.
-
User by city: Visualizes the distribution of users across different cities.
This dashboard helps:
- Decision-makers identify trends in Zomato's sales and customer engagement.
- Stakeholders gain actionable insights on top-performing regions, sales trends, and customer preferences.
- Data analysts in understanding the application of Power BI for real-world scenarios.
- Microsoft Power BI: Data modeling, interactive visualization, and real-time filtering. Utilized DAX for advanced analytics and custom calculations.
- Data Sources: Sampled datasets with simulated transaction and inventory data for Amazon sales. CSV and Excel data integrated from e-commerce platforms for real-world data insights.
- Power Query: Automating data transformations and refreshing reports from external sources. Integrating live data sources with APIs.
-
Index
-
Overview
-
User Performance
-
City Performance
-Regional Performance: Tirupati leads in sales, while Bikaner excels in user engagement (ratings and user base). Significant regional variations exist, highlighting the need for localized strategies.
-Product Performance: (Information on product performance is not available in the provided images. This section would require data on individual dishes or restaurant menus to analyze best-sellers and low-performing items.)
-Customer Behavior: High user churn rate indicates a need for improved customer retention strategies. User demographics show a concentration in the 25-30 age group, suggesting opportunities for targeted marketing campaigns.
-
Add interactive filters to segment data by location, time period, etc.
-
Incorporate user demographic information (e.g., gender, occupation) for deeper analysis.
-
Integrate real-time data for up-to-date insights.
-
Develop predictive models to forecast future user behavior.
The Zomato Sales Dashboard provides actionable insights into sales performance, user engagement, and city-wise trends. By analyzing key metrics such as sales growth, user retention, and food category distribution, stakeholders can make data-driven decisions to enhance business strategies.
✔ Sales Growth Analysis – Identifies revenue trends and peak sales periods.
✔ User Engagement Insights – Helps track new vs. lost users and customer retention.
✔ City-wise Performance – Enables location-based marketing and expansion planning.
✔ Food Category Trends – Understands customer preferences for better menu optimization.
With Power BI’s real-time analytics and interactive visualizations, this dashboard serves as a powerful tool for business intelligence, performance tracking, and strategic decision-making in the food delivery industry. 🚀