Analysis on Attendance Sheet

Problem Statement

Atliq Hardware is a company that supplies computer hardware and peripherals to many of its clients. They have a head office in Delhi and this company has branches in other parts of India as well. HR of Atliq Technologies have an attendance sheet and from the attendance sheet, she wants to know the working preference of people like:-

who is working from home, who are working from home, who’s on sick leave, who’s on paid leave, who is working half day from home and half day from the office. So, the frustrated sales HR approaches a data analytics team and asks them to create a dashboard that would help him provide insights on presence percentage.

Loading Data

Importing attendance sheet in power bi, and combining excel data together in a proper format

Data Cleaning in Power BI

Loaded all the data files in Power BI and transformed the data. Removed unwanted rows, Columns headers were named correctly and we have each and every date in a different column so instant of having each column, I’ll have one column which is going to contain all the dates.

Data Visualization or Creating Dashboard

Data Visualization in Power BI Now comes the interesting part i.e. creating visualizations. I have created a report where we can see the work-from-home percentage sick leave percentage and presence percentage. Measures were created using the DAX and appropriate charts were created to show the trends and patterns finally the insights were generated.