Home > Portfolio
The Brief
Arizona Engineering Services, a subsidiary of the Arizona Group of Companies, is struggling with employee retention. The rate of employee attrition is rising annually, and the cost of onboarding new employees is increasing.
Management needs insights into the employees who are leaving. This will help them identify the reasons for employee departures and develop employee-friendly policies and work environments to prevent further attrition.
The Human Resources Manager would like you to explore the employee attrition data and build a dashboard for the HR department that answers the following questions;
- What gender, age group, and education field is mostly affected by employee attrition?
- What is the average attrition age?
- Which departments have the most attrition?
- What is the count of attrition by job satisfaction?
- Predict employees likely to leave the company. see prediction model
Tools: TABLEAU
Process and Implementation
Data Exploration
- Data Definition: Table & Columns Definition (not included in the demo).
- Data: HR_Attrition.xlsx
Dashboard Planning
Dashboard planning is critical to delivering clear and valuable insights to stakeholders.
We would follow the steps below;
- Understand the needs, requirements, and goals of business users.
- Explore the data and prioritize the business needs.
- Define the purpose, audience, and consumption.
- Choose the right metrics.
- Choose the right charts, filters, colors, fonts, and icons.
- Develop a wireframe and mockup.
- Eliminate noise – anything that takes up space and doesn’t add value. For example, excessive colors, background images, grid lines, and 3d charts.
- Design layout to focus attention – use size and color to drive attention, group related elements, z or f reading pattern on chart importance.
- Use descriptive data labels to tell a story.
- Optimize for multiple devices.
Data Modeling and Transformation
One data source was used for the project. No table joins were performed.
Calculated fields created include;
- Active Employees
- Attrition Count
- Attrition Rate
- Attrition Age
2nd Brief: Green Destination Travel Agency
Green Destinations is an Arizona Group of Companies subsidiary and a well-known travel agency. The HR Director has recently noticed an increase in employee attrition and would like to identify any trends or patterns. She has surveyed the staff of Green Destinations and provided you with the data.
- She would like to know the attrition rate (% of people who have left).
- She would also like to know if factors like age, years at the company, and income play a part in
- determining if people will leave.
- She would like you to tell a story of the analysis using Tableau.
