Employee Attendance & Project Cost System

? Project Cost & Workforce Analysis Dashboard (Excel)

I designed and developed an interactive Excel dashboard to track employee attendance, working hours, and project costs.

? Key Features:

* Track employee attendance (Present, Late, Absent, Leave)

* Calculate working hours and overtime

* Automatically calculate project costs based on employee salaries

* Interactive dashboard with slicers (Project, Department, Employee)

* Visual charts for cost analysis, workforce distribution, and working hours

* Clean and user-friendly design

? Tools Used:

* Microsoft Excel

* Pivot Tables & Pivot Charts

* Data Validation

* Formulas (IF, VLOOKUP, etc.)

* Slicers & Dashboard Design

This system helps businesses monitor workforce performance and analyze project costs efficiently.

? Available for similar projects and custom dashboards.