Report on tableau

https://public.tableau.com/app/profile/arsal.khan4247/viz/hrdashboard_17296829099430/HRDashboard

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

Likes

Views