Zomato Dashboard in Power BI

Overview

This project involves creating an interactive dashboard in Power BI to visualize key metrics for Zomato. The dashboard includes insights on total sales, orders, ratings, customer gains and losses, city-wise analysis, user-wise analysis, and an advanced level dashboard for comprehensive data exploration.

Features

• Total Sales: Visualization of total sales over time.
• Orders: Breakdown of the number of orders.
• Ratings: Analysis of customer ratings.
• Gain/Lost Customers: Insights into customer retention and churn.
• City-wise Analysis: Geographic breakdown of key metrics.
• User-wise Analysis: Examination of user behavior and demographics.
• Advanced Dashboard: Integrated high-level view with interactive elements.

Tools Used

• Power BI: For creating the dashboard.
• Data Sources: Sales records, customer feedback, user demographics.

Methodology

1. Data Collection: Aggregated data from multiple sources.
2. Data Cleaning: Processed and cleaned the data.
3. Data Modeling: Created data models to establish relationships.
4. Dashboard Design: Designed the layout and visuals.
5. Visualization: Used Power BI features to enhance functionality.

Insights

• Identified peak sales periods and high-demand products.
• Analyzed customer feedback for service improvement.
• Tracked customer retention rates and factors influencing churn.
• Determined high and low-performing cities for regional strategies.
• Gained understanding of user behavior and preferences.

How to Use

1. Open the Power BI file.
2. Navigate through the different tabs to explore various metrics.
3. Use the interactive features like slicers and filters to drill down into the data.

License

This project is licensed under the MIT License - see the LICENSE file for details.

Acknowledgements

• Zomato for providing the data.
• Power BI for the visualization tools.