An interactive dashboard creation using Microsoft Power BI for the Human Resource Manager of a company. For data source a Microsoft Excel file for attendance has been used.
This is a simple dataset of employee attendace from 1st April 2022 to 17th June 2022. Attendace attributes are as follows.
| Attribute | Description |
|---|---|
| P | Present |
| PL | Paid Leave |
| SL | Sick Leave |
| HPL | Half day PL |
| HSL | Half day SL |
| WFH | Work from home |
| FFL | Floting festival leave |
| HFFL | Half Day Floting festival leave |
| BL | Birthday Leave |
| LWP | Leave without pay |
| HLWP | Half day Leave without pay |
| BRL | Bereavement Leave |
| HBRL | Half Bereavement Leave |
| HWFH | Half Work From Home |
| WO | Weekly Off |
| HO | Holiday Off |
| ML | Menstrual Leave |
| HML | Half Day ML |
- Employee attendance percentage.
- Work From Home (WFH) percentage.
- Sick Leave (SL) percentage.
- Detailed attendance report of each employees.
- Monthly attendance, work from home and sick leave curves with trend line.
- Analysis of attendance, work from home and sick leave for each day of the week.
Click to with the dashboard.