This project is all about worldwide Zomato Market and its services availability among different countries. Zomato is an Indian multinational restaurant aggregator and food delivery company. Zomato provides information, menus and user-reviews of restaurants as well as food delivery options from partner restaurants in more than 1,000 Indian cities and towns, as of 2022–23. Zomato rivals Swiggy in food delivery and hyperlocal space. In this Excel Project, I have used excel features to create this interactive dashboard. In this I have shown the connection of Zomato from the whole world and its overall ratings from the whole 15 countries. I have also described the number of restaurants in the countries, types of services available like has online delivery or not, will deliver it now or not and has table booking or not. Through these data I have made a beautiful interactive dashboards that consist of two pages. First one is for Cities wise distribution under Country category and the second one was about the top 3 cities, cuisines, restaurants and localities.
- Identifying the Problem : Firstly understood the data and its different variables through my analytical skills.
- Data Cleaning and Processing : Converted the data into Table with Filters, removed all duplicate values, changed data type, used text to column technique to separate the columns and use of VLOOKUP etc.
- Performing Descriptive Analysis : Inserted different meaningful Pivot table from the processed data and generated KPI from that Pivot.
- Data Visualization : Constructed various significant insights in order to derive relevant information from Pivot Chart.
- Enhanced Formatting : Altered the format of the Charts with the help of Format Painter.
- Creation of Dashboard : Created a meaningful dashboards by compiling all the relevant charts together and also inserted additional features like Slicers, Buttons from Macros, Scroll Bar from Developers etc.
In this Project, I have calculated the total numbers of worldwide restaurant as KPI, i.e. 9551 out of which India has the maximum number of restaurant i.e. 8652 whereas Canada has the least number of restaurant i.e. only 4.
- How many restaurants have availability online delivery on the worldwide basis ?
- How many restaurants have same time delivery service on the worldwide basis ?
- How many restaurants have table booking service on the worldwide basis ?
- Which cuisine is famous in all the countries restaurants and which one is famous in the top country restaurants ?
- Which cuisine has got highest voting worldwide than others ?
- Which locality is worldwide famous in case of restaurant based on voting and from which country does it belong ?
- Which restaurant is worldwide famous based on voting and from which country does it belong ?
- Which are the top 3 cities that are worldwide famous in case of restaurant based on voting ?
- Which are the top 3 cities that have highest number of restaurants in overall the world ?
- What rating, most of the restaurants has got on the worldwide basis and what rating, top country has got ?
- Which currency has got the highest average voting than other currencies ?
- What was the common price range rating of the overall restaurants and what does top country has got ?
- Which city has the highest average cost for two person on the basis of overall restaurant and from which country does it belong ?
- Which city has the highest average voting on the basis of overall restaurant and from which country does it belong ?
- Which city has the highest number of restaurants and from which country does it belong ?
-
The total number of restaurants that have online delivery service is 2451 and rest 7100 restaurants don't have online delivery service.
-
The total number of restaurants that have same time delivery service is 34 and rest 9517 restaurants don't have same time delivery service.
-
The total number of restaurants that have table booking service is 1158 and rest 8393 restaurants don't have table booking service.
-
The cuisine that is famous in all over the country is North Indian dishes followed by Chinese and Fast Food and the cuisine that is famous in top country i.e. India is also North Indian dish.
- The cuisine that has got the highest voting in the overall world is Pub Food and has got 1998 votes in the overall world, followed by Sunda and Cuban.
- The locality that is worldwide famous for restaurants and has got the highest average voting is Azad Nagar and has got 5145 votes which belongs to country India, followed by Koramangala 5th Block and Park Street Area.
- The restaurant that has got highest number of voting is Toit that has got 10934 voting and belongs to country India, followed by Hauz Khas Social and Peter Cat.
- City Bangalore is worldwide famous in case of restaurants and has got maximum number of average voting i.e. 2806 votes and belongs to country India, followed by Kolkata and Mumbai.
- City New Delhi has the maximum number of restaurants in the world and is belongs to country India, followed by Gurgaon and Noida.
- The most common rating that most of the country's restaurants have got is Average Rating with Orange Colour and the rating that is common in the top country i.e. India is also Average Rating.
- The currency that has got the highest average voting is Indonesian Rupiah (IDR) that has got 772 votes and belongs to country Indonesia.
- The most common price range rating that most of the country's restaurants have got is 1 i.e. Affordable and the rating that is common in the top country i.e. India is also 1 mean Affordable.
- The city that has the highest average cost for two persons is Jakarta which belongs from country Indonesia followed by Tangerang and Bogor and the city that has the least average cost for two persons is Miller followed by Inverloch and Lakes Entrance.
- The city that has got the highest average voting is Bangalore which belongs from country India followed by Kolkata and Mumbai and the city that has got the least average voting is Consort followed by Cochrane and Potrero.
- The city that has the highest number of restaurants is New Delhi which belongs from country India followed by Gurgaon and Noida and the city that has the least number of restaurants is Cochrane followed by Mayfield and Quezon City.
This Project is helpful in analyzing the sales market of Zomato. From this Project I would like to conclude that as Zomato is an Indian Company that's why is market is broader in India than in other countries as it is linked with only 15 countries and out of that 15 countries, It has greatly expanded its routes in India therefore all the top items from different categories are from India only. In India it has main markets in Bangalore, Mumbai and Delhi. Currently the services of Zomato is also limited which creates a breaker in its expansion. If the company will focus upon their advance services then they may be able to expand their branch and market worldwide. The main motive of this project is to gain knowledge about Zomato Company and its worldwide connections and to learn new features of excel.
- @Ritika821
- Ritika - Data Analyst