Creating a Comprehensive Zomato Dashboard

Creating an insightful dashboard for Zomato can help in visualizing and understanding various aspects of food orders, sales, and user performance. Below is a detailed walkthrough of how I developed a Zomato dashboard with four main tabs: Index, Dashboard, User Performance, and City Performance.

1. Index Tab

The Index tab serves as the dashboard's landing page. It contains buttons leading to other tabs for easy navigation. The main button directs users to the Dashboard tab, where they can explore various visualizations and insights.

2. Dashboard Tab

The Dashboard tab is the core of the visualization, providing several key insights into Zomato's performance:

Slicers

I included slicers to filter the data based on food orders via Swiggy across different city tiers:

Top 100 Cities
Top 50 Cities
Top 20 Cities
Top 5 Cities
All Sales

These slicers allow users to dynamically adjust the data scope and focus on specific segments of interest.

Visualizations

Non-Veg Orders Sale vs. Veg Orders Sale: This comparison helps in understanding the preference for non-vegetarian and vegetarian food across various cities.
Other Sales: Includes insights into different sales categories, providing a broader view of the overall sales performance.
Rating of All Categories: Displays ratings across different food categories, helping in assessing customer satisfaction.

Dynamic Headline

A measure was created to change the headline dynamically based on the sales data. This feature makes the dashboard more interactive and informative.

Sales Value by Year

A line chart visualization was added to depict the sales value over the years. This helps in identifying trends and growth patterns over time.

3. User Performance Tab

The User Performance tab focuses on customer behaviour and demographics:

Gain and Loss of Customers: This visualization provides insights into the net gain or loss of customers, helping in understanding customer retention and churn.
Customer Gender-wise Analysis: Breaks down the customer performance by gender, offering a deeper look into gender-based preferences and trends.

4. City Performance Tab

The City Performance tab provides a detailed analysis of Zomato's performance across various cities:

Performance of All Cities: Gives an overview of how each city is performing in terms of sales and user engagement.
Sales Value by City: A detailed view of the sales value for each city, helping in identifying the top-performing and underperforming cities.
Rating Count by City: Displays the number of ratings received by each city, which can be used to gauge customer satisfaction.
Active Users by City: Shows the number of active users in each city, providing insights into user engagement and activity.

Measures Created

To enhance the dashboard's functionality and interactivity, I created several measures, including:

Dynamic headline measure
Sales growth measure
Customer gain/loss measure
Gender-based performance measure

These measures help to provide more accurate and insightful visualizations, making the dashboard a powerful tool for data-driven decision-making.

This comprehensive dashboard provides a detailed and dynamic view of Zomato's performance, helping stakeholders make informed decisions based on various insights and trends.