Scene 1

Scene 2

I am Sreya Basak I am an aspiring Data Analyst.   I will be analyzing the Zomato restaurant data for the city, Bangalore in MySQL workbench. I have executed some queries on the database and got some business insights which I will discuss here in the following slides.

Scene 3

Bangalore is one of the most ethnically diverse cities in the country, with over 51% of the city’s population being migrants from other parts of India Bangalore has a unique food culture. Restaurants from all over the world can be found here in Bengaluru, with various kind of cuisines. Some might even say that Bangalore is the best place for foodies. The food industry is always at a rise in Bangalore, with 12,000 plus restaurants currently active in the city, the number is still increasing. The growing number of restaurants and dishes in Bangalore is what attracts me to inspect the data to get some insights, some interesting facts and figures. So, in this project I will be working on 19,118 rows of data.

Scene 4

The dataset is taken from Kaggle. It contains the following features : name : This feature contains the name of the restaurant online_order  : whether online ordering is available in the restaurant or not book_table  : table book option available or not rate : contains the overall rating of the restaurant out of 5 votes : contains total number of upvotes for the restaurant rest_type  : restaurant type dish_liked  : dishes people liked in the restaurant cuisines : food styles, separated by comma avg_cost : contains the approximate cost of meal for two people meal_type  : type of meal city: contains the neighborhood in which the restaurant is located The dataset contains 19118 rows.

Scene 5

After cleaning the data of null values and blank rows we have the following business insights from the dataset…

Scene 6

1. No. of restaurants having the option for  online ordering

Majority of the restaurants(13,933 out of 19118) have the option for booking online. Restaurants having option for online ordering is -  13,933  ie  72.88% Restaurants not having option for online ordering is -  5,185  ie  27.12%

Total No Yes 0.2712103776545664 0.72878962234543365

Scene 7

2. No. of restaurants having the option to  book a table

Very high number of restaurants does not offer the service to book table, and very less do. This means that people at Bangalore prefer to eat at their homes or prefer fast food(snacks — quick bites). Only  4203  i.e  around 22% out of 19118 restaurants have the option of booking a table .

Total No Yes 0.78015482791086932 0.21984517208913065

Scene 8

BTM has the highest  number of restaurants, followed by Koramangala 7th Block. New BEL Road has the least  number of restaurants, followed by Banashankari. It seems that the main foodies live in BTM and Koramangala.

Total Banashankari Bannerghatta Road Basavanagudi Bellandur Brigade Road Brookefield BTM Church Street Electronic City Frazer Town HSR Indiranagar Jayanagar JP Nagar Kalyan Nagar Kammanahalli Koramangala 4th Block Koramangala 5th Block Koramangala 6th Block Koramangala 7th Block Lavelle Road Malleshwaram Marathahalli MG Road New BEL Road Old Airport Road Rajajinagar Residency Road Sarjapur Road Whitefield 347 476 559 423 778 522 1213 811 283 476 606 870 920 680 450 432 1111 1035 969 1122 684 436 494 730 245 596 314 622 400 514

Scene 9

The majority of restaurants (3016) are rated  3.9 (out of 5),  followed by 4 and 4.1, which are decent ratings. No. of restaurants rated 4 are 2631 and those rated 4.1 are 2468. There are very few restaurants with very high rating like 4.9 or 4.8. Also, there are very less number of restaurants that are rated below average.

Scene 10

Count of name 2 2.1 2.2000000000000002 2.2999999999999998 2.4 2.5 2.6 2.7 2.8 2.9 3 3.1 3.2 3.3 3.4 3.5 3.6 3.7 3.8 3.9 4 4.0999999999999996 4.2 4.3 4.4000000000000004 4.5 4.5999999999999996 4.7 4.8 4.9000000000000004 11 11 23 33 44 44 112 162 286 261 236 237 209 190 320 424 762 1448 2289 3016 2631 2468 1701 1151 600 259 119 53 10 8

Scene 11

Most of the restaurants at Bangalore are liked by the citizens and hence rated above average. The competition is at its best, as every restaurant is trying to excel in quality and services to increase the number of customers, and hence enhance profit.

Scene 12

5 .  Top 10 types of restaurant which have  the highest no. of restaurant

We see that, the most number of restaurants are of the type  Casual Dining. People at Bangalore prefer ‘ casual dining ’ and ‘ Quick bites ’ more often Followed by Café and Dessert  Parlour .

Casual Dining Quick Bites Cafe Dessert Parlor Casual Dining, Bar Delivery Bar Takeaway, Delivery Fine Dining Pub 6177 4767 1837 1005 638 616 301 284 272 219

Scene 13

6 .  Ten types which have  the least number of restaurants

There is only one restaurant of type ‘ Dhaba ’ followed by ‘food court, casual dining’ which have the least no. of restaurant.  There are also  very few bar, microbrewery, club and lounge  in the city of Bangalore.

