Advanced SQL Data Analysis Resume Project | Complex SQL (Guided) - Portfolio Series #5/10 - Datasets

This is an advanced SQL project where I've analysed a massive dataset of 21,600+ rows of sales data across 9+ Amazon tables. Get ready to conquer 22+ hard-hitting business problems using your SQL skills!

Get the Complete Project: Need the dataset? Unleash the full project for just $5! Here's what you'll get:

🎯 Get Latest SQL Guided Project (1M sales records)

🐍 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

You're prepping to ace your next data analyst interview.
You're looking to bolster your resume with impactful projects.

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:01:27
Database Setup: 00:1:45 – 00:52:11
Data Cleaning: 00:53:26 – 01:05:00
Q1 Solution: 01:04:30 – 1:17:30
Q2 Solution: 1:19:30 – 1:27:00
Q3 Solution: 1:27:20 – 1:34:45
Q4 Solution: 1:35:15 – 1:47:45
Q5 Solution: 1:46:30 – 1:53:00
Q6 Solution: 1:53:30 – 2:05:00
Q7 Solution: 2:07:00 – 2:10:00
Q8 Solution: 2:11:00 – 1:14:00
Q9 Solution: 2:15:00 – 2:21:00
Q10 Solution: 2:21:33 – 2:24:00
Q11 Solution: 2:25:00 – 2:41:00
Q12 Solution: 2:44:43 – 2:53:06
Q13 Solution: 2:54:00 – 3:00:00
Q14 Solution: 3:00:21 – 3:09:00
Q15 Solution: 3:10:00 – 3:16:00
Q16 Solution: 3:17:48 – 3:21:38
Q17 Solution: 3:22:00 – 3:29:13
Q18 Solution: 3:30:28 – 3:41:00
Q19 Store Procedure: 3:42:00 – 4:10:18
Project Publish on GitHub: 4:11:00 – 4:15:14

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]

Get the Complete Project: Need the dataset? Unleash the full project for just $5! Here's what you'll get:


Datasets & Sleek Presentation: Work with real-world Amazon data and explore the insights with a polished PowerPoint presentation.
20+ Business Challenges & Solutions: Dive deep into 20 critical business problems and master their step-by-step SQL solutions.
50 Bonus Easy to Medium Level SQL Problems :Based on each SQL topic ensuring you will learn every sql concepts

[MEB_Aryan]

atleast provide the dataset bro or if u are making it paid charge reasonable amount, 500rupees for the dataset doesn't make any sense

[gentallman]

It takes a lot to build something like this, and to teach and explain the process. I love your work, bro. I’ll definitely invest in this!
Thanks❤

[aishwaryapattnaik]

Charging 400+ for a single project feels a bit high for a student. If all the projects were offered together for one combined price, it would have made more sense.

Regarding the first question, it asks for the total quantity sold, but the calculation seems to be for the total number of orders. Also, I don't see the need for the third join with the Orders table, as using just the Products and Order_Items tables should be sufficient. Could you please clarify this?

[Rohitchauhan-kgsp]

what is the use of watching video if we don't have dataset for practice, price is not reasonable for a student.

[mrigankaghosh]

the project is one of the best
pls lower the price, indeed the quality is not compromised

[anshujha]

bhai agr project bna rha h na too dataset diya kr otherwise video dekh kr bhi kya fyda jb hum practice hii nhi kr skte too views se too earn kr hii rha h na

[sahilnaik]

This is clearly one of the best Projects out there on Youtube.
I watched and followed it till 43:00 mins just to know that the dataset is not provided.😐
Would really appreciate if you could provide it.

[ankuraggarwal]

check your solution for 19, that is incorrect

[subhajitchakraborty]

it is just for own. don't share like that if you are charging for dataset even.

[aradhyadev]

Pls help!! the dataset provided is of amazon usa instead of zomato

[georgewallace]

Hello @zero_analyst . I have a problem importing the orders table . i am using Mysql and it tells me that "Row import failed with error: Incorrect date value what might be the problem kindly help

[gozieprince]

Thank you, I’m here again. I love your eye glasses

[ankuraggarwal]

you didnt even provided the proper solution for q6, where is the top selling products in each category or the least selling?

[Ranjit-K]

Brother don't charge for the dataset atleast how you are expecting that the learner are going to learn without any data set

[nayazmohammad]

how do one get question requried data set

[hasanakhtar]

Just unsubscribed the channel seeing dataset is charged 😅