Zomato, an Indian multinational restaurant aggregator and food delivery company, was founded as FoodieBay in 2008 by Deepinder Goyal and Pankaj Chaddah. Renamed Zomato in 2010, the platform provides information, menus, and user reviews of restaurants, as well as food delivery options from partner restaurants in over 1000 Indian cities and towns.
Data Description
The dataset used for this analysis spans from 2010 to 2018 and includes approximately 9551 restaurant records across two sub-datasets: Restaurants_data and Country_data. These datasets contain detailed geographical information and various attributes related to restaurant operations.
Objectives
- Analyze restaurant distribution by city and country, and track restaurant openings by year, quarter, and month.
- Assess restaurant performance by average ratings and pricing distribution.
- Calculate service availability percentages, including table bookings and online delivery.
- Provide a global overview of restaurant services and popular cuisines.
Tools Used
- Microsoft Excel
- Tableau
- MySQL
- Microsoft Power Bi
Data Pre-Processing
The data was pre-processed to remove null values and unnecessary columns. Date formats were standardized for MySQL compatibility, and various manipulations were performed using Power Query Editor, Excel, MySQL, and Python.
Dashboards Using Different Tools
Microsoft Excel Dashboard
Power Bi Dashboard
Tableau Dashboard - click here
Key Analyses
1. Restaurant Distribution Analysis by Country and City
- Country-wise: India leads with 8652 restaurants, followed by the US (434) and the UK, Brazil, and South Africa (each with 80 or 60).
- City-wise: New Delhi dominates with 5473 restaurants, followed by Gurgaon (1118) and Noida (1080). This highlights India's dominance in the restaurant sector, with New Delhi as a major hub.
2. Restaurant Launching Analysis by Year and Month
- Yearly Trend: Restaurant openings remained stable from 2010 to 2018, with a slight increase from 1080 to 1102.
- Monthly Trend: The highest number of openings was in September (838), and the lowest was in February (745), indicating seasonal trends.
3. Restaurant Performance Based on Avg. Rating & Avg. Cost for Two
- The most common rating range is 3.1-3.5, with over 2500 restaurants. The fewest restaurants fall in the 1.6-2.0 range (10 restaurants).
- The most common cost range for two is ₹251-500, attracting over 3400 restaurants. The least common is ₹0-100, with just over 1000 restaurants.
4. Service Availability Percentages
- Online Delivery: 25.66% of restaurants offer online delivery.
- Table Booking: 12.12% of restaurants provide a table booking facility.
5. Global Restaurant Services Overview and Top Cuisines
- Cuisine Trends: North Indian cuisine is the most prevalent, significantly outnumbering other cuisines.
- This analysis offers insights into global distribution, popular cuisines, and dining costs.
Summary
- Country and City Distribution: India, particularly New Delhi, leads in the number of restaurants.
- Yearly and Monthly Trends: Restaurant openings are stable, with September being the peak month.
- Ratings and Costs: Most restaurants are mid-rated (3.1-3.5) and mid-priced (₹251-500).
- Services Offered: Online delivery (25.66%) is more common than table booking (12.12%).
- Cuisine Preferences: North Indian cuisine dominates.
Strategic Recommendations
- Expand Online Delivery Services: Increase online delivery availability to capture a larger market share.
- Enhance Table Booking Options: Expand table booking services to attract more customers.
- Focus on Mid-Range Pricing: Tailor menus and promotions to the ₹251-500 price bracket to maximize appeal.
- Leverage Popular Cuisines: Prioritize North Indian cuisine to cater to local preferences.
- Prepare for Seasonal Peaks: Optimize operations for the peak month of September.
- Increase Presence in Underrepresented Countries: Develop targeted marketing strategies for underrepresented regions.
Conclusion
This comprehensive exploratory data analysis of Zomato's restaurant data provides valuable insights into distribution, performance, service availability, and global trends. By leveraging these insights and implementing the strategic recommendations, Zomato can enhance its market presence and meet evolving consumer demands effectively.