18F / g-dataservices

18F's Data Services Guild
0 stars 2 forks source link

Use Tock data to identify periods with lower relative compliance #2

Open mheadd opened 5 years ago

mheadd commented 5 years ago

Description

Use data from Tock to analyze patterns in timely submissions of timesheet information. Are there times when non-compliance is higher (e.g., during the Summer, or over the holidays)? Are there specific individuals who are chronically late in submitting timesheet information to Tock? This analysis could identify some easy steps to take to improve the timely submission of timesheet information.

Data sets or tools needed

There is lots of bulk data available on Tock, but I'm not sure the timestamp for when someone submits their time is included in the available reports. presumably, this would require a one off dump of Tock data and then just some way to run some SQL queries (importing the Tock data into a RDMS of some kind).

Other information

This may be something that has been looked at before at 18F. Not sure.