- About this project
Here's a detailed description of the key elements displayed in the dashboard:
1. Overview SectionActive 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 DistributionThis bar chart breaks down the number of employees by department. For example:Operations: 2,429 hired, 289 terminatedSales: 1,634 hiredCustomer Service: 1,489 hiredOther departments such as IT, Marketing, Finance, and HR are also represented.
3. Location DistributionA 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 SectionGender 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 DistributionThe 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 & PerformancePerformance ratings (Excellent, Good, Satisfactory, Needs Improvement) are mapped against education levels (High School, Bachelor, Master, PhD), showing how education correlates with performance.
7. Income SectionEducation & 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 DistributionThis 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.