In this project, I preprocessed an HR dataset and created three insightful Tableau dashboards to visualize the data. The objective was to clean and transform the raw data to make it suitable for analysis, and then present key insights in an interactive and user-friendly dashboard.
These dashboards and analyses are based on HR KPIs (Key Performance Indicators). For a deeper understanding, you can read my Medium articles about the most important HR KPIs, available in two parts with formulas and examples:
The dataset was sourced from HR Dataset Kaggle.
It contained 311 records and 36 features, including:
| ALL FEATURES | |||
|---|---|---|---|
| Employee_Name | EmpID | MarriedID | MaritalStatusID |
| GenderID | EmpStatusID | DeptID | PerfScoreID |
| FromDiversityJobFairID | Salary | Termd | PositionID |
| Position | State | Zip | DOB |
| Sex | MaritalDesc | CitizenDesc | HispanicLatino |
| RaceDesc | DateofHire | DateofTermination | TermReason |
| EmploymentStatus | Department | ManagerName | ManagerID |
| RecruitmentSource | PerformanceScore | EngagementSurvey | EmpSatisfaction |
| SpecialProjectsCount | LastPerformanceReview_Date | DaysLateLast30 | Absences |
Data cleaning was performed to ensure the dataset was free from errors and inconsistencies.
The following steps were taken:
- Remove Duplicates
- Standardizing data
- Convert data types
- Check Missing/NULL Values
Download SQL queries: ../Data-Cleaning-SQL-Queries.sql
Download as PDF: ../People-Analytics-Dashboard.pdf
-
Open Interactive Dashboards on Tableau Public
-
Download and Open the Tableau Workbook file on your own Tableau: ../HR-Data-Analysis-Tableau-Workbook.twbx
Thank you for taking the time to read this article; your valuable feedback is warmly welcomed.
Furthermore, I would be happy to assist you in solving a puzzle in your Data journey.
pouya@sattari.org