Building Employee/Visitor Attendance (6 Months) - Ideas for the Dashboard

[Anonymous]

Hi there!

I'm relatively new to Power Bi and am struggling to determine the constraints/capabilities when compared to excel. I would greatly appreciate assistance in determining if the following is something I can do in Power Bi.

Method:

1. Reduced data to include 1 badge-in per day, per unique ID
2. Merged HR data with badge data
3. Identified which badge-ins are from visiting employees and which are from assigned employees
4. Excluded unique IDs that were in less than 10% of the study
5. Removed first and last week of study (to avoid 100% show-up rates)

Excel Dashboard + Analysis + Badge/Attendance Data + HR Data:

Link to Sample Workbook