Power BI DAX How To - Headcount & Turnover - HR Analytics
Trying to automate some of your HR reporting? In this video we'll walk through how to clean up and modify data in Power Query before creating several measures in Power BI for Headcount, Active Headcount including with point in time calculations and finally turnover percentages.
Interested in getting help with Power BI @ your company? Visit www.oneupinsights.com
0:00 (Intro)
0:20 (Power Query Data Cleaning)
2:02 (Adding Salary Bucket)
3:43 (Adding Employee Satisfaction Buckets)
5:35 (Inactive Calendar Relationships)
6:50 (DAX - Ct. Hires)
8:25 (DAX - Ct. Terms)
9:15 (DAX - Active Headcount)
13:00 (Line Chart w/ Headcount)
13:45 (DAX - Avg. Headcount)
14:41 (DAX - Turnover %)
15:06 (Analyzing Turnover %)
15:53 (Outro)