BUSINESS UNDERSTANDING

Emerald Technologies is a multinational mobile telecommunications company operating in many African and Asian countries. As of December 2022, the company recorded 1 billion subscribers, making it the 3rd largest mobile network operator in the world, and the largest in Africa/Asia. They currently have in-house issues, and they need an experienced Data Scientist to help.

PROBLEM STATEMENT

Emerald Technologies is facing challenges related to employee attrition and performance management. There is a pressing need to better understand the factors contributing to employee turnover, to ensure that their promotion policies are fair and effective, and to optimize training programs to enhance employee performance and satisfaction

RATIONALE FOR THE PROJECT

It is crucial to understand diversity and inclusion within the organization and the demographic and job-related factors that contribute to attrition. Furthermore, ensuring that employees with lower performance ratings are provided with targeted training and development opportunities to improve their skills and overall performance. This will be achieved by analysing the employee demographics, attrition rate and employee performance.

DATA UNDERSTANDING

The database contains the following Tables with numerous columns:

• Employee_perf: This table holds information relevant to employee performance and compensation alongside attrition data.
• Employee_test: This table holds the demographic and training Information on each employee.

PROCESS WORKFLOW

First, restore the database and retrieve the necessary information as discussed by the team lead. Next is to come up with an analysis approach and perform descriptive and diagnostic analyses. Finally, summarize findings and insights.

KEY INSIGHTS

• Emerald Tech Company has 1,470 employees, and the maximum length of service is 31 years.
• The company has nine departments, Sales & Marketing has the highest number of employees with 446 staff while R&D has the least employees with 29 staff.
• 1,069 employees are male and 401 are female.
• Most of the employees are young people; 388 are 20-29 years old.
• All the nine departments have similar ratings for the previous year: 3.7 highest, 3.1 lowest.
• The company's average attrition rate is 16.1%. The regions with the highest attrition are region_2 with 46, region_22 with 24, and region_7 & 26 with 16 attritions respectively.
• The department with the highest average job satisfaction is HR with 2.91.
• The top three regions with satisfaction rates are region_3, region_30 and region_24 with average satisfaction rates of 3.25, 3.14 and 2.90 respectively.
• Sales and Marketing department has the highest attrition (departures) with 73 attritions, this is followed by the Operations and Technology department with 55 and 37 attritions respectively. Note: for detailed analysis please see the SQL Query

SUMMARY

Most employees at Emerald Tech are male which might raise the question of inclusion and diversity. Hence, the company should encourage more female applicants during recruitment. The 16% attrition rate is not encouraging for a company because the acceptable attrition rate in the industry is 10% or lower. There is no data on the reasons for attrition, hence it's prudent for the company to perform exit interviews or research. This will provide more insights into attritions and help in reducing the attrition rate. There is a need to direct the promotion policies to those regions with the worst attrition rate.