Ways of working assessment

The Ways of working assessment dashboard uses a template that’s populated by Workplace Analytics data to conduct a broad diagnostic of a company’s collaboration culture and employee experience. It is designed to highlight collaboration patterns for different groups and organizational levels and to identify opportunities for improvements.

The different pages in the report help you answer the following related questions:

Collaboration culture

  1. How is collaboration load impacting after-hours?
  2. How much time do people spend in different collaboration channels?
  3. How does the organization spend its meeting time?
  4. How much time is going toward long or large meetings?
  5. Who in the organization is generating the most workload by organizing meetings?
  6. Can employees reclaim focus time through ‘compact’ scheduling practices?
  7. Is multitasking during meetings driven by habit or by necessity?
  8. Which recurring meetings might present streamlining opportunities?
  9. Are there opportunities to drive greater agility in emailing practices?

Employee experience

  1. When does collaboration start impacting after-hours workload?
  2. Who in the organization is at highest risk of burnout?
  3. Is manager double-booking creating potential ripple effects across the company?
  4. Are employees receiving sufficient 1:1 coaching time?
  5. Are managers balancing oversight with employee empowerment and autonomy?
  6. What managerial behaviors predominate across the company and by organization?

Each report includes a What to examine and Why it matters interpretation that explain how to analyze the data to answer the business questions and how to use best practices to maintain or improve company collaboration patterns and employee experience.

To populate the dashboard in Power BI, you must set up and successfully run the predefined Ways of working assessment and Standard meeting query in Workplace Analytics.

After you successfully run these queries, you can download the template from the Ways of working assessment query on the Results page. After you download the template, you can then connect the query data from Workplace Analytics to the dashboard in Power BI.

Note

The template and dashboard name has been changed from Collaboration assessment to Ways of working assessment.

Demonstration

The following demo uses sample data that is only representative of this dashboard and might not be exactly what you see in a live dashboard specific to your organization's unique data.


To find the template for the Ways of working assessment dashboard, go to the Query designer. For complete steps, see Set up the dashboard.

Prerequisites

Before you can run the queries and populate the dashboard in Power BI, you must:

  • Be assigned the role of Analyst in Workplace Analytics.
  • Have the latest version of Power BI Desktop installed. If you have an earlier version of Power BI installed, uninstall it before installing the new version. Then go to Get Power BI Desktop to download and install the latest version.

Set up the dashboard

