Home
Microsoft

Workplace Analytics - June 2018: New metrics and person-to-group queries

The Workplace Analytics team is excited to announce our feature updates for the month of June (see past blog articles here). In this update, we'll feature several exciting new releases:

 

  • Use person-to-group queries
  • Change the base metric in a query
  • Measure time in self-organized meetings
  • Filter by meeting-organizer attributes

 

Use person-to-group queries

Using a person-to-group query can help you understand how deidentified individuals invest time internally and externally. The query results list these deidentified "time investors" by their PersonIDs, one or more groups that you define in the query ("collaborators"), and the amount of time that the "time investor" spends with the defined groups. Note that, because people are designated a randomly generated PersonID to maintain deidentification, there is no way to identify an individual from the query output. Get more details.


1. Person-to-group.jpg

 

 

A key use of the person-to-group query is to get insights about how deidentified employees are engaging with external collaborators. Here are some scenarios:

  • How are different marketing teams across regions engaging with external partners?
  • How are different roles in the sales teams engaging with existing customers?
  • How much time are the sales teams spending with external collaborators compared to time spent on internal processes?

This type of query also helps analysts understand collaboration patterns within their organization. For example, with just one query output, you can gain insights like:

  • How are engineering teams across regions collaborating with sales and marketing teams?
  • How are different roles in the engineering teams collaborating with operations and support teams?
  • How are engineers at different levels collaborating with G&A and legal teams?

 

To run a person-to-group query

  1. Open the Queries page in Workplace Analytics:2. Queries for person-to-group example.png

     

  2. Click Person-to-group. This opens the Person-to-group query page, where you select metrics, apply filters, and group deidentified participants to customize the results that you want the query to produce.
  3. After you customize the query, click Run.

 

The following screenshot shows a sample person-to-group query for deidentified persons on the North America sales team:

 

3. Person-to-group.png

 

 

Supported metrics

You can use the following metrics in person-to-group queries:

  • Collaboration hours gives you the total amount of time that a deidentified individual spent collaborating. This includes time spent in email and time spent in meetings.
  • Email count and Email hours give you, respectively, the number of emails that were sent between the time investor and groups, and the amount of time the time investor spent writing or reading those emails.
  • Meeting count and Meeting hours give you, respectively, the number of meetings in which the time investor and the collaborators participated, and the number of hours the time investor spent in those meetings.
  • Network size tells you how many unique people the time investor has meaningful interactions with in the selected collaboration group over the selected time period.

 

Change the base metric in a query

You can now edit the base metric within a flexible query without losing any of the customizations and filters that you’ve already applied. This feature is intended to improve your efficiency by reducing the amount of work required to duplicate customizations on multiple base metrics.

Use the new drop-down menu on a base metric to select a different base metric. While this changes the metric, it also maintains your existing customizations. The following screenshot shows the menu you’d use to select a new base metric:

 

4. Base metric in a query.jpg

 

  

Measure time in self-organized meetings

This new metric measures the time in meetings that are organized by an individual, as opposed to time in meetings that are organized by others. It helps to clarify whether someone schedules many meeting hours and how that might contribute to overload in the organization.

 

In its simplest form, it can help uncover patterns about how employees organize meetings for themselves and indicate to what extent a person initiates meetings versus being pulled into meetings. You can also use the metric for other purposes:

  • Find the amount of time the person spends in self-organized meetings. Calculate this by subtracting Time in self-organized meetings from total Meeting hours.
  • Find the proportion of meeting time in meetings that are organized by the individual: Ratio of self-organized meetings = Time in self-organized meetings/Meeting hours.
  • Use the results from the preceding calculations to correlate this metric with other data, including business-outcome information.

 

To use the Time in self-organized meetings metric

1. Open the Queries page in Workplace Analytics:

 5. Self organized meetings.png

 

2. Click Person. This opens the Person query page.

3. Under Metrics, click Add metric and select Time in self-organized meetings.6. Metrics drop down.png

4. Run the query and download the output.

 

Filter by meeting-organizer attributes

When you create Meeting queries, you can now filter on the meeting organizer’s attributes. Use this feature to evaluate the nature and context of meetings from the organizer’s perspective, and to answer questions such as “Which teams are generating the largest meeting load?”

 

To filter by meeting-organizer attributes

1. Open the Queries page in Workplace Analytics:7. Meeting organizer attributes.png

2. Click Meeting. This opens the Meeting query page.

3. In the Filters section, select Organizer. You can filter for meetings of interest based solely on the organizer’s attributes.

 

8. Organizer Meetings.jpg