MySQL Exploratory Data Analysis | Full Project

Full MySQL Course: www.analystbuilder.com/course...
In this lesson we are going to be building an Exploratory Data Analysis project in MySQL!
Started Project by cleaning the data in this video: • Data Cleaning in MySQL...
GitHub Code: github.com/AlexTheAnalyst/MyS...
____________________________________________
SUBSCRIBE!
Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
____________________________________________
RESOURCES:
Coursera Courses:
📖Google Data Analyst Certification: coursera.pxf.io/5bBd62
📖Data Analysis with Python - coursera.pxf.io/BXY3Wy
📖IBM Data Analysis Specialization - coursera.pxf.io/AoYOdR
📖Tableau Data Visualization - coursera.pxf.io/MXYqaN
Udemy Courses:
📖Python for Data Science - bit.ly/3Z4A5K6
📖Statistics for Data Science - bit.ly/37jqDbq
📖SQL for Data Analysts (SSMS) - bit.ly/3fkqEij
📖Tableau A-Z - bit.ly/385lYvN
Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!
____________________________________________
BECOME A MEMBER -
Want to support the channel? Consider becoming a member! I do Monthly Livestreams and you get some awesome Emoji's to use in chat and comments!
/ @alextheanalyst
____________________________________________
Websites:
💻Website: AlexTheAnalyst.com
💾GitHub: github.com/AlexTheAnalyst
📱Instagram: @Alex_The_Analyst
____________________________________________
All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for

[@donnelly5757]

This pops up on my feed, and I figure what better way to start off my Tuesday by practicing some SQL! Thanks Alex!

[@matchagrlie]

Since this is an extension of the previous video, would you consider making a tableau video based on this data? Thank you so much for everything that you do! ♥

[@aditya3david]

This is so great Alex. You just saved me a ton of SQL pain

[@rakeshbasak6842]

really great man! because of you i just started enjoying the data analysis

[@rogue9169]

Very helpful with the rolling total way of doing it. It was a bit more complicated my way. Thanks

[@gilbertspark]

Great content! I am hooked with this series. Hey Alex, you can calculate the Total Employees, total_laid_off divided by percentage_laid_off. Keep the good content.

[@ernestowolabi]

Awesome video. Next up is visualizing the data 🙌

[@danieljamesfarquharson8421]

Thank God! Thank Alex!

[@muneebbolo]

Thank you so much Alex Keep it up!

[@tariq1841]

This is great Thanks alex

[@MultiSpaccatutto]

Hi Alex! As someone already said, a follow-through on Tableau would be amazing! Also how, based on this, how to import it to Tableau (and how to choose between the queries etc..)! Thx, great work

[@Mahmoudzekry]

Thanks Alex

[@premsagarkoppula237]

It was great ❤

[@mugomuiruri2313]

good alex ,watching all the way from africa

[@cjbrown3396]

thank you Alex so much for the tutorial.

[@cjbrown3396]

looking for more stuff man !

[@darshan2354]

Hey alex bro u r great

[@shima1960ify]

Hey Alex , can you make a video about the function ‘first value’ ? Including the combination of case when… will help a lot

[@lewisnicholasK]

Hello Alex, great video, I've learnt alot from you in the past year. The problem i experience with CTEs is they dont seem to be recognized by my ssms, what seems to be the issue

[@mercymbachu811]

Hello Alex, have really enjoyed watching your videos. Very detailed and well explanatory. Do you have anything on project management please? Or can you point me to one. I am struggling to find a great KZbin video on project mgt (bootcamps & certification) like yours. Thanks.

[@sabithsaqlain1367]

Hi @AlexTheAnalyst, truly appreciate your work is it a good idea to combine this and data cleaning project and show it as a single project in portfolio? awaiting your reply thanks

[@abhiroopsinghsandhu8843]

I'm currently enrolled in a business analytics diploma in a university, I want to know which of the skills used in data analytics can be carried over to business analytics field I love your content and would love to use it to learn stuff that can help me in my field.

[@user-tz5cq6vh5k]

Sir, could you please create a project on how to handle outliers in MySQL?

[@grootpro4351]

Sir I follow along with you at your sql studio project but when I import data so there was a lot of null values if you remember Covid 19 project so can you please make a video dedicated about sql management studio problems solving

[@rahulrajeev9763]

I'm getting exactly the double of the values as Alex gets. What will be the reason?

[@serenetonero]

can we use this in our portfolio or is there another way of creating one ourself

[@chinuambajekwe5802]

Hi Alex, Thank you for the video. Each time I try using the table Import Wizard, only about 500 rows of the data are imported. I have tried this multiple times with no difference. Please how can I resolve this?

[@evgenigentchev2623]

I attempted to do the Rolling_total using a window function but it doesn't seem to work. Is there any benefit to using CTE vs. window function?

[@anuboluwaji635]

Hey Alex, thank you for the info! I would like to talk to you about the data analyst boot camp. I saw that you removed the SQL videos that were in the boot camp series and replaced them with MySQL. For the past several weeks, I have been trying to work on the boot camp because I want to get your certification, and hiccups were trying to work on SQL because I was getting errors when I was trying to work on the SQL projects. Now, I am about to work and complete the SQL data cleaning project which was in the bootcamp series and the last thing to do for the SQL series, but I saw again that the SQL videos were gone. My question is can I still get the certification although you replaced the SQL videos with MySQL? By the way, I do not have MySQL. Thank you and God Bless!

[@SomeStatus]

check the playlists on his channel! Apparently just not on the bootcamp. Got this info from a comment below.

[@anuboluwaji635]

@@SomeStatus Hey thanks, so either SQL or MySQL should be good to get the certificate along with the other skills to learn?

[@SomeStatus]

@anuboluwaji635 oh geeze I now realize that's what you were asking not where the videos had gone 😭. That's a question for @alextheanalyst sorry.

[@mahra9984]

Hey Alex. I am currently in the bootcamp playlist and i just finished the OLD SQL videos a few days ago. But now i see you replaced the old SQL videos with MySQL. Which is better or what is the difference between the two? should i relearn the mySQL videos?

[@AlexTheAnalyst]

Hey I just updated it as people who were on Macs couldn't follow along. If you're already on the MSSQL ones that one is great! I would stick with it - the playlists are still on my channel just not in the bootcamp any more

[@mahra9984]

@@AlexTheAnalyst Awesome. Thank you Alex. You're the best!

[@spotthespots7731]

I want to learn Business analytics and data analytics . Please i need contact on hands on training.

[@ezehconfidenceadaeze6189]

I need someone to explain to me what exploratory data analysis means🙇🏽‍♀️ When writing a project I find it difficult to know what to write in the exploratory data analysis section.🙏🙏

[@MuhammadFazil-to5er]

Hi I am a commerce graduate intrested data analytics How to become a data analyst 🤝

[@Poojyadeals]

Hi alex i am u r subscriber i like to learn SQL send me video link link Sql for begineer to advanced

[@mahra9984]

Check this channel and check the data analyst bootcamp.