Note

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

  1. In Workplace Analytics, select Analyze > Query designer.

  2. In Create > Featured templates, select Ways of working assessment to see the required setup steps, and then in step 2, select Set up.

  3. When prompted, confirm the following settings:

    • Name - Customize or keep the default name
    • Group by - Week
    • Time period - Select the time period you want to analyze
    • Auto-refresh - Leave this setting disabled because this template is not designed to track metrics over time
    • Meeting exclusions - Select the preferred rule for your tenant

    Important

    If you try to delete a predefined metric, you'll see a warning that the deletion might disable portions of the Power BI dashboard and reduce query results. In turn, this can limit your ability to visualize collaboration patterns. Depending on the metric you delete, you might disable a single Power BI chart, several charts, or all the charts. Select Cancel to retain the metric.

  4. In Select filters, select Active only for Which measured employees do you want to include? Optionally, you can further filter the employees in scope for the dashboard. For more details about filter and metric options, see Create a Person Query.

  5. In Organizational data, keep the preselected Organization and LevelDesignation attributes that the dashboard requires.

    Important

    LevelDesignation is a reserved optional attribute when uploading your organizational data. If this attribute was not uploaded and is unavailable in Workplace Analytics, charts and data relating to LevelDesignation will not show in the query output or in Power BI reports.

  6. You must then locate and select the organizational attribute that identifies people managers in your company (those who have employees who report to them directly or indirectly) as opposed to individual contributors (ICs). Because this field is not a required organizational attribute, your organization might not have included it when setting up Workplace Analytics. If you cannot find the field in the drop-down menu, contact your Viva Insights or Workplace Analytics admin to confirm whether the field was included in the Organizational HR data file and made available in the query output.

    Important

    You can still set up the dashboard without the people manager attribute. However, some of the Power BI charts and filtering capabilities will be disabled.

  7. You can then select any additional attributes (columns) that you want to include in the reports.

  8. Select Run to run the query, which can take a few minutes to complete.

  9. When prompted, select to return to the Query designer and run the Standard meeting query to get the meeting metrics for the dashboard.

  10. Select or confirm the following query settings:

    • Name - Customize or keep the default name
    • Time period – Select the time period you want to analyze; it should match the one you selected in the Ways of working assessment query.
    • Auto-refresh – Leave this setting disabled because this template is not designed to track metrics over time
    • Meeting exclusions - Select the preferred rule for your tenant

    Important

    If you try to delete a predefined metric, you'll see a warning that the deletion might disable portions of the Power BI dashboard and reduce query results. In turn, this can limit your ability to visualize collaboration patterns. Depending on the metric you delete, you might disable a single Power BI chart, several charts, or all the charts. Select Cancel to retain the metric.

  11. Optionally, you can add filters to limit the list of meetings included in the output file. To learn more about meeting filters, see Add filters for meeting queries. You can also customize the metrics to focus on a specific organization (or any other organizational attribute). To learn more about custom metrics, see Add custom metrics in a meeting query.

    Important

    If you filtered the Ways of working assessment query to focus on a specific organization (or any other organizational attribute), you must customize the metrics for this Standard meeting query to reflect the same population.

  12. In Organizational data, keep the preselected IsRecurring, Subject, and DurationHours attributes that the dashboard requires.

    Important

    If you remove the required, preselected Organizational data attributes, you might disable one or more Power BI charts.

  13. You can then select any additional attributes (columns) that you want to include in the reports.

  14. Select Run to run the query, which can take a few minutes to complete.

  15. When prompted, continue to Results. After both queries successfully run, select the Download icon for the Ways of working assessment query results, select PBI template, and then select OK to download the template.

    Download the Power BI Ways of working assessment template.

  16. Open the downloaded Ways of working assessment template.

  17. If prompted to select a program, select Power BI.

  18. When prompted by Power BI, copy and paste the OData links for both queries into their respective fields.

    • In the Workplace Analytics Query designer > Results page, select the Link icon for each query, and select to copy the generated OData URL link.
    • In Power BI, paste each copied link into its respective field.
    • Set the Minimum group size for data aggregation within this report's visualizations in accordance with your company's policy for viewing Workplace Analytics data.
    • In SupervisorIndicator field, enter the exact name of the organizational attribute that you selected in Step 6, which designates who in the organization is a people manager. If your organization has not uploaded this field in the organization data file, you don’t have to complete this field. However, some visuals and filtering capabilities will be disabled.
    • Select Load to import the query results into Power BI. Loading these large files may take some time to complete.
  19. If you're already signed in to Power BI with your Workplace Analytics organizational account, the dashboard visualizations will populate with your data. You are done and can skip the following steps. If not, proceed to the next step.

  20. If you're not signed in to Power BI, or if an error occurs when updating the data, sign in to your organizational account again. In the OData feed dialog box, select Organizational account, and then select Sign in. See Troubleshooting for more details.

    Power BI sign in.

  21. Select and enter credentials for the organizational account that you use to sign in to Workplace Analytics, and then select Save.

    Important

    You must sign in to Power BI with the same account you use to access Workplace Analytics.

  22. Select Connect to prepare and load the data, which can take a few minutes to complete.

Dashboard settings

After the Ways of working assessment dashboard is set up and populated with Workplace Analytics data in Power BI, as a first step to viewing data in the dashboard, view and set the following parameters on the Settings page.

  • Time period - This is the time period that you want to analyze.
  • Exclude specific weeks – You can select one or more weeks to exclude from analysis, such as those that include company holidays.
  • Organizational attribute to view the report by - The primary “group-by” attribute shown in all subsequent reports. You can change this attribute at any time and all subsequent report pages will show group values by the new attribute.
  • Organizational attribute to filter by – To filter the measured employee population, you can filter by any selected Organizational attribute, and then filter by any of the values for these attributes. If you use filters, the measured employees count will reflect a reduced number. Measured employees reflect the number of employees in the filtered population who were active during the specified time period. Active employees are those who sent at least one email or instant message during a work week included in the current time period.

Important

The filters selected in Settings apply to all but one of the reports. The Meeting engagement report is the exception. To focus on a specific organization in that report, you must customize the metrics in the Standard meeting query in Workplace Analytics, as described in Step 11 of Set up the dashboard.

After confirming the settings, check the number of measured employees to confirm this is the population you want to analyze.

Ways of working assessment dashboard settings.

Employees with low collaboration

By default, this dashboard excludes employees who spent a weekly average of less than five hours in meetings, email, instant messages, and calls because they are likely non-knowledge workers or they do not use Outlook or Teams.

