Employee Performance Analysis Project

Transforming 7,500 Employee Records into Strategic Insights | Employees Analytics Project

I built this project to demonstrate how HR data can directly influence business performance — bridging the gap between people metrics and bottom-line results.

Using Python for Exploratory Data Analysis (EDA) and Power BI for interactive visualization, I transformed raw data from 7,500 employees across 150 stores into a proactive decision-making solution.

? Strategic Insights Delivered

? Workforce Health

- 6,010 active employees

- Productivity Index: 1.35

- Average Performance Rating: 3.70 / 5

? Retention Intelligence

- Identified high-turnover risk zones in Store Operations & Logistics

- Enabled targeted, data-driven retention strategies

? Training ROI

- Employees with 20–30 training hours consistently rank as top performers

- Demonstrated measurable impact of employee development

? Financial Alignment

- Actual Sales: $122.19K

- Target Sales: $122.12K

- Clear alignment between workforce productivity and revenue goals

? Demographic Analysis

- Performance remains stable and balanced across all age groups (21–64)

? Key Operational Metrics

✅ 93.98% On-Time Delivery Rate

✅ 2.84% Average Waste Reduction

✅ 7.54 / 10 Employee Satisfaction Score

✅ $27.25K Average Annual Salary optimized across job levels

? Project Vision

Moving from reactive HR reporting to Proactive People Operations

— empowering leaders to:

Invest strategically in employee development

Reward high-impact leadership

Reduce turnover risk

Strengthen operational efficiency