Description
- Welcome to Zomato Food Sales Data Analysis...
- explore The data used here is sourced from Zomato's comprehensive dataset covering various aspects of food sales across India. This dataset comprises seven tables: Food, Measure, Menu, Orders, RankTable, Restaurant, and Users.
Food Table contains features like:
- Food ID, Food Name, Cuisine, Price, Ingredients, etc.
Orders Table contains features like:
- Order ID, Order Date, Customer Name, City, State, etc. - Filter Data We meticulously clean and explore the raw data using Exploratory Data Analysis (EDA) and leverage SQL to transform and filter the information.
- Engineering Key features are then extracted through feature engineering, ensuring only the most relevant insights are culled for insightful report generation.
- Insights Power BI swoops in as the final weapon, crafting a compelling dashboard that crystallizes the unearthed Zomato food sales intelligence. This meticulous process yields actionable insights, empowering data-driven decision-making for the company.
Insights From The Data Analysis
Overview Business Analysis
Highest Revenue:
Top 4 Cities having highest number of Revenue were from Tirupati, Bangalore, Pune & Raipur.Sales by Year:
The Sales are comparetively low as compare to previous years which were like ₹0.41 Bn in 2018 and ₹0.14 Bn in 2020.Highest Sales Number:
Top 4 Cities having highest number of sales(orders) were from Bangalore, Old Gurgaon, Gorakhpur & Gwalior.
Use's Performances
User's Activity:
Total weekly active users currently are 78K producting 301K orders per week.Customer Counts:
The rate of gaining users is 12K which is very low as compared to losing users which is 33K.Customers by Age:
Zomato has majority of its users from age group of 20 years to 30 years.
User's Involvment
Category:
The User's are divided into 4 categories Student, Employee, Self Employee and House Wifes, where Student shares the majority of Orders by 52.6%.Gender Specific
Males has more orders and contribution on Sales Price with 171.85 K Orders & around ₹120 M spending, where females are with 128.71 K Orders & around ₹88 M spending.
Miscellaneous
Famous Cuisines
Most Selling Food Items Cusines are from North Indian Chinese, Indian Chinese and North Indian.Highest Selling
The Cusines with highest selling is North Indian Chinese Cuisine with Sales Price around ₹15 M.Business Growth
The Zomato Business took a toll from 2018 to 2020 where its order value and sale price both decreases as compared to 2018 and 2019 lossing 75% of sales value.