Navigate Select ESC Close

MySQL Exploratory Data Analysis | Full Project

2024-04-23 Education
169.7k
3.9k
178
Alex The Analyst
Alex The Analyst
1.4m subscribers

Unlock all features

FREE: Get instant access to 10 AI summaries, chats, or transcripts per day.

Description

Full MySQL Course: https://www.analystbuilder.com/courses/mysql-for-data-analytics 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: https://youtu.be/4UltKCnnnTA GitHub Code: https://github.com/AlexTheAnalyst/MySQL-YouTube-Series/blob/main/Portfolio%20Project%20-%20EDA.sql ____________________________________________ 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: https://coursera.pxf.io/5bBd62 📖Data Analysis with Python - https://coursera.pxf.io/BXY3Wy 📖IBM Data Analysis Specialization - https://coursera.pxf.io/AoYOdR 📖Tableau Data Visualization - https://coursera.pxf.io/MXYqaN Udemy Courses: 📖Python for Data Science - https://bit.ly/3Z4A5K6 📖Statistics for Data Science - https://bit.ly/37jqDbq 📖SQL for Data Analysts (SSMS) - https://bit.ly/3fkqEij 📖Tableau A-Z - http://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! https://www.youtube.com/channel/UC7cs8q-gJRlGwj4A8OmCmXg/join ____________________________________________ Websites: 💻Website: AlexTheAnalyst.com 💾GitHub: https://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*

Top Comments (10)

@fycp.9509 2024-11-27

I've just finished this tutorial about sql. As i said in the last videosn i've only one problem and it is not about Alex or the course but just about me cauz i'm a french guy so i learn all of these courses with substitles so it's so long but at the end i'm so proud and i want tot give a big thanks to ALEX. . Next stop --> excel. Ps: i write this comment without translator ^^^^

113 2 replies
@darkexcalibur87 2026-03-02

These ctes make my head spin 😵‍💫

10
@matchagrlie 2024-05-01

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! ♥

77 2 replies
@kylemair277 2024-08-18

I would kindly like to give some feedback. In this video there was not much emphasis given to the "precentage_laid_off". However, I find this to be statistically important data. This is a proportion and gives a probability. For example, if you were to query "SELECT stage, ROUND(AVG(percentage_laid_off),2) FROM layoffs_staging2 GROUP BY stage ORDER BY 2 DESC;" you would find the proportion of layoffs per company as opposed to just finding the companies that got rid of the most people. The argument here is that a large company with a layoff proportion of 0.05 could still show more people being laid off, then a smaller company with a layoff proportion of 0.7, even though this gives valuable insight that the past 3 years have hit small companies very hard. Thought I would mention this and open it up to any discussion.

64 5 replies
@Justin-tq3em 2025-07-12

We need more projects like this. Would love to see some real world projects that would be dealt with at a job. Something in supply chain or logistics would be great. Optimizing inventory or on time delivery analysis. This is something I am finding hard to locate a guided project on. Thanks

7
@omaralietiwie1848 2024-06-01

A big Thank Alex from Sudan . I wanted to take a moment to express my sincere gratitude for the incredible content you create on your YouTube channel. Your videos have been a source of inspiration, education, and entertainment for me, and I truly appreciate the effort you put into each one

14
@Egoist0791 2025-10-29

My mind is blowing after watching this

2
@RakibRony-d6k 2025-05-18

It was a lot for beginners but worth it.

2
@donnelly5757 2024-04-23

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

22
@aditya3david 2024-04-23

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

10

Unlock the Data Inside
Turn Videos into Knowledge

  • Get FREE 10/day: transcripts, summaries, chats
  • Chat with videos, export text & PDF
  • $1 free API credit for RAG, chatbots & research

Free forever plan • All features unlocked

App screenshot