Human Resources Analytics Dashboard

HR Analytics Dashboard: A Strategic Overview of the Workforce

1. Problem Statement / Objective

The primary objective of this project was to develop a comprehensive and interactive dashboard to provide the Human Resources department with critical insights into the company's workforce. The goal was to move from static, manual reports to a dynamic tool that could answer key strategic questions:

• What is the current composition of our workforce in terms of demographics (gender, age, education)?
• How are employees distributed across different departments and locations?
• What are the key trends in hiring and termination?
• Is there a correlation between employee performance, age, and salary?
• How can we identify high-turnover departments to implement targeted retention strategies?

2. Data Source(s)

• Source:This HR Dashboard uses a dataset generated using ChatGPT & Faker library.
• Size/Scope: The dataset contained over 8,000 records, with columns for Employee ID, Full Name, Gender, Age, Education Level, Department, Job Title, Hire Date, Termination Date, Salary, Location, and Performance Rating.

3. Methodology & Tools

• Tools Used: Microsoft Excel, Tableau.
• Key Features Utilized:
  • Calculated Fields: Created key performance indicators (KPIs) like 'Active Employees', 'Hired', 'Terminated', and 'Turnover Rate'.
  • Interactive Filters: Implemented slicers and filters for Gender, Location, Status, and Year, allowing for dynamic data exploration.
  • Dashboard Design: Assembled two main views: an 'Overview' dashboard for high-level metrics and a 'Details' page for granular employee-level data.
  • Visualizations:
    • KPI Cards: To display headline figures like 'Active Employees' (7,984), 'Hired' (8,950), and 'Terminated' (966).
    • Donut & Bar Charts: To visualize distributions for 'Gender', 'Departments', and 'Education & Age'.
    • Scatter Plot: To analyze the relationship between 'Age vs Salary', segmented by job role.
    • Geographic Map: To show the distribution of employees by state.
    • Data Table: A detailed, filterable table view of all employees.

4. Key Findings & Insights

• Workforce Composition: The company has 7,984 active employees, with a gender distribution of 54% male and 46% female. The largest age groups are 25-34 and 35-44, indicating a mature but vibrant workforce.
• Departmental Dominance: The 'Operations' department is the largest by a significant margin (2,629 employees), followed by 'Sales' (1,634) and 'Customer Service' (1,489). This highlights the core operational focus of the business.
• High Turnover in Operations: While Operations is the largest department, it also has the highest number of terminations (289), suggesting a potential retention issue that needs further investigation.
• Compensation Structure: The 'Age vs Salary' scatter plot clearly shows a positive correlation: salary tends to increase with age, which typically correlates with experience. Financial Managers and IT Managers are among the highest earners.
• Educational Impact on Income: The 'Income' section reveals that employees with Master's and PhD degrees have a higher average salary, with a noticeable pay gap between genders at the Master's level.
• Centralized Workforce: A large majority of employees (70%) are based at the HQ, with the remaining 30% in branch offices.

5. Recommendations

Although this is a mockup dataset,Based on the key findings, the following actions are recommended to improve talent management, enhance employee retention, and ensure equitable practices:

• Address High Turnover in Operations: Given that the Operations department has the highest number of terminations, it is critical to conduct a deep-dive analysis.
  • Implement targeted employee satisfaction surveys and hold focus groups within the department to understand sentiment and morale.
  • Analyze exit interview data specifically for this department to identify common reasons for leaving (e.g., workload, management, career growth).
  • Develop a tailored retention plan for Operations based on these findings.
• Conduct a Pay Equity Audit: The identified pay gap between genders at the Master's degree level requires immediate attention. A formal pay equity audit should be conducted to identify and rectify any unjustified disparities, ensuring compliance with fair compensation practices and bolstering the company's commitment to diversity and inclusion.
• Develop Career Pathing and Leadership Programs: With a significant portion of the workforce in the 25-44 age bracket, the company should invest in clear career development paths and leadership training programs. This will help retain experienced employees and build a strong pipeline of future leaders from within.
• Review Workforce Centralization Strategy: While having 70% of employees at HQ may foster a strong culture, it could also limit the talent pool. It is recommended to evaluate the potential benefits of a more flexible, hybrid, or remote work model to attract diverse talent from different geographic locations.
• Perform Regular Compensation Benchmarking: To remain competitive, especially for high-demand roles like Financial and IT Managers, HR should conduct annual salary benchmarking against industry standards. This ensures that compensation packages are attractive enough to retain top performers.

6. Visualizations & Dashboards

The project consists of two interconnected dashboards designed for different levels of analysis:

• Overview Dashboard: This page provides a high-level, strategic view of the entire organization. It features prominent KPIs, demographic breakdowns, and departmental comparisons, allowing executives and HR leaders to quickly gauge workforce health.
• Details Dashboard: This page offers a granular, sortable, and filterable list of every employee. It's a powerful tool for HR managers to look up specific individuals, filter by various attributes (e.g., "all female employees in the New York marketing department"), and export data for specific reports.

7. Impact & Results

This HR Analytics Dashboard transforms raw employee data into actionable intelligence. It empowers the HR department and company leadership to:

• Make informed, data-driven decisions about talent management and workforce planning.
• Proactively identify departments with high turnover and investigate underlying causes.
• Monitor diversity and inclusion metrics related to gender and age.
• Ensure compensation is competitive and aligned with experience and performance.
• Streamline reporting processes, saving time and reducing the risk of manual errors.