Templates in Query designer

The Query designer in Workplace Analytics includes a number of predefined templates that analysts can use to visually analyze workplace patterns and trends. A template pre-populates a custom Workplace Analytics query and selects the applicable Power BI charts to show results from these queries.

Requirements for analysts

Before analysts can get to work, they must have the proper role. Each analyst must be assigned the Workplace Analytics 'analyst' role. An Azure Active Directory Privileged Role Administrator assigns roles, and can learn more about this task in Assign roles. For general information about user roles in Workplace Analytics, see User roles.

Licensing notes

  • To use analyst features, an employee needs only to have the analyst role assigned. They do not need to have been assigned a Workplace Analytics license.
  • The predefined templates available in Query designer require the use of the Power BI desktop. You do not need a license for Power BI desktop; you can download it for free by going to Getting started with Power BI.

Power BI dashboards

Workplace Analytics includes the following Power BI dashboards for visually analyzing data in Power BI. Select one to see more details about it and to view an interactive demo.


The dashboards are currently only available in English and will only work with data generated from the English version of Workplace Analytics. Before running the required queries, confirm or change the browser language to en-us in the app's URL: https://workplaceanalytics.office.com/en-us/Home/

Sales effectiveness icon. Sales effectiveness
Shows how your sales employees collaborate with external parties. With CRM data uploaded, this report can provide advanced insights about your employees’ interactions with CRM accounts.
Ways of working assessment icon. Ways of working assessment
Shows a quick and easy way to see current collaboration behaviors and culture and insights into employee wellbeing and engagement in your organization.
Ways of working tracker icon. Ways of working tracker
Shows how you can track behavior change and target opportunities to improve employee wellbeing, meeting culture, and manager effectiveness.
Return to work icon. Return to worksites
Shows how to plan who returns to work, and when, where, and how they do for the different work locations.
Business communication icon. Business continuity
Shows example insights into how shifting to remote work has impacted business.
Microsoft Teams insights icon. Microsoft Teams insights
Shows how adopting Microsoft Teams can affect collaboration and productivity in your organization.
Manager effectiveness icon. Manager effectiveness
Shows analysis to measure behaviors and trends of people managers across four key themes within your organization, including coaching, empowerment, connecting, and modeling.
Behavior patterns icon. Behavior patterns for Glint
Combines behavioral data from Workplace Analytics and sentiment data from Glint for insights that help identify opportunities to influence behavior and improve business outcomes.
Sales business continuity icon. Sales business continuity
Shows insights into how shifting to remote work has impacted your sales organization.