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 -
github.com/naj...
1:1 Mentorship - topmate.io/zer...
SQL Live Workshop - zeroanalyst.co...
Excel Live Workshop - zeroanalyst.co...
Best Data Analytics Course:
Data Analyst Courses by Meta - imp.i384100.ne...
Data Analytics Foundation by Google - imp.i384100.ne...
Microsoft Business Analyst Course - imp.i384100.ne...
Microsoft Power Bi End to End Course - imp.i384100.ne...
My Other KZbin Videos -
SQL 30 Days Road Map - [Free Learning Resources]
- • SQL For Beginners | Gr...
How to Install PostgreSQL in Windows/Mac - • Learn SQL for Data Ana...
How Import Data into PostgreSQL (PgAdmin 4) - • Effortless Data Import...
Group By Video - • SQL For Beginners | Gr...
#SQL #DataAnalysis #PortfolioProject #DataCleaning #BusinessAnalysis #DataAnalyst #SQLProject #EDA #SQLTutorial #GitHub #DataScience #CareerInData #LearnSQL #SQLforDataAnalyst #AspiringDataAnalyst #ResumeProject #EndToEndProject

[@vandanapatil8182]

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

[@user-ur8ph9lj6f]

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.

[@zero_analyst]

Sure will make it!

[@vijayakumark6875]

Please upload next part soon... very well explained

[@zero_analyst]

Sure

[@trishnikagogoi358]

Your consistency is great!!!

[@zero_analyst]

Thank you for supporting!

[@gozieprince9530]

I just subscribed this channel and your teaching is great ❤

[@zero_analyst]

Thanks and welcome

[@vinothkumars7421]

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

[@Jreltaweel]

thank you 🙏

[@Ujjwalmishra-t1w]

Subscribed

[@zero_analyst]

Please share your feedback so i can work on it improve thank you

[@priyankapandey9675]

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.

[@bankimdas9517]

Thanks for this video sir

[@zero_analyst]

Thank you for supporting!

[@Renu_Ghogre]

can i download raw file instead of doing all of this

[@raghuvarun9801]

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

[@zero_analyst]

Project 2 uploaded please check

[@zero_analyst]

kzbin.info/www/bejne/bImVXoNvm7OJrNksi=eqimtm8H_iFxEiW7

[@arunsharma9008]

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

[@sejalsingh9608]

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.

[@zero_analyst]

This is the only way i follow!

[@Aurora-rd1fd]

Can we make it using MySQL?

[@zero_analyst]

Yes you can!

[@NaveenKumar-fm5yg]

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

[@zero_analyst]

Yeah it has some null values You can delete it or keep it based on the requirements!

[@makarsh29]

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

[@zero_analyst]

Yes we can do it in excel as well! This is a SQL project so we are using SQL to clean the data! in excel there are some limitations where you can only work if you have data upto 1.5M where you don't have any limit also once you create a function you can reuse it!

[@nawafsharief1134]

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 ?

[@zero_analyst]

Yes i missed age columns!

[@zero_analyst]

You can delete all null values!

[@nawafsharief1134]

Understood, thank you by the way. It's my daily routine to watch at least one of your video, if by any chance I miss I make up to next day !!

[@Aurora-rd1fd]

hey also when i did the count(*) function it gave 1987 rows not 2000, was it the same for you? idk why sql didn't imported rows with null values, did you do your project with 1987 rows?

[@MOTIVATIONALQUOTE-wt3de]

@@Aurora-rd1fd do this in pg admin then it will import 2000 rows.

[@TejashwiniSU]

im not able to do the steps mentionedd in command promt???

[@zero_analyst]

You can download the file from the from my github!

[@rishabhchauhan8612]

While importing data into MY SQL there are only 1987 rows are showing

[@zero_analyst]

Please use Postgresql and pgadmin 4 check my another video how to install pgadmin 4 kzbin.info/www/bejne/rmiWlaOXjt95pbs

[@MOTIVATIONALQUOTE-wt3de]

same problem bhai. i also only get 1987 rows in mysql.

[@ajaysherkhane8797]

​@@MOTIVATIONALQUOTE-wt3de Even I got the same count. The reason is we have ten null values in the age column which are deleted apart from those three records.

[@piyushchaudhari5508]

@@ajaysherkhane8797 Same for me too I am only able to import 1987 rows, I also went through sir's importing lecture but the issue I have too detected is that only the Rows having any column null (13) is being left out. I tried to alter the table created to allow null values but result is still same. If anyone can help me with this, I will be truly grateful. Sir , if you are familiar with this issue kindly help. Thanks

[@jxjatin]

i am facing error on using To_char() func " Error Code: 1305. FUNCTION sq_project_p1.TO_CHAR does not exist " i am using mysql workbench

[@zero_analyst]

In MySQL you should have different function!

[@trad6078]

How often are you going to upload a video?

[@zero_analyst]

Part 2 uploaded today please check!

[@abhishekdubey9920]

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

[@zero_analyst]

I use tool call screenflow this is only only on mac!

[@bashadude]

No.of rows more than 11lkhs how to find max(Len(Column)) to identify character length manual it's not possible

[@zero_analyst]

You can use python script

[@piyushchaudhari5508]

Is there anybody who is getting issue in importing the whole 2000 rows in table in MY SQL. For me I am only able to import 1987 rows, I also went through sir's importing lecture but the issue I have detected is that only the Rows having any column null is being left out. I tried to alter the table created to allow null values but result is still same. If anyone can help me with this, I will be truly grateful. Sir , if you are familiar with this issue kindly help. Thanks

[@zero_analyst]

This project was built using postgres so you may have import issues!

[@rafita930]

es español carnal.

[@talibsaifi4224]

Hello could you please share your excel sheet

[@zero_analyst]

Check the video description! Download the dataset! First watch the full video! I have explain how to download the dataset! Also added git rep in the description!

[@sayakghosh1670]

the excel sheet that you provided has incomplete values

[@zero_analyst]

Just checked seems csv file has the correct number of data with 2000 rows! please go through the video and use PgAdmin4 and PostgresSQL As this dataset is only compatible with PgAdmin 4 and postgresql! If you want to know how to install and import file you can go through respective video mentioned in the description!