All projects
HR
Business problem
HR has data on headcount, leave and overtime, but rarely links it to production. That makes it hard to show what understaffing and turnover cost.
Questions the report answers
- How do headcount and turnover change by department and role?
- Where and when do absence and overtime rise?
- How does shift staffing affect production plan attainment?
Report
Interactive Power BI report. It loads when you click, so the page opens quickly.
The report runs on generated data with no personal data of real employees. Best viewed on a computer.
What the data shows
- [Finding 1]
- [Finding 2]
- [Finding 3]
Tools
- Power BI: one star schema shared by all four reports
- DAX: turnover, absence rate, overtime per FTE
- Power Query: preparing and cleaning source data