1. Current employee demographics: Summarize the current employee demographics for the organization from the course scenario.

a. Use Tableau to visualize the demographic data such as age, sex, marital status, education, and experience, and include the corresponding screenshots in your summary. Choose the graphs or charts that are best suited to represent the demographic data.

b. Choose at least two different graph or chart types to represent the demographic data and include the corresponding screenshots in your written summary. Explain why you have selected the specific chart types to represent your data.

2. Attrition analysis: Analyze the given employee data to answer the following questions about attrition in the organization, including its causes and the relationship between attrition and various employment factors. Use Tableau to create a visual summary of the data and include the corresponding screenshots in your analysis. Choose the graphs or chart types that you believe are best suited to represent the required data.

a. Identify five top reasons for attrition.

b. For those who left the organization, how many years had it been since their last promotion?

c. At what age does an employee typically exit the organization?

d. After how many years of employment does someone typically leave the company?

e. What is the connection between how many times a year a person was trained, how long they stayed at the organization, and whether they have left?

3. Retention: Compare the attrition analysis data with your current employee details to evaluate and prevent future attrition.

a. Using the trends from the attrition data, determine if more current employees are likely to leave. Explain your findings.

b. What does your attrition analysis tell you about employee stability in the organization? How is it likely to affect your organization’s evaluation by a potential buyer?

4. Actionable steps: Based on findings from your retention analysis, provide three specific actions that the organization can take to prevent employees from leaving. Provide a rationale.

Sheet1

HR-Employee-Attrition-Data – Co


Leave a Reply

Your email address will not be published. Required fields are marked *

Age Gender JobSatisfaction MaritalStatus MonthlyIncome NumCompaniesWorked PercentSalaryHike PerformanceRating TotalWorkingYears TrainingTimesLastYear WorkLifeBalance YearsAtCompany YearsInCurrentRole YearsSinceLastPromotion
18 Male Sales Executive Very Satisfied Single 5993 8 11 3 8 0 1 6 4 0
18 Female Research Scientist Somewhat Satisfied Married 5130 1 23 4 10 3 3 10 7 1
18 Male Laboratory Technician Satisfied Single 2090 6 15 1 7 3 3 0 0 0
18 Male Research Scientist Satisfied Married 2909 1 11 3 8 3 3 8 7 3
18 Male Laboratory Technician Somewhat Satisfied Married 3468 9 12 3 6 3 3 2 2 2
18 Female Laboratory Technician Very Satisfied Single 3068 0 13 3 8 2 2 7 7 3
18 Female Laboratory Technician Unsatisfied Married 2670 4 20 1 12 3 2 1 0 0
18 Female Laboratory Technician Satisfied Divorced 2693 1 22 4 1 2 3 1 0 0
19 Male Manufacturing Director Satisfied Single 9526 0 21 4 10 2 3 9 7 1
19 Female Healthcare Representative Satisfied Married 5237 6 13 3 17 3 2 7 7 7 ERROR:#VALUE!
19 Female Laboratory Technician Somewhat Satisfied Married 2426 0 13 3 6 5 3 5 4 0
19 Male Laboratory Technician Satisfied Single 4193 0 12 3 10 3 3 9 5 0
19 Male Research Scientist Satisfied Divorced 2911 1 17 3 5 1 2 5 2 4
19 Male Laboratory Technician Very Satisfied Divorced 2661 0 11 3 3 2 3 2 2 1
19 Male Laboratory Technician Satisfied Single 2028 5 14 3 6 4 3 4 2 0
19 Female Manufacturing Director Unsatisfied Divorced 9980 1 11 3 10 1 3 10 9 8
19 Female Research Scientist Somewhat Satisfied Divorced 3298 0 12 3 7 5 2 6 2 0
20 Female Laboratory Technician Very Satisfied Divorced 2935 1 13 3 1 2 2 1 0 0
20 Female Manager Very Satisfied Married 15427 2 16 3 31 3 3 15 8 3
20 Male Research Scientist Very Satisfied Single 3944 5 11 2 6 3 3 3 2 1
20 Female Manufacturing Director Satisfied Divorced 4011 0 18 3 5 5 2 4 2 1
20 Male Sales Representative Unsatisfied Single 3407 7 23 4 10 4 3 5 3 0
20 Female Research Director Somewhat Satisfied Single 11994 0 11 1 13 4 3 12 6 2
20 Female Research Scientist Very Satisfied Single 1232 1 14 1 0 6 3 0 0 0
20 Male Research Scientist Unsatisfied Single 2960 2 11 3 8 2 3 4 2 1
20 Male Manager Satisfied Divorced 19094 4 11 3 26 3 2 14 13 4
20 Female Research Scientist Unsatisfied Single 3919 1 22 4 10 5 3 10 2 6
20 Male Sales Executive Somewhat Satisfied Married 6825 0 11 3 10 2 3 9 7 4
21 Male Healthcare Representative Very Satisfied Married 10248 3 14 3 24 4 3 22 6 5
21 Male Manager Unsatisfied Single 18947 3 12 3 22 2 2 2 2 2
21 Female Laboratory Technician Very Satisfied Single 2496 4 11 3 7 3 3 1 1 0
21 Male Healthcare Representative Very Satisfied Married 6465 2 13 3 9 5 4 4 2 1
21 Female Laboratory Technician Satisfied Single 2206 1 13 3 10 5 3 10 0 1
21 Male Sales Representative Very Satisfied Married 2086 3 14 3 19 6 4 1 0 0
21 Female Research Scientist Very Satisfied Married 2293 2 16 3 6 2 2 2 0 2
21 Female Research Scientist Satisfied Divorced 2645 1 12 3 6 3 2 5 3 1
21 Female Sales Representative Satisfied Married 2683 1 14 3 3 2 3 3 2 0
21 Female Sales Representative Very Satisfied Married 2014 1 13 3 2 3 3 2 2 2
21 Male Research Scientist Unsatisfied Married 3419 9 14 3 6 3 4 1 1 0
21 Male Sales Executive Unsatisfied Married 5376 2 19 3 10 3 3 5 3 1
21 Male Laboratory Technician Very Satisfied Divorced 1951 1 12 1 1 3 3 1 0 0
22 Male Laboratory Technician Unsatisfied Divorced 2341 1 13 3 1 6 3 1 0 0
22 Female Laboratory Technician Satisfied Single 2293 1 12 1 1 2 2 1 0 0
22 Male Sales Executive Satisfied Single 8726 1 15 3 9 0 3 9 8 1
22 Male Laboratory Technician Very Satisfied Single 4011 1 23 4 12 2 3 12 8 3
22 Male Research Director Satisfied Married 19545 1 12 3 23 0 3 22 15 15
22 Female Sales Executive Satisfied Single 4568 0 20 4 10 2 3 9 5 8
22 Male Research Scientist Somewhat Satisfied Married 3022 4 21 2 8 1 3 1 0 0
22 Male Sales Executive Very Satisfied Single 5772 4 21 4 14 4 3 9 6 0
22 Male Laboratory Technician Very Satisfied Married 2269 1 19 3 1