INSIGHTS
Attrition by Age Group:
The highest attrition is among employees aged 26-35, with 116 employees leaving, while attrition decreases with age, reaching the lowest in the 55+ group with only 8.
Attrition by Job Role:
Laboratory Technicians (62) and Sales Executives (58) experience the highest attrition. Managers (5) and Research Directors (2) have the lowest attrition, suggesting stability in these roles.
Attrition by Education:
Employees in the Medical field have the highest attrition rate at 37%, followed by Life Sciences at 26%. Technical degree holders show the lowest attrition at 5%.
Attrition by Salary Slab:
The highest attrition occurs in employees earning up to 5k, with 163 employees leaving, while the lowest attrition is seen among those earning 15k+ with just 5 employees.
Attrition by Gender:
Male employees have a higher attrition count at 141, compared to females at 79.
Attrition by Tenure:
Employees with fewer than 5 years at the company, especially those with 1-2 years (59 employees), show higher attrition, which decreases as tenure increases.
Company Averages:
The average employee age is 37, the average salary is 6.5k, and the average tenure is 7 years, suggesting a moderate level of employee retention.
Overall, attrition tends to be higher among younger, lower-paid, and less-tenured employees.
Attrition by Age Group:
The highest attrition is among employees aged 26-35, with 116 employees leaving, while attrition decreases with age, reaching the lowest in the 55+ group with only 8.
Attrition by Job Role:
Laboratory Technicians (62) and Sales Executives (58) experience the highest attrition. Managers (5) and Research Directors (2) have the lowest attrition, suggesting stability in these roles.
Attrition by Education:
Employees in the Medical field have the highest attrition rate at 37%, followed by Life Sciences at 26%. Technical degree holders show the lowest attrition at 5%.
Attrition by Salary Slab:
The highest attrition occurs in employees earning up to 5k, with 163 employees leaving, while the lowest attrition is seen among those earning 15k+ with just 5 employees.
Attrition by Gender:
Male employees have a higher attrition count at 141, compared to females at 79.
Attrition by Tenure:
Employees with fewer than 5 years at the company, especially those with 1-2 years (59 employees), show higher attrition, which decreases as tenure increases.
Company Averages:
The average employee age is 37, the average salary is 6.5k, and the average tenure is 7 years, suggesting a moderate level of employee retention.
Overall, attrition tends to be higher among younger, lower-paid, and less-tenured employees.
Sales by Categoy:
The top-performing categories are Office Supplies, Technology, and Furniture, with Office Supplies leading the sales volume.
Sales by Sub-Category:
Phones, Chairs, and Binders are the top sub-categories, highlighting potential areas for focused sales strategies or inventory adjustments.
Shipping Mode Preference:
Standard Class is the most popular shipping option, followed by Second and First Class. Same-day shipping is the least used, possibly due to higher costs or limited availability.
Monthly Sales and Profit Trends:
Sales and profits vary seasonally across 2019 and 2020, with some months showing higher performance. This data helps identify peak sales periods.
Customer Segment Sales Distribution:
Consumer segments represent the largest sales share (48%), followed by Corporate (33%) and Home Office (19%). This breakdown can guide targeted marketing initiatives.
Payment Mode Breakdown:
Cash on Delivery (COD) is the most common payment mode, followed by online and card payments. This could reflect customer trust in COD or regional payment preferences.
Regional Sales Performance:
The West region leads in sales, followed by the East, South, and Central regions. This insight can aid regional-focused strategies to maximize revenue.
Sales Forecast:
Projected sales for November 2020 through January 2021 provide estimates for future planning and inventory stocking.
