Advanced SQL Data Analysis Project | Zomato SQL Project (Guided) - Portfolio Series #3/10 - Datasets

Zomato SQL Project - 20 Advanced Business Problems | SQL Portfolio
Welcome to the SQL Data Analysis Portfolio Project series! In this video, we'll dive into a Zomato-based project designed to sharpen your SQL skills with 20 real-world business problems.

🐍 All Python Projects:
Python ETL - Data Cleaning Project

🛢All SQL Projects
Project 1:

Project 2:

Project 3: (Advanced SQL)
🎯 Zomato Food Company Data Analysis

Project 4:
🎯 Netflix Movies Data Analysis

Project 5:
🎯 Amazon Sales Analysis (Advanced SQL)

Project 6:
🎯 Spotify Data Analysis

Project 7: (Advanced SQL)
🎯 Apple Retail Sales Analysis - 1M Sales Records

Project 8: (Real Business Problems)
🎯 Monday Coffee Extensions Analysis

Get the Complete Project: Need the dataset? Get the full project for just $5! It includes:
Datasets and a PowerPoint presentation.
20 critical business problems with step-by-step solutions.
20 additional challenges.
A ready-to-use README for GitHub.
Get the project dataset:

You’ll have all the resources to complete this project and even include it in your resume. If you encounter any challenges while publishing, we're here to help! All of this is available for less than the price of a coffee—just $5!

What You'll Learn:
Database Design: Structure databases with tables and relationships.
Data Importing: Properly import data into your database.
SQL Queries: Solve complex business problems, including:
Top ordered dishes by customers.
Popular order time slots.
Average Order Value (AOV) analysis.
High-value customer identification.
Orders not delivered and more.

Whether you're preparing for a data analyst interview or looking to add valuable projects to your resume, this video is designed to help you achieve your goals. Make sure to follow along and complete the project with me!

⏰ Timestamps:
Intro: 00:00:00 - 00:05:00
Database Setup: 00:5:49 – 00:38:11
Data Import: 00:38:26 – 00:45:00
Q1 Solution: 00:45:15 – 1:00:15
Q2 Solution: 1:00:30 – 1:10:15
Q3 Solution: 1:10:30 – 1:14:45
Q4 Solution: 1:15:00 – 1:16:15
Q5 Solution: 1:16:30 – 1:22:45
Q6 Solution: 1:23:00 – 1:31:08
Q7 Solution: 1:31:23 – 1:37:23
Q8 Solution: 1:37:38 – 1:42:38
Q9 Solution: 1:42:53 – 2:00:18
Q10 Solution: 2:00:33 – 2:10:00
Q11 Solution: 2:10:15 – 2:24:28
Q12 Solution: 2:24:43 – 2:29:06
Q13 Solution: 2:29:21 – 2:34:06
Q14 Solution: 2:34:21 – 2:48:43
Q15 Solution: 2:48:58 – 2:55:33
Q16 Solution: 2:55:48 – 2:57:38
Q17 Solution: 2:57:53 – 3:01:13
Q18 Solution: 3:01:28 – 3:07:45
Q19 Solution: 3:08:00 – 3:16:18
Q20 Solution: 3:16:33 – 3:19:02
Project Publish on GitHub: 3:19:17 – 3:22:42

Best Data Analytics Course:

My Other YouTube Videos -
SQL 30 Days Road Map - [Free Learning Resources]

#SQL #DataAnalysis #PortfolioProject #DataCleaning #BusinessAnalysis #DataAnalyst #SQLProject #EDA #SQLTutorial #GitHub #DataScience #CareerInData #LearnSQL #SQLforDataAnalyst #AspiringDataAnalyst #ResumeProject #EndToEndProject

[zero_analyst]

Hello everyone
Get the datasets and all project related file by clicking link below!

Get the Complete Project: Need the dataset? Get the full project for just $5!
It includes:
☑Datasets (10k plus rows + 5 tables)
☑Project Schemas (Based snowflake schema
☑PowerPoint presentation.
☑20 critical business problems with step-by-step solutions.
☑20 additional challenges (For practice).
☑ Project instruction step by step.pdf
☑ All my solution with multiple approach
☑Your queries resolved (over mail)
☑Snowflake schemaA ready-to-use README for GitHub.
☑ Complete ready to use Github repository

[Aky-nj]

I don't know how I can thank you. I have never seen this kind of content free of cost. Now the expectations from you have become very high for future projects.

[zero_analyst]

⏰ Timestamps:
Database Setup: 5:49 – 38:11
Data Import: 39:00 – 45:00
Q1 Solution: 54:19 – 1:09:50
Q2 Solution: 1:10:00 – 1:19:00
Q3 Solution: 1:24:00 – 1:28:30
Q4 Solution: 1:28:31 – 1:29:50
Q5 Solution: 1:29:51 – 1:35:50
Q6 Solution: 1:35:51 – 1:43:59
Q7 Solution: 1:44:00 – 1:50:00
Q8 Solution: 1:50:01 – 1:55:00
Q9 Solution: 1:55:35 – 2:13:00
Q10 Solution: 2:13:50 – 2:23:17
Q11 Solution: 2:23:22 – 2:37:35
Q12 Solution: 2:37:37 – 2:42:00
Q13 Solution: 2:45:15 – 2:50:00
Q14 Solution: 2:50:01 – 3:04:23
Q15 Solution: 3:04:25 – 3:11:00
Q16 Solution: 3:11:10 – 3:13:00
Q17 Solution: 3:13:40 – 3:17:00
Q18 Solution: 3:17:43 – 3:24:00
Q19 Solution: 3:24:43 – 3:33:00
Q20 Solution: 3:33:56 – 3:36:25
Project Publish on GitHub: 3:36:35 – 3:40:00

[christianwiah]

Paid courses mostly do not get the outcome you've planned to have. But you're a smart lecturer, anyways

[dailymoto]

"A parent is the table that stores the primary key, A child is any table that references the parent with a foreign key

[jksd]

Bro charge like Rs99 or something Rs 500 for a dataset is insane.

[aishwaryaarya]

Plz make one real time Python(pandas) portfolio project and another Excel project in detail as you j=have made this one

[MEB_Aryan]

the other projects are going to be paid as well?

[robinskumar]

Sir, Atleast u can attach the dataset so that it results in some practice.

[VishalSharma-qfsi]

bro whats the purpose if i can download the data set n performing task . wy u asking money for that?

[veenasuresh]

Hello
No UPI.. I am from uk..net banking also not working to purchase how to pay and how to get the data

[hju]

plz make a real time python project on this or any other dataset

[praulayar]

Wont we get free dataset, i really appreciate your work and i have completed first video

[aradhyadev]

Hello Sir, I purchased Zomato's resources but received amazon's dataset. Please help. I've emailed you from topmate link.

[anuragshrivastava]

just for dataset you are charging huge amount what trend you started bro keep it 100 so that everyone can afford it

[tushardey]

Please give the dataset for free, make the next project paid

[mubarakshah]

maybe the whole project could be paid but at least tell us the data source or provide the dataset you are working on, not giving data set is insane