In this project, you will use the provided HR dataset to create visualizations for key HR metrics. Visualizations are an effective way to present data and gain insights. You are tasked with preparing the data, selecting five analysis areas from the list provided and creating visual representations of these metrics.
Step 1: Understand and Prepare the Data
Prepare the data. Explain, in detail, how you prepared (e.g. cleaned) the data.
Step 2: Basic Metrics
Calculate the following:
- Headcount per department
- Age demographics
- Gender diversity
- Seniority distribution
Step 3: Analytics and Interpretation
Choose five (5) analysis areas from the list below to examine further and provide insights into the data. In your insights, be sure to answer the following four (4) questions.
- How did you perform the calculations?
- Why did you choose the formulas you did?
- Remember to consider pivot tables and/or statistical analysis options in your calculations (examples such as t-tests or ANOVA)
- What did your analysis tell you?
- What recommendations could you give the department managers and/or executives based on your results?
- This means completely understanding both the calculation you have chosen, why you chose it, and what the results mean to both the dataset as well as the organization.
- What assumptions did you make when you were calculating the results?
- Examples include those found in CLO3.
- What missing information might help you to provide further analysis and/or more accurate results?
ANALYSIS AREAS
- Compensation by Family Status and Dependents
- Compare average compensation (salary, bonus, allowances) between employees with and without dependents
- Analyze how family status influences compensation
- Leave and time-off analysis
- Calculate the total “Paid Time Off (hours accrued)” for relevant employees
- Analyze leave patterns based on job titles, seniority, or dependents
- Vacation accrual
- Calculate the total vacation days accrued
- Compare vacation accrual across departments and/or locations
- Performance Correlation
- Calculate the correlation between “Performance Rating” and Salary, Location and Department
- Determine if higher performance ratings are associated with higher compensation, the location and/or department
- Analyze the proportion of employees in different performance rating ranges
- Training and Development Analysis
- Calculate the total training allowance allocated to different categories of employees
- Analyze the relationship between training allowance and performance ratings
- Calculate the total training allowance allocated to different categories of employees
- Identify departments or locations where compensation or other factors stand out
- Sick Days Analysis
- Assess the sick days taken by employees to identify potential health or work-related issues
- Recruitment Channel Effectiveness
- Analyze the source of hire data to determine which recruitment channels are the most effective in attracting TOP talent.
- Location-based Analysis
- Compare location-based information to other factors (eg. Compensation, turnover, employee satisfaction, performance ratings).
Step 4: Create Visuals
For each of your analysis areas chosen, choose a visualization type that you feel best represents the chosen metric. You can use bar charts, pie charts, line graphs, scatter plots, or even a heat map.
Annotate your visualization. Provide a brief explanation and/or label to help readers understand the insights conveyed by your visualization. This should be a minimum of 300 words per visualization.
Step 5: Executive Summary
Write a short executive summary showcasing your visualizations (average 1-3 pages).
Explain the significance of each metric, describe the trends or patterns you observe, and discuss any insights gained from the data.
Project Notes:
Students will work in small groups (maximum of five people in a group).
Note: If a team member is not contributing to the team, they may be removed from the team. This person will be solely responsible for the entire project. Please contact me by October 31, 2023 if there is an issue. All changes must be completed by November 4th, 2023. This deadline allows the individual enough time to complete the project on their own. Any issue that may arise after this date will be addressed on a case-by-case basis.
General Report Formatting:
- Written in Arial 11, with student name and ID clearly written on the cover page
In today’s world, the use of AI Assistants is common. If you do use one, please ensure that it has been recognized in the bibliography and the prompt(s) used is included.
Please be aware that AI assistants are still susceptible to “hallucinations” and are there to answer all of your questions – even if incorrectly answered. You MUST include a reliable resource as a back-up to information they provide you.