HR Data Analytics & Awesome Dashboard with Power BI πŸ’‘: End-to-End Project @chandoo_
HR Data Analytics & Awesome Dashboard with Power BI πŸ’‘: End-to-End Project  @chandoo_
Uploaded September 2023 | Updated November 2026, 3 hours ago
πŸ’₯ Want more? Join my full Power BI course: 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:
chandoo.org/wp/wp-content/uploads/2023/09/hr-data.xlsx

πŸ“ŠFinal Output:
app.powerbi.com/view?r=eyJrIjoiNDc2YzM2NDMtNGYyNy00ZjFmLWE5MGEtZjgwZTFkNjFhODdjIiwidCI6IjUzNTA4ZDUyLWQxYjAtNDliMC1iNGJhLTM1MzNjMTI0OWEwMSJ9

πŸ’₯Want more?
Join my full Power BI course:
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
chandoo.org/wp/power-bi-course

Getting started with Power BI in 10 minutes
youtu.be/9tF1IrfLflg

Learn Power Query in 15 minutes
youtu.be/UAFExySaSPY

Full Power BI Lesson
youtu.be/uwe8C7K8fXY

How to use DAX & Power Pivot
youtu.be/PQ5lALdFHCU

5 Tips to make better Card Visuals
youtu.be/7RKxD7andMQ

Excel vs. Power BI - Which is better?
youtu.be/nOWzpJ4gUKo

Data modeling and Star Schema in Power BI
youtu.be/1CgG0t59WcM

When and how to use various Power BI charts?
youtu.be/5jrsrSDEMxE

Power Query - Full Lesson
youtu.be/PiFAa_jjaEI

~

#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.
HR Data Analytics & Awesome Dashboard with Power BI πŸ’‘: End-to-End ProjectPower BI got a MAJOR upgrade - This changes everything!How to pick the perfect chart for your situation in Power BI?WRAPROWS in Excel - a must have functionPower BI Jargon Buster - 25 More Buzzwords explained in 15 minutesThis Excel Formula Shows Stock Prices Instantly!Complete Excel Tutorial for Data Analysis in 4 Hours (with FREE Files)COUNTIFS with Date Between - This is a must have formulaExcel VBA Macros - Beginner to PRO Masterclass with Code SamplesMake an AWESOME Employee Dashboard with Power BI (Adv. DAX)Second Week Sales Only with SUMIFS (Excel formula)Filled Column Charts in Excel - Amazing Dataviz Trick
Chandoo |

HR Data Analytics & Awesome Dashboard with Power BI πŸ’‘: End-to-End Project

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER