SQL & PowerBI Portfolio Project for Data Analysts
Her Data Project Her Data Project
7.04K subscribers
132,757 views
4.3K

 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!

show more

Share/Embed