Using SQL to manipulate and clean the data, analyzing to discover trends and patterns, dig insights in an understandable format.
The fields present in Items dataset are,
1. id
2. Order_id
3. Name
4. Is_veg/not
The fields present in Orders dataset are,
1. id
2. order_id
3. order_Total
4. restaurent name
5. order_time
6. rain_mode
7. on_time
95 unique orders are placed according to this dataset.
There are 3 modes namely -Heavy,moderate,drizzle with 0,2 and 5 as it's respective identifiers from the dataset.
There are 49 unique restaurents name present in the order history in the given dataset.
The Bowl company is the restaurent which holds the highest number of orders according to the swiggy customers present in the dataset. from the above results we can also categorize the restaurents as most favourite , favourite and least favourite by which required recommendations can be activated by the company to attract its customer to place an order.
From the above result, 2021, October holds the highest number of Orders.
From the above results we can conclude that October month has generated the highest revenue and March month has generated least revenue, considering this more discounts and offers can be included during the least revenue months to bosst up the sales.
There are 164 unique items.
Classic Mac & cheese is the most ordered item.
A. There are 180 veg items
B. There are 12 non veg items
C. There is 1 undefined category item
Here the undeifined category can be considered as Desserts.
There are 10 chicken based dishes present in our dataset.
There are 4 paratha items present in the dataset.
2 items are atleast placed in any order according to the given dataset.
Corn & Cheddar Quesadilla & Garlic Bread With Cheese
Corn & Peas Sub ( 15 cm, 6 Inch ) & Paneer Tikka Sub ( 15 cm, 6 Inch )
Corn & Peas Sub (15 cms, 6 Inch) & Paneer Tikka Sub (15 cms, 6 Inch)
Corn & Peas Sub (15 cms, 6 Inch) & Paneer Tikka Sub (15 cms, 6 Inch)
Crunchy Chicken & Paneer & corn Pasta
Daily Special Side Dish (Portion) & Phulka Chapati
Desi Dal Tadka with Jeera Rice & Nawabi Paneer Lababdar with Matar Pulao
Desi Dal Tadka with Jeera Rice & Triple Ripple Death by Chocolate
Dragon Chicken & Gobi Manchurian (Dry)
Dragon Chicken & Paneer Fried Rice
Farmhouse & Golden Corn
Fries (R) & Mcflurry Oreo Small
Fries (R) & McSpicy Paneer Burger
Fries (R) & New Chocolate Chip Muffin
Fries (R) & Snack box
Garlic Naan & Gobi Masala
Garlic Naan & Paneer Pulao
Garlic Naan & Strawberry Milk Shake
Ghee Paneer Masal Dosa & Kadai Paneer
Ghee Paneer Masal Dosa & Masala Kulcha
Ghee Paneer Masal Dosa & Phulka
Ghee Paneer Masal Dosa & Sambar Idli
Ghee Paneer Masal Dosa & Seven Taste Uttapam
Gobi Manchurian & Paneer Biryani
Gobi Manchurian & Paneer Pulao
Gobi Manchurian & Paneer Pulao with Kadhi
Gobi Manchurian & Phulka
Gobi Manchurian (Dry) & Paneer Fried Rice
Gobi Manchurian Dry & Paratha Kuruma
Gobi Masala & Paneer Pulao
Gobi Masala & Strawberry Milk Shake
Golden Corn & Paneer & Onion
Good ol' Rajma Chawal & Paneer Butter Masala with Mattar Pulao
Good ol' Rajma Chawal & Peri Peri Chicken with Egg Corn Rice
Hazelnut (Baby) & Strawberry (Baby)
Hazelnut Brownie & Jumbo Paneer Chole Wrap
Hazelnut Brownie & Paneer Signature Rice Bowl (Mini)
Hazelnut Brownie & Rajma Masala Rice Bowl (Mini)
Hazelnut Brownie & Super Saver Paneer Rice Bowl Meal
Idli (2 Pcs) & Poori Masala
Jumbo Paneer Chole Wrap & Paneer Signature Rice Bowl (Mini)
Jumbo Paneer Chole Wrap & Rajma Masala Rice Bowl (Mini)
Kadai Paneer & Masala Kulcha
Kadai Paneer & Phulka
Kadai Paneer & Sambar Idli
Kadai Paneer & Seven Taste Uttapam
Maggi Italiano & Mexican Fries (Chef Suggested)
Mango Mastani & Pomegranate Juices
Masala Kulcha & Mixed Vegetable Raita
Masala Kulcha & Onion Aloo Mixed Paratha
Masala Kulcha & Phulka
Masala Kulcha & Sambar Idli
Masala Kulcha & Seven Taste Uttapam
MASALA PURI & SEV PURI
Mattar Paneer & Punjabi Chaach Di-Bottle (Butter Milk)
Mattar Paneer & Tawa Ghee Phulka
McEgg Meal ( R ) & Mexican McAlooTikki Burger
Mcflurry Oreo Small & McSpicy Paneer Burger
Mcflurry Oreo Small & New Chocolate Chip Muffin
Mcflurry Oreo Small & Snack box
McSpicy Paneer Burger & New Chocolate Chip Muffin
McSpicy Paneer Burger & Snack box
Mixed Veg Raita & Peas Pulao
Mixed Vegetable Raita & Onion Aloo Mixed Paratha
Naan & Paneer Tikka Masala
Naan & Roti
Nawabi Paneer Lababdar Parotta Bowl & Paneer 65 with Chilli Garlic Fried Rice
Nawabi Paneer Lababdar Parotta Bowl & Sprite Can (300 ml)
Nawabi Paneer Lababdar Parotta Bowl & Triple Ripple Death by Chocolate
Nawabi Paneer Lababdar with Matar Pulao & Triple Ripple Death by Chocolate
New Chocolate Chip Muffin & Snack box
Oreo Brownie & Trio of Chocolate Jar
Oreo Cream and Fudge & Swiss Chocolate Ice cream
Palak Paneer Bread Kulcha Lunchbox & Palak Paneer Jumbo Lunchbox
Palak Paneer Bread Kulcha Lunchbox & Red Velvet Lava Cake
Palak Paneer Jumbo Lunchbox & Red Velvet Lava Cake
Paneer 65 with Chilli Garlic Fried Rice & Sprite Can (300 ml)
Paneer 65 with Chilli Garlic Fried Rice & Triple Ripple Death by Chocolate
Paneer Butter Masala with Mattar Pulao & Peri Peri Chicken with Egg Corn Rice
Paneer Pulao & Phulka
Paneer Pulao & Strawberry Milk Shake
Paneer Signature Rice Bowl (Mini) & Rajma Masala Rice Bowl (Mini)
Paneer Tikka Masala & Roti
Penne Arrabiata Pasta La Vista & Pind Di Daal Makhani with Jeera Rice
Phulka & Sambar Idli
Phulka & Seven Taste Uttapam
Poori Masala & Uttapam
Punjabi Chaach Di-Bottle (Butter Milk) & Tawa Ghee Phulka
Rasmalai & Veg Pulao with Raita
Sambar Idli & Seven Taste Uttapam
Schezwan Paneer Frankie & Tawa Paneer Frankie
Sprite Can (300 ml) & Triple Ripple Death by Chocolate
There are 171 item combos present in the dataset.