Attendance Dashboard

Hey! I have an Excel file with employee attendance data for my factory. The data covers the last 6 months (November 2024 – April 2025) and includes 32 employees across 6 departments. I need you to build a dashboard from this so management can quickly understand what's going on with attendance. About the Data The file has one sheet with ~5,000 rows. Each row is one employee's attendance record for a single working day. The columns are: Employee ID, Name, Department, Date, Month, Status (Present / Late / Absent / Excused), Check-In Time, Check-Out Time, Hours Worked, and Notes. Working hours are 6 AM to 5 PM, Fridays off. What I Need in the Dashboard 1. KPI Cards at the top — Overall attendance rate, total absences, total late arrivals, and average hours worked per day 2. Monthly Attendance Trend — A line or bar chart showing how attendance rate changed month by month 3. Department Comparison — A chart comparing attendance rate across all 6 departments (some perform well, others don't — should be visible clearly)