Swiggy Business Analysis with SQL: A Data Analyst Portfolio Project | Swiggy Data Analysis with SQL
Hi,
In this video, we explore the world of Swiggy, one of India's largest food delivery platforms, through the eyes of a data analyst. Follow along as we'll use SQL to perform a comprehensive analysis of Swiggy's business operations and gain insights into the platform's performance.
We'll dive deep into Swiggy's data, you'll get an inside look at the company's operations and understand how Swiggy is able to serve millions of customers across India. You'll learn how data analysts use SQL to manipulate and clean the data, analyze it for trends and patterns, and visualize the insights in an easy-to-understand format.
Whether you're a data analyst looking to improve your skills, a business owner curious about how Swiggy works, or simply someone interested in data analysis and SQL, this video is for you. Watch as I showcase the power of data analysis in business decision-making and provide valuable insights into the world of Swiggy.
Here is the link to the item dataset:https://drive.google.com/file/d/1tBhn...
Here is the link to the orders dataset:https://drive.google.com/file/d/1W2-n...
Here is the link to the queries in solution:https://docs.google.com/document/d/16...
⏲️===TimeStamps===⏲️
00:00 Introduction
01:13 Distinct Food Items Ordered
02:05 Group vegetarian and meat items together
03:40 Count the number of unique orders
04:11 Show items containing chicken in their name
05:14 Find item names with Paratha
06:00 Average Items per Order
07:11 Item ordered the most number of times
08:30 Orders during rainy times
09:43 Unique restaurant names
10:15 Restaurant with most orders
11:57 Orders placed per month and year
14:06 Revenue made by month
16:00 Average Order Value
16:57 YOY Change in revenue using lag function and ranking the highest year
20:00 Restaurant with highest revenue ranking
24:00 Join order and item tables and find product combos using self join
Full Excel Project: • Full Excel Project | Excel tutorials for B...
SQL Introduction Project: • SQL Practice Project: Answering Business Q...