Club, Casual Dining Microbrewery, Lounge Bar, Pub Cafe, Lounge Microbrewery, Bar Dessert Parlor, Kiosk Casual Dining, Irani Cafee Pub, Cafe Food Court, Casual Dining Dhaba 4 3 3 2 2 2 2 2 1 1

Scene 14

7. Number of restaurants for  different average costs

The majority of restaurants in Bangalore have  the average cost (for two) 400, followed by 600 and 800. This means that the competition is very high as far as the less costly restaurants are considered. The expensive ones in the range of  3000 to 5000 are very few in numbers.

Total 400 500 600 300 800 700 1000 200 250 450 750 1200 650 1500 350 550 900 1100 1300 150 1400 2000 1700 1800 3000 1600 850 100 2500 2100 950 1900 2200 4000 3500 2800 1350 180 2400 3400 230 40 1250 4100 1450 330 1050 4500 120 6000 3200 2700 5000 1650 3700 2300 2249 2013 1841 1531 1319 978 938 803 653 645 568 567 552 522 480 385 380 376 331 323 283 226 136 127 126 123 114 112 94 38 36 31 30 24 23 22 18 17 17 13 10 8 8 4 4 4 3 2 2 2 2 1 1 1 1 1

Scene 15

8. Top 10 cuisines that are offered by the  maximum number of restaurants

North Indian  cuisine is offered by most number of restaurants. North Indian and Chinese  served by more number of restaurants  than South Indian . Also, many Indians prefer to eat Chinese.

North Indian North Indian, Chinese South Indian Cafe South Indian, North Indian, Chinese Ice Cream, Desserts Desserts, Beverages Bakery, Desserts Chinese Desserts 957 659 325 243 227 208 198 191 179 168

Scene 16

Bangalore is situated in South India and yet people there prefer to eat North Indian cuisine. This can be due to the fact, that people from all sorts of backgrounds reside in Bangalore, hence they like North Indian and Chinese foods more than they do South Indian foods.

Scene 17

Byg Brewski Brewing Company SantÃƒÂƒÃ‚ÂƒÃƒÂ‚Ã‚ÂƒÃƒÂƒÃ‚Â‚ÃƒÂ‚Ã‚ÂƒÃƒÂƒÃ‚ÂƒÃƒÂ‚Ã‚Â‚ÃƒÂƒÃ‚Â‚ÃƒÂ‚Ã‚ÂƒÃƒÂƒÃ‚ÂƒÃƒÂ‚Ã‚ÂƒÃƒÂƒÃ‚Â‚ÃƒÂ‚Ã‚Â‚ÃƒÂƒÃ‚ÂƒÃƒÂ‚Ã‚Â‚ÃƒÂƒÃ‚Â‚ÃƒÂ‚Ã‚Â© Spa Cuisine Asia Kitchen By Mainland China Belgian Waffle Factory Punjab Grill O.G. Variar & Sons Biergarten The Black Pearl AB's - Absolute Barbecues Taaza Thindi The Big Barbeque Flechazo Communiti House Of Commons TBC Sky Lounge Maziga Big Pitcher ECHOES Koramangala Toit Opus Food Stories Lot Like Crepes The Blue Wagon - Kitchen Rim Naam - The Oberoi Koramangala Social The Pancake Story Oota Bangalore Dock Frost'd Smoke House Deli Caperberry Kurtoskalacs Baar Union Truffles The Fatty Bao - Asian Gastro Bar The Boozy Griffin Hunger Camp The Hole in the Wall Cafe Sea Lions BBQ & Grills Toast & Tonic Sea Rock MISU Yauatcha 1131 Bar + Kitchen Mugful Of Stories Chianti Hammered Galito's The Terrace at Gilly's Redefined Chili's American Grill & Bar The Reservoire Fenny's Lounge And Kitchen Roots 4.9000000000000004 4.9000000000000004 4.9000000000000004 4.8666666666666671 4.8499999999999996 4.8 4.8 4.7333333333333334 4.72 4.7 4.7 4.7 4.7 4.7 4.7 4.7 4.7 4.7 4.7 4.62 4.6166666666666654 4.6000000000000005 4.6000000000000005 4.5999999999999996 4.5999999999999996 4.5999999999999996 4.5999999999999996 4.5999999999999996 4.5999999999999996 4.5999999999999996 4.5999999999999996 4.5999999999999996 4.5999999999999996 4.5999999999999996 4.5999999999999996 4.5999999999999996 4.5999999999999996 4.5999999999999996 4.5999999999999996 4.5999999999999996 4.5999999999999996 4.5999999999999996 4.5999999999999996 4.5666666666666673 4.5666666666666664 4.5666666666666664 4.5666666666666664 4.5599999999999996 4.55 4.5250000000000004 4.5250000000000004

