An interactive Power BI dashboard designed to track employee attendance, performance, and salary insights in one place.
This project provides a data-driven HR solution that helps organizations monitor workforce productivity with ease.
✅ Employee Overview – Presents key metrics like Present Days, Absent Days, Leaves, and Weekoffs.
✅ Performance Gauge – A quick glance at employee performance levels.
✅ Salary Insights – Detailed breakdown of total salary, deductions, and net salary.
✅ Monthly Trends – Visual charts for attendance patterns across months.
✅ Employee-wise Analysis – Select by Employee ID and Month for personalized reports.
✅ Smart Visuals – Intuitive icons and charts for better understanding.
- Power BI → Data modeling & visualization
- Excel/CSV → Data source for employee records
- DAX → Custom calculations for performance, attendance, and salary insights
- 📌 HR teams for tracking attendance & payroll
- 📌 Managers for monitoring employee performance
- 📌 Employees for self-tracking leaves & salary
- 📌 Businesses to automate HR reporting
- Employee Attendance: Visual representation of present, absent, leave, and weekoff days.
- Performance Score: Quick employee performance index (0–1 scale).
- Salary Breakdown: Clear view of total salary vs deductions.
- Monthly Analysis: Identify absenteeism and leave trends.
📁 Attendance-Tracker ├── 📊 https://github.com/Bishakhakapur/Attendance-Tracker-Analysis/blob/main/Attendance%20Tracker%20Dashboard.pbix # Power BI Dashboard file
├── 📑 https://github.com/Bishakhakapur/Attendance-Tracker-Analysis/blob/main/Main%20Attendance%20Data%20Sheet.xlsx # Employee attendance & salary dataset
- 🔹 Add real-time database integration
- 🔹 Create HR alerts & notifications
- 🔹 Build a self-service employee portal
This project is built to simplify HR analytics and provide quick, reliable insights for better decision-making.
Author - Bishakha Kapur
Contact on - bishakhakapur7@gmail.com