MySQL Exploratory Data Analysis | Full Project

Показать описание

In this lesson we are going to be building an Exploratory Data Analysis project in MySQL!

____________________________________________

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:

Udemy Courses:

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

____________________________________________

Websites:
📱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*

Рекомендации по теме

Комментарии

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

matchagrlie

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

donnelly

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

omaralietiwie

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

adityadavid

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.

gilbertspark

Alex you are impressive! the way you teach the data analytics is unbelievable & outstanding!

MuhammadHassanAbid-kx

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

rakeshbasak

Excellent Project ! I Learned a lot from this project ! Thank you Alex .

mbhupal

I feel addiction towards learning because of your videos
You are adorable 👏
Thanks a ton❤

khadijashaikh

Amazing session, I have personally learnt a lot.

donrowam

good alex, watching all the way from africa

mugomuiruri

Awesome video. Next up is visualizing the data 🙌

ernestowolabi

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

MultiSpaccatutto

thank you so much, this last query was challenging, but you are such a good teacher, thank you again

adwaamohamed

THANK YOU MR ALEX, YOU ARE A BLESSING

shobolabenjamin

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.

kylemair

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

rogue

You are am amazing teacher thank you I am having such a fun time

checkYourDiet

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

shimaify

thank you Alex so much for the tutorial.

cjbrown

MySQL Exploratory Data Analysis | Full Project

MySQL Exploratory Data Analysis | Full Project

Data Cleaning in MySQL | Full Project

5. Exploratory Data Analysis (EDA) : Univariate, Bivariate and Multivariate Using MySQL and EXCEL

Walmart Sales Data Analysis With MySQL | MySQL Protfolio Project

SQL Databases with Pandas and Python - A Complete Guide

Triggers and Events in MySQL | Advanced MySQL Series

MySQL Exploratory Data Analysis | Full Project

1. Data Analytics Using MySQL | MySQL (Case Study - 1) | Kaggle Dataset (SF Salary)

Data Analyst Portfolio Project | SQL Data Exploration | Project 1/4

Learn SQL for Data Analysis with MySQL Workbench

Exploratory Data Analysis in Python and MySQL

Data Analyst Portfolio Project - SQL | Step-by-Step Guide From SQL Database to Interactive Dashboard

Python Project for Data Analysis- Exploratory Data Analysis | Data Analyst Project

I learned SQL for data analytics in 15 days | From Scratch

Data Analyst Portfolio Project for beginners Part-1 (SQL)-EDA

Data Analyst Portfolio Project #1 | Build a Database | Develop SQL | Create a Dashboard

How I use SQL as a Data Analyst

Exploratory Data Analysis Project - Spotify Dataset Analysis

Data Analyst Portfolio Project (Exploratory Data Analysis With Python Pandas)

How much does an IT Analyst make?

Data Analysis SQL Project | Complete SQL project | Airlines Data Analysis using SQL and Python

Installing MySQL and Creating Databases | MySQL for Beginners

Exploratory Data Analysis In Python | Exploratory Data Analysis Project In Python | Simplilearn

Data Analyst Bootcamp for Beginners (SQL, Tableau, Power BI, Python, Excel, Pandas, Projects, more)