Zomato Restaurants analysis Report

INTRODUCTION

Zomato is a company that provides online order, food delivery and online restaurant booking facility. It has been collecting huge data of restaurants from different locations. Business managers of the company want our data analysts team to analyze it’s huge data. They want us to find insights that can help their company grow.

BUSINESS TASK

Zomato wants to tie up with more restaurants. So they want to know in which locations they should start providing their services and which type of restaurants they should start approaching . They also want to know, how they can use the data to convince shopkeepers into accepting their services.

Zomato’s new business client want to set up a restaurant, so they want to know in which location what category of restaurant they should set up and also which cuisines at what price they should sell to get good amount of customers in future once the restaurant is set. Moreover, they want to know how zomato ‘s services can help them in growing their business quickly.

Assumptions

• The information is still current and can be used to derive insights, which zomato’s business team can further use to make strategic plans.
• No outliers has a substantial impact on the data being used.
• The conclusions and recommendations based on insights derived from data will be accepted without any questions or objection.
• The company isn’t currently using any of the suggested solutions in the report.

Research/Guiding questions

1. What is the number of restaurants in each location?
2. How many restaurants have book table facility and how many don’t?
3. How many restaurants have online order facility and how many don’t?
4. How much is the average rating which restaurants with book table facility got?
5. How much is the average rating which restaurants with online order facility got?
6. How many restaurants in different locations provide book table facility and how many don’t?
7. How many restaurants in different locations provide online order facility and how many don’t?
8. How many different categories of restaurants are present in different locations ?
9. In which locations people prefer to give feedback/vote and is it dependent on the number of restaurants?
10. Which restaurant categories has got comparatively higher ratings and what could be the common responsible factor behind it ?
11. which category of restaurants are comparatively more expensive or cheaper?
12. average cost of cuisines in different locations ?
13. which cuisines have the most positive ratings?

Hypothesis

• Restaurants that have online order and table booking facility perform better.
• Restaurants where people can enjoy more by engaging in different social activities are rated more positively.

ANALYSIS RESULTS

We can see how the total number of restaurants present in different locations. Here, it’s clear that BTM has the largest number of restaurants, while Domlur has the least number of restaurants present

The book table facility is provided by very few restaurants , that is only about 5000 Restaurants are providing book table facility, while nearly 30000 Restaurants don’t have book table facility.

This above chart tells us that there are above 20000 restaurants which provide online order facility and a little more than 12500 restaurants which still don’t have online order facility.

The book table facility is provided by very few restaurants , that is only about 5000 Restaurants are providing book table facility, while nearly 30000 Restaurants don’t have book table facility.

Generally, ratings of restaurants with online order facility range from 2.8–4.7, with average rating being around 3.7 and ratings of restaurants which don’t have online order facility range from 3–4.5, with average rating being around 3.6

It’s shocking that almost all locations have huge number of restaurants who don’t provide book table facility as compared to those restaurants who provide book table facility and as BTM location has the highest number of restaurants, the number of restaurants who don’t provide book table facility is also the highest.

The location BTM has the largest number of restaurants who provide online order facilities(around 1700). It can be also seen that there are many restaurants from different locations who do not provide online order facility. Generally, in most locations the restaurants who provide online order facility are more than the restaurants who don’t provide online order facility . But, in few locations the restaurants who don’t provide online order facility are more than the restaurants who provide online order facility.

It seems like, majority of restaurants come under Delivery and Dine-out categories in different locations and as BTM has the highest amount of restaurants, it also has the highest amount of Delivery and Dine-out category restaurants compared to other locations.

The above chart shows the total amount of votes/feedback people residing in various locations chose to give. Surprisingly, the locations that have the highest number of restaurants (eg. BTM) haven’t gotten the largest number of votes/feedback from people of its location. This clearly shows that people from some location are more willing to give feedback compared to other locations. This also states that, some locations have better feedback system in place than others.

Surprisingly, restaurant category that have highest average cost are also the one’s most positively rated, they have an average rating of around 4.2. While the restaurants whose average cost is comparatively low are rated moderately with an average rating of around 3.8. People probably vote Pubs, Bars, Drinks, Nightlife restaurant categories more positively because they also get to engage in social conversations, participate in social activities, enjoy and have fun. So, the mood/vibe this restaurant category gives is also a deciding factor behind its high ratings.

As it can be seen from the chart, restaurants that fall in category of “drinks and nightlife” have the highest average cost. Next in line, is a similar category named “Pubs & Bars” which has nearly similar average cost. While, restaurants that fall in category of “Delivery and Desserts” have the least average cost for their services. Moreover, all category of restaurants have somewhat similar cost variation.

The above heatmap represents variation of average cost of different cuisines across different locations. The dark pixels state that a particular cuisine is not sold in that corresponding location by any restaurant as shown in the chart. Moreover, it’s pretty obvious that across all locations most cuisines are priced below 1000.

We can see that there’s difference in the ratings of various cuisines and also, the variation of ratings for each cuisines is huge. The cuisine with the highest average rating is Desert, beverages (4.2) and the cuisine with the lowest average rating is Café, fast food (3.4)

SUGGESTIONS

I will be giving recommendations based on the useful insights that we gathered from the data. The suggestions can be implemented by using our insightful data visualizations as a guidance.

• Zomato’s business team can target Locations that have least number of restaurants with book table and online order facility .
• Zomato’s marketing team can persuade our new target restaurant owner’s to use our services for online order facility and Book table facility by letting them know the benefits of it like customer having easier & effective access to their restaurant from home and by giving them a evidence based assurance of improving their restaurant ratings after using zomato’s services.
• Zomato’s business team and our new business client can also make use of feedback data to choose a location where they can get good amount of feedback from the customers as with time feedback is very helpful in improving services that businesses provides
• We can recommend our new business client to set up his restaurant in places that doesn’t have many restaurants and that they should also provide some space within their restaurant where social acitivies can take place.
• Once location is decided, we can recommend our new business client to open that category of restaurant which is present in less numbers in a particular location and that they should also consider standard of living and people’s spending habit on food in that particular location. If our client wants to open a restaurant where standard of living is low, they should choose those restaurant categories which not only are comparatively cheaper to run but also, the average price per customer can be kept low compared to other categories.
• We can recommend our client what competitive prices for every cuisine depending upon different locations should be kept and which restaurant category and cuisine that generally receives positive ratings from the customer.