This project involves analyzing the attendance data of employees in a software and data solutions company over three months. The dataset includes various types of attendance records such as present, paid leave, sick leave, work from home, and others. The goal is to understand the working preferences of employees and the overall percentage of sick leaves. This analysis is performed using Power BI, where we utilize Power Query for data transformation and DAX for creating metrics. The final outcome is a comprehensive dashboard that provides insights into the attendance patterns and preferences of employees.
- Understand the requirements from the given Excel sheet.
- Gather and transfer data using Power Query.
- Create metrics using DAX.
- Create metrics to understand the working preference of employees between work from home and work from office.
- Calculate the percentage of overall sick leave.
- Create a final usable dashboard.
- P - Present
- PL - Paid leave
- SL - Sick Leave
- HPL - Half day PL
- HSL - Half day SL
- WFH - Work from home
- FFL - Floating Festival Leave
- HFFL - Half Day FFL
- BL - Birthday leave
- LWP - Leave without pay
- HLWP - Half day LWP
- BRL - Bereavement Leave
- HBRL - Half BRL
- HWFH - Half WFH
- WO - Weekly Off
- ML - Menstrual Leave
- HML - Half day ML