The biometric clock in system that the client uses generates an excel sheet that is poorly formatted and difficult to analyze

The client wanted to be able to determine how many days each employee worked and how many hours of overtime each employee has worked in the past 31 days.

The dataset was cleaned and transformed using tidy data principles. The resulting tidy data was then saved as an excel sheet and used in building a dashboard.