Payroll & Attendance Intelligence Dashboard
A comprehensive Looker Studio dashboard analyzing a full year of 2023 employee records (1500+ employees). Features monthly absenteeism patterns, net salary distribution, OT cost analysis, and department-wise trends.
Live Report
Tools: Google Data Studio • Advanced Excel • Google Sheets
Business Impact:
- Reduced salary reconciliation errors via visual audit summaries.
- Enabled real-time monthly HR reviews for management.
- Saved 4–5 hours of manual reporting per payroll cycle.