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?

Data Overview

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.

Common Patterns

Archetypes

Split by HR Attribute

Time Dynamics

0 Low Activity (< 3 hours on)

1.1 Standard continuous (expected schedule)

1.2 Standard continuous (shifted schedule)

2.1 Standard flexible (expected schedule)

2.2 Standard flexible (shifted schedule)

3 Long flexible workday

4 Long continuous workday

5 Always on (13h+)