Lets Connect
This HR analytics Tableau project is aimed at providing HR managers and business leaders a comprehensive way to analyze and monitor employee data, and make data-driven decisions related to employee retention, development, and recruitment.
This includes trendline and target line to help HR managers track progress toward reducing attrition. It has charts showing the distribution of employees and attrition rate by gender, age group, job satisfaction and education field. The chart includes legends and interactive filters to allow HR managers to drill down and explore the data further.
• Advance Excel 👨💻
• Tableau 📊
• Statistics 📜
- Data subset collected from online.
- Understanding the Data.
- Loading Libraries.
- Data Cleaning & Finding Missing values.
- Data Visualization.
-
Open Dataset in Excel and Make a Copy of Dataset for security purpose.
-
Remove Duplicates.
-
Change the formatting of necessary columns.
-
Spell Check.
-
Change Case - Lower/Upper/Proper.
-
Trim the unwanted spaces.
-
Remove null values if its not going to affect the result.
-
Find & Replace.
1st Sheet: KPI of Employee Count, Attrition Count, Attrition Rate, Active Employees and Average Age.
2nd Sheet: Attrition by Gender (Lollipop Chart)
3rd Sheet: Department wise Attrition (Pie Chart)
4th Sheet: No. of Employee by Age Group (Bar Graph)
5th Sheet: Job Satisfaction Rating (Square Chart)
6th Sheet: Education Field wise Attrition (Vertical Bar Graph)
7th Sheet: Education Field wise Attrition (Donut Plot)
VID_20230326144722.mp4
The HR Analytics Dashboard project using Tableau is designed to provide insights into key metrics and trends related to human resource management in an organization. The dashboard utilizes visualizations and data analysis techniques to help HR professionals identify patterns and make data-driven decisions. The dashboard includes several key visualizations that provide a comprehensive overview of HR-related metrics, including employee turnover rate, headcount, and employee engagement levels. The dashboard also includes metrics related to recruitment, including time-to-fill and cost-per-hire.
In addition to these metrics, the dashboard provides insights into employee performance, including metrics related to training and development, performance appraisals, and career progression. These metrics can help HR professionals identify areas for improvement and develop strategies for enhancing employee engagement and productivity.
The dashboard also includes interactive features that allow users to filter and drill down into specific data sets, such as department, location, or job level. This provides HR professionals with a more detailed view of their data, allowing them to identify patterns and trends more easily.
Overall, HR Analytics Dashboard project using Tableau is an essential tool for any HR professional looking to gain deeper insights into their organization's HR data. By leveraging the power of Tableau's data visualization and analysis tools, HR professionals can make data-driven decisions that can help drive organizational success.
I have uploaded all the files, datasets, workbook, icons above. Feel free to use this Project's resourses for your next Project. If you like this Project and Dashboard give it a Star or just tell me. It'll make me feel Good :)