Data-Analysis-on-Zomato-Dataset

Overview

Zomato is an Indian multinational restaurant aggregator and food delivery company founded by Deepinder Goyal and Pankaj Chaddah in 2008. Zomato provides information, menus and user-reviews of restaurants as well as food delivery options from partner restaurants in select cities.

Domain : Ecommerce

This dataset is downloaded from the kaggle. This dataset is having around ~7500 restaurants data across the globe. it consist of geographycal data, average ratings, average cost etc.

Analysis done using below questions:

1. How many unique restaurants & unique values present in each column.
2. Zomatos presence in how many Cities, Countries.
3. What type of cuisines are their.
4. What type of currencies does accepted by zomato.
5. Which country & how many restaurants have online delivery service.
6. Price range distribution.
7. Average rating distribution.

So, based on above few quetions we did Data Analysis using SQL server. and same analysis done in jupyter notebook. and visualize the insights using Power BI

The link for Zomato Dashboard :- https://app.powerbi.com/groups/me/reports/5cdbce5b-1eeb-4bf7-89a5-5513095910d0/ReportSection

Tools used:

1. MS SQL server & Jupyter notebook : for analysis
2. Power BI : for visualizing the insights

Glimpse of the Dashboard