Overview: This HR Analytics Dashboard is designed to provide comprehensive insights into employee attrition, giving an in-depth view of key factors influencing attrition rates within an organization. The dashboard focuses on multiple dimensions, such as departments, age groups, education fields, job roles, monthly income, and years of experience, to help stakeholders make informed decisions regarding talent retention.
Key Features:
Displays overall and active employee counts, attrition totals, and the average age of employees. Provides a quick snapshot of the workforce status. Attrition by Department:
A pie chart visualizes the distribution of attrition across major departments (R&D, Sales, HR), helping to pinpoint areas with high turnover rates. Attrition by Education Field:
A bar chart highlights which education fields experience the highest levels of attrition (Life Sciences, Medical, Marketing, Technical Degrees, etc.), offering insights into academic backgrounds linked to attrition. Employee Breakdown by Age Group:
A stacked bar chart categorizes employees by age and gender (under 25, 25-34, 35-44, etc.), showing patterns of attrition across different demographics. Job Role-Based Attrition:
A heat map matrix shows attrition rates by job role (e.g., Healthcare Representatives, Sales Executives, Research Scientists) across different performance levels, emphasizing roles with the most turnover. Attrition by Years at Company:
A line graph indicates how attrition trends vary by the length of tenure, with peaks in early years of employment, helping to identify retention challenges during the employee lifecycle. Attrition by Monthly Income:
Another line graph presents how attrition correlates with employee income, highlighting disparities in turnover across income levels.
Impact: The dashboard provides a data-driven approach to understanding employee attrition. It allows HR teams to:
Identify high-risk areas for employee turnover. Target interventions based on demographic, role-based, or income-specific insights. Improve employee retention strategies by addressing root causes of attrition. This project leverages clear data visualization to distill complex HR metrics into actionable insights for management and HR professionals, offering a robust tool for talent management and workforce planning.
Tech Stack:
Power BI: Used for dynamic data visualization and creating interactive charts and graphs. Data Source: Historical HR data on employee attrition.
Note: This dashboard is designed for businesses that want to harness the power of data to improve employee retention, understand workforce dynamics, and optimize HR strategies.