Analyzing Real time food ordering data using Excel! Interesting insights into customer preferences and behaviors in the food industry through swiggy data all over india.
The swiggy dataset of august 2021 contains the below mentioned fields :
1. Order date
2. City
3. user id
4. name of the Item
5. Category of the food
6. Day of the week
Total number of orders 1878
Number of Unique Item Purchased The total count is 46
Most Purchased food item all over india Chill gobi 65 - 124 times
Most ordered Food category Rice and Noodles - 460 times
user id who placed the maximum number of orders 5043 - 63 orders
City which has the highest record of order count Indore - 387
Most active order day Monday - 457 Orders
# Dataset and it's Fields
#Insights On overall dataset
#Total revenue per city
#Revenue vs Day of week
#Revenue Vs Order Date
Overall Data Visualization
