Human Resources (HR) Report
Arsal Khan
Report on tableau
Here's a detailed description of the key elements displayed in the dashboard:
1. Overview Section
Active Employees (7,984): This shows the current number of employees working in the organization.
Hired vs. Terminated: The graph illustrates the total number of employees hired (8,950) and terminated (966) over time, giving insights into hiring and attrition trends.
2. Department-wise Employee Distribution
This bar chart breaks down the number of employees by department. For example:
Operations: 2,429 hired, 289 terminated
Sales: 1,634 hired
Customer Service: 1,489 hired
Other departments such as IT, Marketing, Finance, and HR are also represented.
3. Location Distribution
A map highlights employee distribution across various states (e.g., Michigan, New York, Pennsylvania, etc.), providing a geographical overview.
The comparison of HQ vs. Branch shows that 70% of employees work at the headquarters and 30% at branch locations.
4. Demographics Section
Gender Distribution:
Male (54%) and Female (46%) distribution is displayed with donut charts, giving a clear idea of gender representation across the workforce.
5. Education & Age Distribution
The chart displays the number of employees by education level and age group:
High School (H-scl), Bachelor, Master, and PhD qualifications.
Age groups such as 25-34, 35-44, 45-54, and 55+ are represented, with larger bubbles representing higher numbers of employees.
6. Education & Performance
Performance ratings (Excellent, Good, Satisfactory, Needs Improvement) are mapped against education levels (High School, Bachelor, Master, PhD), showing how education correlates with performance.
7. Income Section
Education & Gender:
Salary levels are segmented by gender and education:
High School graduates earn an average of 63K (females 61K, males 66K).
Bachelor’s graduates earn around 74K.
Master’s and PhD holders earn between 80K and 93K.
8. Age & Salary Distribution
This scatter plot shows how age correlates with salary across different job titles:
Job titles such as Finance Manager, IT Manager, Operations Manager, etc., are plotted.
The salary increases with age, especially for higher-level positions like Finance Manager (above 100K).
Summary:
This HR dashboard provides an insightful overview of employee demographics, department-wise headcount, gender distribution, education, performance, salary insights, and location distribution. It helps HR professionals track workforce diversity, understand hiring and attrition trends, and identify potential gaps or areas for improvement in employee retention and performance. The correlation between education, performance, and salary provides data-driven insights for workforce development.
It is an excellent example of leveraging Python for data preparation and Tableau for rich, interactive visualization.
Like this project
Posted Oct 29, 2024
Summary: This HR dashboard provides an insightful overview of employee demographics, department-wise headcount, gender distribution, education, performance, sal
