HR Data Analytics & Awesome Dashboard with Power BI 💡: End-to-End Project

💥 Want more? Join my full Power BI course: https://chandoo.org/wp/power-bi-course/

~

Learn how to analyze HR (Human Resources) data and create stunning dashboards using Power BI with this complete masterclass. You are going to learn:

◈ Loading data into Power BI and cleaning it with Power Query
◈ Creating HR metrics like headcount, avg. leave balance, avg. salary etc. with Power Pivot
◈ Adding columns to the data (like Employee's first name, age group etc.)
◈ Finding relationships between salary and education qualification
◈ Using visual filters to see top / bottom paid staff in each job
◈ Customizing visuals in Power BI (changing colours, axis, labels and legend)
◈ Advanced DAX calculations like cumulative headcount, leave balance more than 20 days
◈ Designing a monthly HR dashboard with Power BI
◈ Working with "NEW" card visual in Power BI


📃 HR Data Analysis Themes:
========================

We are going to do these 10 things in the video. Use sample data to re-create the same.

1) How many people are in each job?
2) Gender break-down of the staff
3) Age spread of the staff
4) Which jobs pay more?
5) Top earners in each job
6) Qualification vs. Salary
7) Staff growth trend over time
8) Employee filter by starting letter
9) Leave balance analysis
10) Quick HR Dashboard


📁 Sample Dataset & Final Output:
============================

💿Sample Data:
https://chandoo.org/wp/wp-content/upl...

📊Final Output:
https://app.powerbi.com/view?r=eyJrIj...

💥Want more?
Join my full Power BI course:
https://chandoo.org/wp/power-bi-course/


⏱ Video Topics:
==============

0:00 - Introduction to HR Data Analysis with Power BI
0:50 - Loading HR data into Power BI and cleaning it
1:37 - How many people are in each job (Q1)
2:53 - Gender breakdown of the staff (Q2)
3:57 - Age spread of the staff - with histograms (Q3)
5:26 - Using Small Multiples to enhance your charts
6:11 - Which jobs pay more (Q4)
8:32 - Top earners in each job (Q5)
10:26 - Quick homework break...
11:11 - Qualification vs. Salary (Q6)
12:50 - Turning Qualification into number column
15:51 - Staff growth trend over time with DAX (Q7)
19:10 - Employee filter by first letter (Q8)
20:23 - Adding conditional formatting bars to Power BI tables
21:36 - Leave balance analysis (Q9)
23:55 - HR Dashboard using Power BI (Q10)
27:00 - Closing remarks and next steps


💡 MORE POWER BI VIDEOS
=======================


FULL Power BI, Power Query, Power Pivot Course
https://chandoo.org/wp/power-bi-course/

Getting started with Power BI in 10 minutes
   • Your first 10 minutes of Power BI - A...  

Learn Power Query in 15 minutes
   • Learn Power Query & Automate Boring D...  

Full Power BI Lesson
   • Beginner to PRO Data Analysis with Po...  

How to use DAX & Power Pivot
   • Learn Power Pivot & DAX for Power BI ...  

5 Tips to make better Card Visuals
   • 5 Power BI Card Tricks *not* many kno...  

Excel vs. Power BI - Which is better?
   • Excel vs. Power BI - What is the BEST...  

Data modeling and Star Schema in Power BI
   • How to setup a Star Schema Data Model...  

When and how to use various Power BI charts?
   • How to pick the "perfect" chart for y...  

Power Query - Full Lesson
   • Power Query Tutorial - What is it, ho...  

~

#powerbi #humanresources #HRDataAnalytics

~

I have a hilarious HR joke.
To hear it, you must make 3 copies of this form, sign it at the 16 marked places, get it notarized by a talking giraffe and bring it back before 4PM. Oh, you also need to stand on one leg while doing it.