💥 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/uploads/2023/09/hr-data.xlsx 📊Final Output: https://app.powerbi.com/view?r=eyJrIjoiNDc2YzM2NDMtNGYyNy00ZjFmLWE5MGEtZjgwZTFkNjFhODdjIiwidCI6IjUzNTA4ZDUyLWQxYjAtNDliMC1iNGJhLTM1MzNjMTI0OWEwMSJ9 💥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 https://youtu.be/9tF1IrfLflg Learn Power Query in 15 minutes https://youtu.be/UAFExySaSPY Full Power BI Lesson https://youtu.be/uwe8C7K8fXY How to use DAX & Power Pivot https://youtu.be/PQ5lALdFHCU 5 Tips to make better Card Visuals https://youtu.be/7RKxD7andMQ Excel vs. Power BI - Which is better? https://youtu.be/nOWzpJ4gUKo Data modeling and Star Schema in Power BI https://youtu.be/1CgG0t59WcM When and how to use various Power BI charts? https://youtu.be/5jrsrSDEMxE Power Query - Full Lesson https://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.