Project link: https://colab.research.google.com/drive/1NCAPdPucX1GC3AvPnuQ2KFbi5anyvGfb?usp=sharing

Video link : https://youtu.be/fnnxiH8uAWk

Dataset link: https://drive.google.com/file/d/1eWhoMCy771RxLLaxFWlZAgp6P2yxV24b/view?usp=sharing

Zomato Dataset Analysis

Data Clearing

Missing values

Getting all NAN features

Q1. How many the restaurant do not accept Online Orders

Q2.What is the ratio b/w restaurants that provide and do not provide table booking?

Q3. How many types of restaurants do we have?

Q4. Find out the Most Luxurious Restaurant in Bangalore

Q5. Top 10 Most Expensive restaurants with approx. cost for 2 people

Q6.Find all the restaurants that are below 500(budget hotel) as well as Affordable

Q7. Total such various affordable hotels at a different location

Q8. Finding Best budget Restaurants in any location

Q9. Which are the foodie areas?

Q10. Geographical analysis

Q11. Bangalore Heatmap of Indian restaurants

Q12. Analysis on the bases of the Rating of each restaurant

Project Link : https://app.powerbi.com/groups/me/reports/6d9a3ae0-5685-4b64-b4a7-371cb2b58a06/ReportSection

About the Project 

1. The sales manager can see how much revenue the company is earning from which zone and in which zone we need to work so that they can improve the revenue of the company.

2. There are two types of products available in the products table so I create a chart to see what products the company is selling and how much revenue each type generates. After looking at the chart, the manager can decide which type of product the company needs to work on more.
3. There are basically two types of customers the company has so after seeing the chart from which type of customers the company is making or revenue and give them a small offer to sell more products.