This report seeks to classify employees by their daily collaboration habits. We use Email and Teams Instant Message (IM) data to measure employee activity during each hour of the day, and group employees that share similar habits in 6 core archetypes. The method complements our traditional workweek span and after-hours analysis, by providing a more detailed view of activity throughout the day.
Among other things, this report should allow analysts to answer:
How many employees are concentrating their collaboration within the expecting working schedule (e.g. 9-5)?
How many employees are working on a more flexible schedule, going beyond 9-5 but taking breaks?
How many employees are working beyond the regular working schedule? How are those hours distributed?
How many employees appear to be struggling to disconnect / are always-on?
The data used is a Hourly Collaboration Query
There are 2326 employees in this dataset.
Date ranges from 2020-07-19 to 2021-01-10.
Unique identifiers include: Domain
is WPAPUBLICDEMO.ONMICROSOFT.COM; IsActive
is TRUE; IsInternal
is TRUE; Region
is US; TimeZone
is Pacific Standard Time
There are 5 (estimated) HR attributes in the data:
FunctionType
, LevelDesignation
, Organization
, attainment
, SupervisorIndicator
There are 2326 active employees out of all in the dataset.
Variable name check:
No collaboration hour metric exists in the data.
No instant message hour metric exists in the data.