Data Analyst Projects | Cleaning and Exploring Data with SQL | Part 1

Build a Data Analyst portfolio with me!
In this video, we go through how to use SQL Server Integration Services (SSIS) to import data from CSV files into SQL Server Database. We also learn how to clean data and make it ready to be used for analytics. And then last, we explore the imported data with SQL for insights.

Stay Tuned for Part 2 | Visualizing Data with Tableau

--LINKS--

Access the SQL queries used in the demo from my GitHub repository

Cleaning Data:

Exploring Data:

HAPPY WITH THE CONTENT?

Timestamps:
00:00 Intro
00:00:40 Getting Data
00:02:05 Importing Data with SSIS
00:21:54 Cleaning Data with SQL
00:36:39 Exploring Data with SQL
01:03:55 Outro

#DataAnalytics #DataAnalyst #SQL

[samueloluwaseunapanisile]

I enjoyed every bit of this video. I was soaked in wish I could give it 1000 likes....Thanks for the time you put in it!

[samuelboakye]

There is something about learning from your own country man everything went smoothly
Thank you

[gabrielvaras]

Hello from Brazil 🇧🇷
Great job, Tks for Sharing!
Good bless you all ❤️🙏

[ErnestoSantos-rooc]

Thank You so much for this project. I always wanted to learn how to use sql and you're showing steps by steps and great work!.

[niketdubey]

need more videos for the projects
good job!

[njokuisaac]

Thanks a lot for this great content. I learnt a lot watching from the data importing with SSIS to writing of sql queries. Your videos deserve more than a thousand likes 🥰. Again, thanks for the great work!

[myha]

I enjoyed every corner of the video. Cant thank you enough for making this tutorial. Hope you have many many health and passion for going on this wonderful journey.

[jonxie]

thank you so much for this content, this is so much better than anything else i could find on youtube

[Polaynka_Bolgarka]

Hi, thank you for sharing with guide. But I did not get it when you set up the connection with database and table (06:17). I did not see portfolioDB in the SQL server. It is means that need before create DB and all tables in the SQL Server. It is correct?

[IarukaSkYouk]

thank you so much, this is really valuable as you go through the whole process and showing why and how you do it, explaining your actions.

[emmanuelmusyoki]

Best for beginners taking data analysis carreer

[danieldanso-aboagye]

wonderful piece. i was totally glued to the end. more of such videos pls

[victor_peral]

Awesome video with great contents.. thank you for sharing your knowledge..your channel is underrated you deserve more subscribers

[youyou]

Loving your content, just a piece of advice, to zoom in a bit so it's easier to read. Thanks for the videos!

[moviemusicmash]

thanks for your content. im a beginner, and the way you walk through your thinking process is very appreciated.
Wish I could have give you more ❤❤

[wondufantaw]

Great video with great explanation!!. Well explained! Can't wait for part 2!!!

[mattelliott]

thank you so much for this... probably the most challenging portfolio project i've done so far. helped me learn a ton tho. looking forward to more content.

[NomanKhan]

Great Video..need more videos like that..amazing

[ayojad]

Hey Angelina. Great video excellent explanation. My question is how did you set up the portfolioDB in ssms. Thank you

[mohsena.s]

Thank you much, pleas continue strong