HR Analytics Dashboard in Power BI

1. Project Overview

This dashboard provides insights into key HR metrics, such as attrition, employee satisfaction, salary distribution, and career growth, to support data-driven decisions.

2. Data Preparation

-Data source : Multiple datasets, including employee demographics, performance reviews, and satisfaction surveys.

-Data Cleaning: Ensured consistency, removed duplicates, and handled missing values.

-Transformation: Created calculated fields using Dax, grouped data by departments and roles, and implemented time-based filters for dynamic reporting. Established relationships between multiple tables for seamless data integration and analysis.

3. Key Insights:

-Attrition: 16% overall, with younger employees and the Technology department showing the highest rates

-Salary: Competitive pay, but gaps in entry-level roles need review

-Career growth: Promotion rate at 15.2%, with average tenure under current managers at 2.6 years

-Satisfaction: Training programs lead to satisfaction improvements, but work-life balance remains a concern

4-Recommendations:

-Focus on retaining younger employees and high-turnover departments with targeted initiatives.

-Regularly review salary structures for fairness and competitiveness.

-Expand training programs and strengthen manager-employee relationships.