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

~

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:

📊Final Output:

💥Want more?
Join my full 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

Getting started with Power BI in 10 minutes

Learn Power Query in 15 minutes

Full Power BI Lesson

How to use DAX & Power Pivot

5 Tips to make better Card Visuals

Excel vs. Power BI - Which is better?

Data modeling and Star Schema in Power BI

When and how to use various Power BI charts?

Power Query - Full Lesson

~

#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.

[jeet_]

I sat down the whole video and implemented each and every step you did and I would really recommend others to do so. Thankyou sir.

[Softweb-cibf]

this is my first daskbord in power bi, thanks chandoo sir, 🥰🥰

[carstenjrgensen]

Thank you very much for some good videos about Power BI.
I still have some difficulties with calculating in Power BI. What do I use if I have a table consisting of work hours that people have registrered on projects and a table consisting of estimates of how many hours we estimated they will use and I want to compare the two? Also all the hours that have been registered is in single lines how can I sum all the hours employee A have registered on project A, B and so forth?

[SheikImranMohamedAribu]

Ananya Agarwal, Dev Agarwal and Dev Joshi is the bottom 3 Chandoo. I just changed the option from "Top" to "Bottom" in the filter by "Top N" options.

[Seftehandle]

Extremely useful! Thumbs up all the way! Easy to follow along, great length to not give up! Thanks!
I liked how each Q/chart in a separate sheet - gonna start using that in xl.

[timcurrie]

Question,
I would like to know how to use cell reference in a way that I can build a config for Cisco switches. I have interface that I would like to build and copy into the running config. I have the interface in column A and going down in rows. But some the cell I reference go across the columns. Switchport mode access and spanning tree portfast…..

When copy a section and paste it low the cell jumper up in number in relation to the amount I jumped down.

[janinegarber]

How do you integrate with the HRIS to see an up to date dashboard as well as history?

[akshitdadheech]

Bottom Three Are:

1. Anaya Agarwal - $51, 100
2. Dev Agarwal - $51, 000
3. Dev Joshi - $51, 100
4. Dev Joshi - $51, 100

Amazing detailed videos Chandu Thanks for helping us out.

[toughmanful]

Extremely knowledgeable Chandoo for people starting out in Power BI. Thanks a ton!!! Implemented every step, it took like 1.5 hr.

[lalithadunna]

It was great learning with you. thank you so much. Can you make a video about the power bi data analyst versus power bi developer?

[truewiking]

I have recently started using power bi and I really like the Way you explain things. I`ve learned a lot, Thank you very much for this one

[mahaabukaraki]

Many thanks for the amazing videos! how we can use the dashboard for multiple choices in one question please.

[RobertHorvat]

Hey friend what software program do you use to record what you do on PC screen and also to talk to and also save in video format ?

[tamunamchedlishvili]

Great job!!!This dashboard is only for those employees who started and are still working in the company. And those co-workers who worked and left the company, how to include them? Staff growth trend over time to be correct.

[Aadil.Xplorer]

Thank you for the video, I felt good learning while watching and implementing the same.

[benarointegrity]

Thank you and keep it up. I like it even more when we get different domain dataset and you walk through with us.

[rickyyashi]

Wonderful video. Just started following you for over a month now and your videos are really helpful...thank you for the wonderful videos.

[a-ankushbhandari]

I chandoo sir, I would like to ask you a question that while creating a headCount=countrows(staff) there is no name with the staff in data table so how we got the headcount?.... please reply

[jamanemon]

This kind of videos are not available even in the paid courses. Thank you so much Chandoo for your amazing and insightful videos. As a teacher you are really amazing. Lots of love❤️

[JudiantoTjahjoNugroho]

Is it true that if we had thousands list of data, using excel would be facing difficulties?