Human Resources Analysis

Overview

You are a human resources analyst and your manager has several adhoc requests that you need to complete. The company has been concerned with various areas such as employee performance, potential pay disparities, attrition, and recruiting numbers.

Feel free to explore the data as you wish. If you have your own story you would like to tell, go for it. But, we have provided some questions to help guide your analysis. You don’t have to do them all.

Deliverables

You can analyze the data in any tool you like (Tableau, Power BI, python, R, Excel, etc.) But, your manager would like to see a dashboard. The dashboard will be used for monitoring performance. She would also like for you to generate a slide deck to present your analysis and recommendations to the VP of Human Resources of the company.

The slide deck can be done in Google Slides, PowerPoint, Canva, or any other tool. Be sure to save it as a PDF.

Questions

General Exploratory Data Analysis

1. What is the average age of employees in each department?
2. What is the median pay rate for each position?
3. How many employees are there in each department?
4. What is the distribution of gender across each department?
5. What is the average performance score for each department?
6. What is the breakdown of marital status among employees?
7. What is the distribution of employment source?
8. What is the distribution of race among employees?
9. How many employees are full-time vs part-time?
10. How many employees have a performance score above average?
11. What is the relationship between performance score and pay rate?
12. What is the performance score distribution across different races?
13. What is the relationship between age and performance score?
14. How does the number of days employed vary with the pay rate?
15. What is the gender distribution for each position?
16. How does the number of absences relate to the performance score?
17. What is the relationship between department size and performance score?

Hypothesis Testing

1. Is there a significant difference in the pay rates of males and females?
2. Is there a significant difference in the performance scores of different departments?
3. Are older employees more likely to leave the company?
4. Does pay rate influence the reasons for termination?

Correlation Analysis

1. What is the correlation between employee age and pay rate?
2. What is the average pay rate increase per year?
3. What is the relationship between the number of days employed and performance scores?
4. How does marital status affect performance score?
5. How does the number of special projects correlate with performance score?
6. What is the correlation between the number of special projects and the number of days employed?

Deep Dive Analysis

1. What is the turnover rate for each department?
2. How does pay rate vary by position and department?
3. What are the top 5 positions with the highest average pay rate?
4. What is the attrition rate among different positions? Is there any significance in the differences? Hint: what statistical test evaluates ratios among different groups?
5. What is the average age of employees who leave the company?
6. How many managers are there for each department?
7. What is the average pay rate for each employment source?
8. What is the attrition rate based on the employment source?
9. What is the distribution of reasons for termination?
10. How does employee satisfaction vary across departments?
11. What is the turnover rate for different positions? Is there any significance in the differences? Hint: what statistical test evaluates ratios among different groups?
12. What is the relationship between recruitment source and employee performance?
13. What is the effect of citizenship status on performance score?
14. What is the effect of citizenship status on pay rate?
15. Does the number of special projects have an effect on attrition rate?
16. What is the average pay rate based on citizenship status?
17. What is the average number of days employed for each performance score category?
18. What is the average number of special projects worked on in each department?
19. How does the length of employment vary with reasons for termination?
20. What is the average number of days employed for each performance score category?