Published On Apr 6, 2023
Get certified as a data analyst with DataCamp
https://datacamp.pxf.io/y2zPzG
Gather your own data for projects
https://www.scraperapi.com?fpr=irene88
💎Join my membership💎
https://herdataproject.gumroad.com/l/...
The dataset can be downloaded from
Gumroad - https://herdataproject.gumroad.com/l/...
OR
GitHub - https://github.com/Irene-arch/HR-Dash...
Do this project next - (PowerBI file included)
   • Video Â
💎Support my channel 💎
https://www.paypal.com/ncp/payment/AM...
Shop my merch here
- https://my-store-f72451.creator-sprin...
- https://her-data-project-shop.fourthw...
This is majorly a data cleaning and analysis in MySQL guided project and can also be done in PostgreSQL.
While doing this guided project you will learn how to do data cleaning and analysis in MySQL. You will learn how to convert dates, how to use subqueries and filters in your data to get correct outputs. The query results are saved as csv files to be used later on in creating a simple PowerBI dashboard.
00:00 Importing Data
02:10 Dataset walkthrough
05:05 Data Cleaning
27:21 Analysis
01:00:15 Visualization in PowerBI
01:22:48 Upload to Github
Comment below other projects you would like to see.
Get your own professional website built for free
https://bit.ly/freeprowebsite
SUBSCRIBE!!
LET'S CONNECT
Twitter :   / herdataproject Â
Instagram:   / herdataproject Â
Website:   / irenenafula Â
Some of the links on this channel are affiliate links, meaning that, at no additional cost to you, I will earn a commission if you click through and make a purchase. This helps support my channel and allows me to continue creating valuable content for you. I only recommend products or services that I personally use and believe will add value to you. Thank you for being so supportive!