👨‍💼 Employee Performance Analysis

HR Analytics using SQL, Python, Power BI & Statistical Methods

📂 Project Files

📊 Key Metrics

Total Employees

17,415

KPI Achieved

36%

KPI Not Achieved

64%

Award Rate

2.3%

Only ~36% of employees meet KPI targets, highlighting significant improvement opportunities.

🔍 Key Insights

Previous year rating is the strongest predictor of performance
Referral recruitment produces higher-performing employees (~43%)
Training quality improves KPI, while excessive training reduces efficiency
Department significantly impacts KPI performance
Performance declines with tenure, indicating engagement issues

📊 Statistical Analysis

Chi-square test confirms strong relationships between Department, Recruitment, and KPI (p < 0.001)
ANOVA shows Previous Rating is the most influential variable
Training score and experience significantly impact performance

💡 Business Impact

Employee performance is driven more by job-related factors than demographics. Improving recruitment strategy, training effectiveness, and employee engagement is key to boosting performance.

🚀 Recommendations

Prioritize referral hiring to improve workforce quality
Focus on training effectiveness instead of quantity
Implement continuous performance evaluation systems
Improve engagement for long-tenured employees

📊 Power BI Dashboard

📥 Download Power BI File (.pbix)

⚠️ Open using Power BI Desktop