Embedded Files
Zomato Footprint Analysis
Overview
Overview
The Zomato Dataset Analysis project aims to explore and analyze the Zomato dataset using SQL. The dataset contains information about restaurants listed on the Zomato platform, including details such as restaurant ID, name, location, cuisines, ratings, and services offered. Through SQL queries, various insights have been extracted to understand the restaurant landscape, customer preferences, and market trends.
The Zomato Dataset Analysis project aims to explore and analyze the Zomato dataset using SQL. The dataset contains information about restaurants listed on the Zomato platform, including details such as restaurant ID, name, location, cuisines, ratings, and services offered. Through SQL queries, various insights have been extracted to understand the restaurant landscape, customer preferences, and market trends.
Key Findings:
1. Rolling/moving count of restaurants in indian cities.
1. Rolling/moving count of restaurants in indian cities.
2. Which countries and how many restaurants with percentage provides online delivery option.
2. Which countries and how many restaurants with percentage provides online delivery option.
3. Finding from which city and locality in india where the max restaurants are listed in zomato.
3. Finding from which city and locality in india where the max restaurants are listed in zomato.
4. Types of foods are available in india where the max restaurants are listed in zomato.
4. Types of foods are available in india where the max restaurants are listed in zomato.
5. Which localities in india has the lowest restaurants listed in zomato.
5. Which localities in india has the lowest restaurants listed in zomato.
6. How many restaurants offer table booking option in india where the max restaurants are listed in zomato.
6. How many restaurants offer table booking option in india where the max restaurants are listed in zomato.
7. Avg rating of rests location wise.
7. Avg rating of rests location wise.
8. Find all the restaurants those who are offering table booking options with price range and has high rating.
8. Find all the restaurants those who are offering table booking options with price range and has high rating.
The analysis of the Zomato dataset reveals:
- India dominates with 90.67% of listed restaurants, followed by the USA at 4.45%.
- Only India and UAE offer online delivery, with 28.01% and 46.67% of their restaurants providing this service, respectively.
- Conn-aught Place in New Delhi leads with 122 listed restaurants, with North Indian cuisine being the most popular.
- 54 out of 122 restaurants in Connaught Place offer table booking, correlating with higher average ratings.
- "India Restaurant" in Kolkata stands out as the best moderately priced option for Indian cuisine, with high ratings, votes, and comprehensive services.
Conclusion
The Zomato Dataset Analysis project provides valuable insights into the restaurant landscape, customer preferences, and market trends based on the Zomato dataset. By leveraging SQL queries, the project offers actionable information for stakeholders in the food industry, including restaurant owners, customers, and Zomato itself.
The Zomato Dataset Analysis project provides valuable insights into the restaurant landscape, customer preferences, and market trends based on the Zomato dataset. By leveraging SQL queries, the project offers actionable information for stakeholders in the food industry, including restaurant owners, customers, and Zomato itself.
Page updated
Google Sites
Report abuse