A professional HR Analytics Dashboard built using Tableau to analyze employee attendance, wages, overtime, absenteeism, department performance, and workforce productivity using real-world HR datasets.
A comprehensive HR Analytics Dashboard built with Tableau to provide actionable insights into employee attendance, salary distribution, overtime, absenteeism, departmental performance, and workforce productivity.
Organizations often struggle to monitor employee attendance, overtime costs, salary expenditure, and absenteeism across departments.
This project transforms raw attendance and payroll data into interactive Tableau dashboards that help HR teams and management make informed decisions.
The dashboard provides detailed visualizations for:
- Employee Attendance
- Department Performance
- Wage Analysis
- Overtime Analysis
- Salary Loss
- Workforce Productivity
- Attendance Trends
- HR KPI Monitoring
✅ Employee Attendance Analysis
- Attendance Percentage
- Monthly Attendance Trend
- Attendance Comparison
✅ Wage Analysis
- Total Wages
- Monthly Wages
- Salary Distribution
- Department-wise Salary
✅ Overtime Analysis
- Total Overtime Hours
- Overtime Cost
- Overtime by Department
- Overtime Recovery Status
✅ Department Analytics
- Employee Count
- Attendance Percentage
- Average Absent Days
- Salary Loss
- Department Performance
✅ Employee Performance
- Attendance Trend
- Risk Flag Detection
- Shift Analysis
- Day vs Night Shift
✅ Workforce Productivity
- Contractual Workforce
- Permanent Workforce
- Output Panels
- Productivity Comparison
Employee-Attendance-Wages-Analytics/
│
├── attendance.csv
├── contractual.csv
├── cleaned data.xlsx
├── EMPLOYEE ATTENDANCE WAGES SHEET.xlsx
│
├── Book1.twb
│
├── newsheet1.csv
├── newsheet2.csv
├── newsheet3.csv
├── newsheet4.csv
├── newsheet5.csv
├── newsheet6.csv
├── newsheet7.csv
└── newsheet8.csv
- Employee Attendance %
- Average Attendance
- Department Performance
- Overtime Hours
- Overtime Cost
- Salary Loss due to Absenteeism
- Total Wages
- Workforce Distribution
- Shift Analysis
- Risk Employees
- Attendance Percentage
- Attendance Trend
- Employee Comparison
- Department-wise Attendance
- Employee Distribution
- Salary Loss
- Monthly Wages
- Department Wages
- Salary Analysis
- Total OT Hours
- OT Cost
- OT vs Recovery
- Permanent vs Contractual
- Productivity
- Output Comparison
- Tableau Desktop
- Microsoft Excel
- CSV Dataset
- HR Analytics
- Data Visualization
The project uses employee attendance and payroll datasets including:
- Attendance Records
- Payroll Data
- Department Information
- Shift Records
- Overtime Data
- Contractual Workforce Data
- Monitor attendance efficiently
- Identify absenteeism trends
- Analyze overtime expenses
- Track departmental performance
- Improve workforce planning
- Reduce payroll losses
- Increase productivity
- Power BI Version
- SQL Database Integration
- Python Automation
- Predictive HR Analytics
- Machine Learning for Attrition Prediction
- Interactive HR Portal
Nakul Dhiman
GitHub: https://github.com/Nakul-31
⭐ If you found this project useful, don't forget to star the repository.