Overview: This project involves using Excel, MySQL, Power BI and Tableau to analyze and visualize data from Zomato, focusing on restaurant details, ratings, reviews, and user preferences. The goal is to provide actionable insights for users, restaurants, and the Zomato platform. Objectives:
- Extract Zomato dataset or use API for relevant data.
- Clean and transform data for analysis.
- Conduct Exploratory Data Analysis (EDA) for insights.
- Create user and restaurant profiles.
- Perform geospatial analysis for location-based trends.
- Analyze the relationship between ratings and various factors.
- Design interactive dashboards for presentation.
- Optional: Explore predictive analysis and recommendation systems. Deliverables:
- Power BI and Tableau reports and dashboards.
- Documentation on data processes.
- Insights and recommendations for users, restaurants, and Zomato.