Zomato Analytics 🍕📊

A comprehensive Power BI dashboard analyzing Zomato's sales, user behavior, and city-wise performance from 2017 to 2020. Gain actionable insights into sales trends, customer demographics, and performance metrics across 822+ cities.

Live Link 🔗

View the Dashboard

---

Table of Contents

• Project Overview
• Features
• Dashboard Components
• Data Insights & Key Metrics
• Top Performing Cities
• Data Analysis Period
• Setup Guide
• Technologies Used
• Future Enhancements

---

Project Overview

Zomato Analytics delivers in-depth analysis and visualizations of Zomato’s sales performance, user behavior, and geographical metrics over four years. It leverages Power BI to provide easy-to-digest, interactive insights that highlight customer retention, order distributions, and sales trends, empowering data-driven decision-making.

---

Features

• Comprehensive Sales Analysis: Track yearly sales trends and compare veg vs. non-veg sales.
• User Demographics: Explore age-wise and gender-based user behavior and retention.
• City-Level Metrics: Examine city-wise sales, ratings distribution, and order density.
• Customer Insights: Analyze customer acquisition, retention, and churn patterns.
• Interactive Visuals: Dynamic graphs and charts for an engaging user experience.

---

Dashboard Components

1. Sales Overview:

   • Yearly sales trends from 2017 to 2020.
   • Sales metrics: Total sales, orders, and quantity.
   • Veg vs. Non-veg sales breakdown.

2. User Analysis:

   • Age group and gender distribution.
   • Customer acquisition and churn analysis.
   • User rating behavior.

3. City Analysis:

   • Top-performing cities by sales amount.
   • Rating distribution across cities.
   • Order density and city-wise performance metrics.

---

Data Insights & Key Metrics

• Total Sales Amount: 987M
• Total Orders: 150.3K
• Active Users: 77.9K
• Overall Ratings: 148.5K
• Total Sales Quantity: 2M

Significant trends observed include the peak user age group (25-30 years) and a sales boom from 2017 to 2019. The analysis also reveals a balanced distribution of veg (122M) and non-veg (106M) sales.

---

Top Performing Cities

1. Tirupati: 43M
2. Electronic City, Bangalore: 29M
3. Baner, Pune: 27M
4. Raipur: 23M
5. Others: 22M

These cities contributed significantly to overall sales, making them key markets for Zomato.

---

Data Analysis Period

The dashboard covers sales and user behavior from 2017 to 2020, capturing the following yearly sales figures:

• 2017: 0.09B
• 2018: 0.14B
• 2019: 0.41B
• 2020: 0.34B

The data illustrates a rapid increase in sales, peaking in 2019, followed by a slight decline in 2020.

---

Setup Guide

Requirements

• Power BI Desktop
• Basic familiarity with Power BI and Excel for data refresh

Steps to Run the Dashboard

1. Clone or Download the repository:

   git clone https://github.com/yourusername/zomato-analytics-dashboard.git

2. Open Power BI Desktop and load Zomato_Dashboard.pbix.
3. Refresh Data if necessary to reflect any recent updates.
4. Explore the dashboard using the interactive visuals and filters.

---

Technologies Used

• Data Visualization: Power BI
• Data Preprocessing: Excel
• Data Management: CSV files

---

Future Enhancements

1. Incorporate Real-Time Data: Integrate APIs for live sales and user data updates.
2. Detailed Churn Analysis: Expand on customer retention metrics and introduce predictive modeling.
3. Performance Optimization: Streamline data processing and visualization load times.
4. Mobile-Friendly Dashboard: Optimize visuals for mobile access via Power BI app.

---

Note: This project is created for analytical purposes using publicly available Zomato data and is not affiliated with Zomato.