Byg  Brewski Brewing Company is the highest rated 4.9 and highest voted around 16000+. There is a sharp decrease in number of votes when moving from 2nd to 3rd positioned restaurant. no restaurant(or chain of restaurants) is rated 5 out of 5, however we have few who are rated 4.9. Asia Kitchen by Mainland China, Belgian Waffle and  Punjabg  Grill cuisines are top rated restaurants with a rating of 4.9 out of 5.

Scene 18

Top 50 rated Byg  Brewski Brewing Company, Toit, The Black Pearl, Big Pitcher--these are not only highly voted but also highest rated. The average cost are in the range of 1400-2000  i.e  they are a bit expensive. There are many restaurants that are rated above 4.0, which is a good thing as this indicates that the quality of food is increasing in Bangalore.

10. Top 50 rated vs 50 least rated  restaurants

50 Least Rated Fusion  Lounge,Decker's   Lane,Midnight  Hunger Solutions 24/7 and  Bageecha  are the least rated  i.e  2 and least voted around 300-400. The average cost of Fusion Lounge is 1500 but they do not provide service  upto  the mark. The average cost of other leas rated are within 600-800.

Scene 19

10. Top 50 rated vs 50  least rated restaurants

Name Rate Votes Average cost Byg  Brewski Brewing Company 4.90 16345.00 1600.00 SantÃƒÂƒÃ‚ÂƒÃƒÂ‚Ã‚‚Ã‚Â‚ÃƒÂƒÃ‚Â‚ÃƒÂ‚Ã‚Â© Spa Cuisine 4.90 246.00 1000.00 Asia Kitchen By Mainland China 4.90 2208.50 1500.00 Belgian Waffle Factory 4.87 1225.33 400.00 Punjab Grill 4.85 586.00 2000.00

Name Rate Votes Average cost Fusion Lounge 2.00 397.00 1500.00 Decker's Lane 2.10 242.50 400.00 Midnight Hunger Solutions 24/7 2.10 253.00 500.00 Bageecha 2.17 479.00 650.00 Mamma Mexicana 2.20 407.38 1000.00

Scene 20

Scene 21

Rating This restaurant has outstanding rating,  4.9 out of 5.0 and 16000+ voting .

Meal Type and Cuisine Microbrewery type of restaurant .  Meal type for different branches of the restaurant include Delivery, Dine-out and Drinks & nightlife, this means that  Byg  Brewski Brewing Company restaurant is one of those strong competitors in these types of meals.

Average Cost Bit costly, with the average cost(for two people)  1600  but when compared to normal pubs and bars then it seems to be a little cheaper, also the ratings and upvotes show that it is worthy .

Scene 22

The place the food the service everything was awesome. I was astonished by the size of this place. No wonder if is the second largest micro brewery in Asia. Ambiance is top notch. Amazing Ambiance with variety of delicious food with super fast and friendly service person. One of the best restaurants in North  Bangalore.The  competition is at its best, as every restaurant is trying to excel in quality and services to increase the number of customers, and hence enhance profit.

Scene 23

11. Which city is costlier in terms of food, and which are not with respect to  average cost for each city?

The average cost(for two) for restaurants is highest in  Church Street(550) , followed by Lavelle Road, Residency Road(500) and Brigade Road(500). For most of the cities the average cost is  400 . Banashankari has the lowest average cost, equal to  300 .

Church Street Lavelle Road Residency Road Brigade Road MG Road Indiranagar Whitefield Malleshwaram Frazer Town Old Airport Road Electronic City Bellandur Sarjapur Road Brookefield Koramangala 4th Block Rajajinagar Koramangala 7th Block Koramangala 5th Block Kalyan Nagar Koramangala 6th Block Marathahalli Kammanahalli BTM New BEL Road Bannerghatta Road HSR Jayanagar Basavanagudi JP Nagar Banashankari 989.33415536374844 970.26315789473688 969.22829581993574 961.05398457583544 938.43835616438355 825.12643678160919 760.50583657587549 742.82110091743118 740.27310924369749 739.42953020134223 710.77738515901058 707.77777777777783 696.9 647.41379310344826 644.05940594059405 643.69426751592357 636.46167557932267 633.40096618357484 628.88888888888891 624.42724458204339 621.65991902834003 619.79166666666663 609.46413849958776 604.69387755102036 583.99159663865544 577.0792079207921 571.75 569.67799642218245 568.54411764705878 520.74927953890494

Scene 24

12. Which city has the highest number of  restaurants with high ratings?

The average rating of restaurants in  Brigade Road(3.9), Church Street(3.9) and MG Road(3.9)  is highest, followed by Koramangala 4th Block(3.8), and Lavelle Road(3.8)  Electronic City(3.5), however has the lowest number of restaurants with good ratings. All cities have, on an average, great restaurants.

