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.
