Page 1: Workforce Overview Headcount: | Total Employees: 7500 | Active Employees: 6009 | Former employees: 1491| Avg. Tenure (Years): 5 Insights: • The majority of the employees are in Store Operations department, followed by Logistics/Warehouse & Fresh Produce, while departments like customer Service & Marketing have less employees. • Age group: 25-34(~46.4%) – young and early-career workforce. • There is a significant spike in hiring in 2019, peaking in 2021, suggests strong expansion in recent years. Page 2: Attrition Overview Attrition Rate: ~20% Insights: • Employees having lower salaries have higher attrition rate, possibly due to more overtime hours. • Highest attrition rate in departments like HR, Logistics/Warehouse & Marketing, while largest department like Store Operations & Fresh Produce shows moderate attrition. • There is a sharp increase in attrition from 2018, peaking in 2021. • Former employee's satisfaction is lower than the active employees across all months. Page 3: Performance & Productivity Avg. Performance Rating: 3.7 Avg. Satisfaction Score: 7.2 Promotion Rate: 4.0% Avg. Productivity Index: 1.35 Insights: • Count of Performers: | High Performers: 2060 | Low Performers: 791 | • There is a balanced productivity across all departments but Store Operations (11.47%) & Customer Service (11.28%) have slightly high index. • Satisfaction over years remain between 7.0-7.5 with small fluctuations, while Performance remains flat across all months but it shows spikes in December 2022, 2023 and 2024.

Skills & Tools Used:

Share this Project: