Created Interactive Dashboard & Analyzed core underlying causes of poor employee performance
Mr Brain, CEO of the INX Future Inc data analytics and automation solutions provider wants us to create an interactive dashboard to analyse the employee performance indexes and track the core underlying causes of their performance issues (clear indicators of non-performing employees).
- Does educational level responsible for the attrition of employees?
- Which age group of employees has the maximum attrition?
- Are the employees unsatisfied with the specific job role?
- Which top 5 job role indicates the maximum attrition of employees?
- Does a highly experienced person responsible for leaving the company?
- How does the % salary hike play a crucial role in the increase in attrition of the employee?
- Built an interactive dashboard to track and analyse employee performance based on attrition and various job roles.
- Used complex parameters to drill down in worksheets and customization using filters and slicers.
- Created connections, join new columns, and enable user-driven parameters for visualizations.
- Used different types of customized visualization (bar chart, pie chart, donut chart, clustered bar chart, map, slicers, tables, etc).
- Out of the 1200 employees, 178 of them going to leave INX Future Inc data analytics company (indicating a 15% attrition rate).
- The employees with educational backgrounds in the field of Life Sciences (37%), Medical (25%) and Marketing (17%), indicating high attrition.
- The maximum number of employees between 26 - 35 age, depicts high attrition (90 employees).
- The employees from the job role of sales executive (44), developer (40), sales representative (24), research scientist (13) and manager R&D (12) show high attrition.
- The 46 employees after gaing two years of work experience they leave the company.
- The low salary hike % of employees (between 10% - 15%) indicates the high attrition rate.
Based on educational background and job roles, the major cause of employee performance issues is job satisfaction and salary hike percentage. Especially, young employees between 26 - 35 age group in the job role of Sales Executive, Developer and others. Therefore, Mr Brain, CEO of INX Future Inc should raise the salary hike percentage (increase to more than 15%) of young employees (between 26 - 35 age) who have at least two years of working experience at the company.