Skip to content

Using SQL to manipulate and clean the data, analyzing to discover trends and patterns, dig insights in an understandable format.

Notifications You must be signed in to change notification settings

deva-246/DataAnalysis-on-Realtime-Swiggydata-using-SQL

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

9 Commits
 
 

Repository files navigation

DataAnalysis-on-Realtime-Swiggydata-using-SQL

Using SQL to manipulate and clean the data, analyzing to discover trends and patterns, dig insights in an understandable format.

Datasets

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 

Business Queries and solutions

  1. Count of unique number of orders that are placed

     ![image](https://github.com/deva-246/DataAnalysis-on-Realtime-Swiggydata-using-SQL/assets/75877347/9bfec0ac-9970-4719-8314-166057b0e2b6) 

    There are 95 unique users who have placed orders according to this dataset.

About

Using SQL to manipulate and clean the data, analyzing to discover trends and patterns, dig insights in an understandable format.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published