HR Attrition & Employee Turnover Dashboard

Project Title: Employee Turnover Analysis & Interactive Dashboard

Problem Solved: Processed, cleaned, and transformed fragmented and inconsistent HR turnover datasets spanning multiple departments. Standardized schema formatting, handled missing values, resolved duplicate records, and built a normalized data model using Python and SQL to establish a single source of truth for HR analytics.

Key Insights: Uncovered critical attrition patterns, revealing that employee turnover peaked within the first 6 to 12 months of tenure. Identified key operational bottlenecks and high-risk departments where compensation gaps, lack of onboarding structure, and high workload intensity directly correlated with exit rates.

Decision Making & Impact: Translated raw analysis into strategic recommendations for HR executive leadership. Guided the implementation of early-tenure onboarding check-ins, workload rebalancing, and department-specific retention plans, helping lower turnover rates and cut recruitment replacement costs.

Tools Used: Python (Pandas, NumPy), SQL, Power BI (DAX, Interactive Dashboards),