The dashboard also excludes unusually low collaboration weeks based on individual collaboration patterns. These low collaboration weeks usually occur when employees are taking time off from work.

If you want to include employees with low collaboration in your analysis, select the Clear filter (eraser) icon to clear the IsLikelyKnowledgeWorker and IsLikelyHoliday filters in the Power BI Filters pane.

Clear filters to include low collaboration workers.

About the reports

The Ways of working assessment dashboard includes the following report pages that help you assess your company's collaboration culture and employee experience.

Collaboration culture

  • Collaboration and after-hours – Shows the average weekly collaboration hours for each person by organization as compared to after-hours collaboration and the percentage of a standard 40-hour workweek spent in collaboration. This highlights how collaboration load is impacting after-hours work.
  • Collaboration modes – Shows the average weekly hours spent in meetings, email, chats and unscheduled calls for each person by organization as compared to after-hours activity. Understanding differences between how teams get work done can uncover both replicable best practices and areas of opportunity.
  • Meeting culture – Shows the percentage of time spent in the different meeting types by attendees and duration. This highlights how the organization spends its meeting time. Large or long recurring meetings are easy candidates to streamline by reducing the number of attendees or the meeting frequency or duration.
  • Long or large meetings – Shows the percentage of meeting time spent in large or long meetings by organization. Analyzing meeting practices at the organizational level can help pinpoint sources of meeting overload to streamline or those organizations with successful meeting best practices that could be replicated across the company.
  • Generated workload – Shows the distribution of employees by the number of meeting hours each employee generated by organizing meetings. This highlights who in the organization is generating the most workload by organizing meetings.
  • Fragmentation – Shows the fragmented hours as compared to the number of meetings that employees attend weekly. This information can help you guide employees to reclaim important focus time through compact meeting scheduling practices.
  • Multitasking – Shows the distribution of employees by their average collaboration hours and average multitasking rate. This analysis helps determine if multitasking rates during meetings are a function of habit or a consequence of lacking enough free time during the workday to catch up on email outside of meetings.
  • Meeting engagement – Shows recurring meetings by meeting impact and meeting engagement and lists the top 20 low engagement recurring meetings. This highlights which recurring meetings are good candidates to streamline by reducing the number of attendees or the meeting cadence or duration.
  • Email load – Shows the distribution of emails sent based on the number of recipients of each email. It also shows the percentages of these email categories sent by employees in each organization. This information can help your organization drive greater agility in emailing practices.

Employee experience

  • After-hours pressure – Shows the average number of after-hours collaboration hours per week as a function of total time spent on collaboration and highlights if and when weekly collaboration starts impacting after-hours workload.

  • Burnout risk – Shows the distribution of employees by collaboration hours and workweek span, which helps you identify who in the organization is at highest risk of burnout.

  • Double-booking – Shows the distribution of managers by meeting hours and the percentage of double-booked manager time in meetings. This highlights how double-booked meetings have downstream impacts that hinder organizational agility.

    Important

    To filter for manager data only, you must select all manager groups in the SupervisorIndicator at the upper right of the page.

  • Manager 1:1 time & frequency – Shows the distribution of employees by how much weekly 1:1 time they get with their managers and the frequency of these meetings. This highlights if employees are getting enough 1:1 manager coaching.

  • Co-attendance – Shows the percentage of employees who spend more than 30 percent of their meeting time in meetings where their manager is also present. This highlights if managers are balancing oversight with employee empowerment and autonomy. However, it’s important to account for any expectations and norms unique to your company when analyzing the data across the different groups.

    Important

    To filter for manager data only, you must select all manager groups in the SupervisorIndicator at the upper right of the page.

  • Manager relationship – Shows the distribution of employees attending the same meetings as their managers and their average weekly 1:1 meeting time with their managers, which is compared across the company. It also analyzes different segments of manager behaviors based on their rates of attending the same meeting as their employees and their 1:1 meeting time.

The dashboard also includes a Glossary page that describes all the report metrics.

Training opportunity

Learn how to use this template to evaluate collaboration culture and employee experience: Analyze collaboration and engagement using the Workplace Analytics Ways of working assessment dashboard

Power BI tips, FAQs, and troubleshooting

For details about how to share the dashboard and other Power BI tips, troubleshoot any issues, or review the FAQ, see Power BI tips, FAQ, and troubleshooting.

View, download, and export query results