Summary

This Power BI workforce dashboard provides a clear view of employee demographics, retention, compensation, performance, and productivity from 2015 to 2023. It helps HR teams monitor workforce trends, compare employee groups, and identify areas that may require further attention.

The report was created by Eszter Kovacs for the FP20 Analytics ZoomCharts Challenge 15 using the HR Analysis dataset.

Key Insights of the Power BI Workforce Dashboard

The report combines workforce demographics, salary analysis, and employee performance views. Its key insights include:

• Workforce overview: total, active, and resigned employees, retention rate, and average salary
• Employee demographics: active employees by gender and age group
• Salary analysis: salary distribution by education and department, with average salary comparisons across job titles
• Retention trends: changes in active and resigned employee numbers over time, including positions with the highest resignation rates
• Performance and productivity: employee satisfaction, performance scores, training activity, overtime hours, and projects handled
• Workforce planning: promotions, sick leave, and overtime patterns by gender and job title

Interactive Power BI visuals make it easy to compare departments, roles, demographic groups, and reporting periods. These views can help HR teams recognize workforce patterns, investigate retention risks, and support decisions about compensation, training, workload, and employee development.

How to Use This Power BI Workforce Dashboard

Use the year, department, and education-level filters to focus the analysis on specific workforce segments. Click active chart elements to filter related visuals, compare employee groups, and drill down into more detailed time-based data.

Navigate between the workforce demographics, salary, performance, and productivity views to explore the report from different perspectives. Download the .pbix file to review its settings, formulas, and calculations or adapt the dashboard to your own HR data.