SQL Data Analysis Portfolio Project #01/10 | Beginner to Advanced Guide for Aspiring Data Analysts

Welcome to the first video in my SQL Data Analysis Portfolio Project series! In this video, I take you through an end-to-end project where I analyze a retail sales dataset. This project is perfect for aspiring data analysts looking to build their portfolio and enhance their resume with hands-on experience.

What You'll Learn:
Data Cleaning: Techniques to clean and prepare the dataset for analysis.
Exploratory Data Analysis (EDA): Uncover insights, patterns, and trends in the data.
Business Problem Solving: Step-by-step guide on solving key business problems using SQL.
Publishing & Sharing: How to publish your dataset and clone the GitHub repository.

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!

Links:
GitHub Repository - Clone the project and get started -

Best Data Analytics Course:

🐍 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

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

[daneycm]

While Removing NULL values you ommitted the 'age' Column which has 10 NULL values, so after deleting all NULL values you should have 1987 rows left.

Great work!!

[vandanapatil]

Sir please create job oriented Data Analyst playlist with real world projects and interviews questions and answers 😊

[CarlosVolpe-wn]

Your consistency in creating videos and your clear explanations are truly impressive.🎉 It would be great if you could upload advanced-level Data Analytics projects for experienced professionals in Power BI, Excel, and SQL in the same style.

[vijayakumark]

Please upload next part soon... very well explained

[gozieprince]

I just subscribed this channel and your teaching is great ❤

[vinothkumars]

Good initiative... Gradually increase the number of tables, relationship and the analysis a bit advanced and more complex

[nikitabahety]

i am using mysql workbench. i got 1987 rows of data. guess the null values rows did not import. So is there any issues since if the age is not present in the data we can delete that row ?? if we would have done in python then deleting would have been the first option.. WHat harm is there if we use mysql with 1987 rows ?

[zabbymemon]

Not able to import the file csv. getting error as
:\program files\mysql\mysql workbench 8.0\modules\sqlide_power_import_export_be.py", line 431, in start_import self._editor.executemanagementcommand(query, 1) grt.dberror: ("unknown column 'none' in 'field list'", 1054) error: import data file: ("unknown column 'none' in 'field list'", 1054)

[careless_traveler]

Hey! I'm new to SQL so I'm not sure of this. Why would you 'CREATE TABLE' and add data types, instead of just importing the data as a CSV file? Is there any difference if I follow importing data as a CSV file over creating a table? I don't know much about this since I just started to learn SQL, great videos btw.

[raghuvarun]

Can u please upload series as quick as possible bcz it will helpful our careers

[arunsharma]

hey najir thanks for the videos, i have a query like i uploaded the dataset in mysql and i find that there is only 1987 records, so how can i handle this situation

[priyankapandey]

How would it be different if I want to do it in MySQL? Meaning what changes or points I need to take under considerations if I do it parallelly while watching your video?
Please let me know as it would help me with other project videos that you have uploaded as well. I have completed courses on SQL and new to making projects.

[NaveenKumar-fmyg]

in csv file there is a age column after gender column but while checking if the null are present in the column (timestamp 22.30) there is no age column after gender can you check it for me it show some null values in age column as well

[Renu_Ghogre]

can i download raw file instead of doing all of this

[sejalsingh]

One doubt....Is there any way of checking null values in the entire table instead of mentioning each one of them. Because what if we have hundred or more than that columns.

[nawafsharief]

When i did the null values check for the data, I have found 13 rows with null in which 10 rows are from the age columns, will this effect my analysis, in which 5 female and 5 male, any suggestion ?

[trad]

How often are you going to upload a video?

[makarsh]

why dont we just clean the data in excel and import it into DBMS ?

[MamidiAdithya]

In MS-SQL SERVER, TO_CHAR() & EXTRACT functions are not working bro, which one to use instead of those functions...

[abhishekdubey]

4:06 can you please tell how this effect is made? in obs or any shortcut key or in editing where ?