Church Street Brigade Road Residency Road Lavelle Road MG Road Koramangala 5th Block Koramangala 7th Block Koramangala 4th Block Koramangala 6th Block Malleshwaram Frazer Town BTM Rajajinagar Indiranagar Basavanagudi Jayanagar Kalyan Nagar Kammanahalli Old Airport Road Banashankari New BEL Road JP Nagar HSR Bellandur Whitefield Bannerghatta Road Sarjapur Road Electronic City Marathahalli Brookefield 3.9649815043156602 3.948586118251928 3.9418006430868178 3.9397660818713458 3.930547945205479 3.9219323671497639 3.9218360071301266 3.9172817281728167 3.9156862745098087 3.9061926605504564 3.8974789915966377 3.89010717230008 3.8878980891719768 3.8797701149425277 3.8796064400715511 3.8673913043478279 3.8620000000000019 3.8513888888888896 3.8432885906040335 3.8394812680115278 3.8359183673469399 3.8186764705882359 3.8019801980198058 3.7716312056737613 3.7607003891050592 3.7577731092437023 3.7395000000000014 3.68798586572438 3.6872469635627514 3.6750957854406106

Scene 25

13. Top 10 dishes  liked by the citizens  of Bangalore

People at Bangalore love  Biryani  the most(and why not its so delicious!!), then  Waffles  followed by  Masala  Dosa   and then  Chicken Biryani  and then.  Out of these Biryani accounts for the most(30%) liked dish by the people of Bangalore.

Biryani Waffles Masala Dosa Chicken Biryani Paratha Coffee Pizza Burgers Cocktails Cappuccino 166 67 55 54 48 38 34 32 28 25

Scene 26

14. Top restaurants serving Most liked dish 'Biryani' ,  along with their ratings and average cost

Bhairaveshwara Military Hotel eat.fit Andhra Biryanis Brundhavana Food Point Andhra Kitchen Andhra Ruchulu Donne Biriyani House Halo Chef M.M Restaurant Bharpur Aahar Suvarna Sree Food Paradise Spice Cove - I.V Sanctum Bhagini Kitchen And Bar SR Andhra Spicy House Biryani Miya Pallavi Restaurant Embers - Nandhana Grand Hotel 4.125 4.1000000000000005 4 4 4 4 3.9 3.9 3.9 3.9 3.9 3.8 3.8 3.8 3.8 3.8 3.8

Bhairaveshwara Military Hotel eat.fit Andhra Biryanis Brundhavana Food Point Andhra Kitchen Andhra Ruchulu Donne Biriyani House Halo Chef M.M Restaurant Bharpur Aahar Suvarna Sree Food Paradise Spice Cove - I.V Sanctum Bhagini Kitchen And Bar SR Andhra Spicy House Biryani Miya Pallavi Restaurant Embers - Nandhana Grand Hotel 250 300 700 300 400 400 400 500 600 200 400 750 1100 800 600 500 900

Scene 27

Bhairaveshwara  Military Hotel  with a rating of 4.2 serves the most liked dish ‘Biryani’ to the people of Bangalore. Then comes  eat.fit   followed by Andhra Biryani and Andhra Kitchens which provides one of the best qualities biryanis in Bangalore. All of these restaurants are rate 4.0 and above with an average cost of 250-400 which is quite budget friendly for the people. That’s the reason why the people of Bangalore love their Biryani the most as it within a affordable range not very expensive.

Scene 28

The Zomato dataset was analyzed to gain some insights of the food industry and food culture in Bangalore. We deduce some great results like which city has the most number of restaurants and hence highest number of foodies, we also saw that which city has high number of well-rated restaurants, what all cuisines are mostly preferred by people etc.

Zomato, Bangalore Data Analysis

Scene 1 (0s)

Scene 2 (6s)

Scene 3 (11s)

Scene 4 (51s)

Scene 5 (1m 28s)

Scene 6 (1m 41s)

Scene 7 (2m 9s)

Scene 8 (2m 35s)

Scene 9 (3m 13s)

Scene 10 (3m 41s)

Scene 11 (4m 17s)

Scene 12 (4m 35s)

Scene 13 (5m 2s)

Scene 14 (5m 35s)

Scene 15 (6m 25s)

Scene 16 (6m 53s)

Scene 17 (7m 14s)

Scene 18 (8m 45s)

Scene 19 (9m 28s)

Scene 20 (10m 9s)

Scene 21 (10m 19s)

Scene 22 (10m 52s)

Scene 23 (11m 22s)

Scene 24 (12m 18s)

Scene 25 (13m 16s)

Scene 26 (13m 42s)

Scene 27 (14m 34s)

Scene 28 (15m 5s)

Scene 29 (15m 28s)