Edit

Share via

Glint and organizational insights report

  • Article

The Glint and organizational insights report lets you explore the relationship between behaviors measured in Viva Insights and Viva Glint survey responses, to better understand employee sentiment at your company.

With this report, you can:

  • Investigate how employee sentiment and organizational collaboration patterns might be correlated.
  • Visualize trends for organizational data.
  • Average organizational metrics, which are broken down by sentiment favorability.

Before we get started, you should know:

  • Your survey data imports from Glint to Viva Insights through an API. Your admin needs to set up this connection.
  • To populate the report in Power BI, you’ll need to set up and successfully run the predefined Glint and organizational query in Viva Insights.

Demonstration

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

Prerequisites

Before you can run the queries and populate the report in Power BI, you’ll need to:

Report setup

Run query

  1. In the Viva Insights analyst experience, select Analysis.
  2. Under Power BI templates, navigate to Glint and organizational insights and select Set up analysis.

  1. Under Query setup:

    1. Type a Query name.

    2. Type a Description (optional).

    3. Select a survey for analysis. You can download the query results as a .csv file for Viva Glint surveys that had raw data export enabled when the survey was set up. Otherwise, you'll be prompted to contact your Viva Glint administrator for more information, or select a different dataset. Learn more about raw data export. The zip file includes the following output:

      • CategoryToMetricMapping: This file includes .csv file that includes the Glint Question to Viva Insights Metric mapping used for the report. This mapping is specific to the Power BI template and can be used as needed for custom reporting.
      • HR: This file includes the .csv organizational HR attributes associated with each user who's included in the query output.
      • MetricOutput: This file includes the .csv Viva Insights metrics associated with each user who's included in the query output.
      • SurveyMetadata: This file includes the .csv survey metadata for the selected survey.
      • Survey Output file using report ID: This file includes the .csv survey response output for the selected survey for each user who's included in the query output.
        Screenshot that shows the survey output file.

    4. Change the metric rule (optional). To set a new metric rule, select More settings. Then, pick a new rule from the list. For more information about metric rules, see Metric rules.

    Note

    You’re not able to edit the date range or turn on auto-refresh for this report.

    This report analyzes data 90 days before and after the survey closed. To work, it needs at least 30 days of data before the survey started.

    The More settings pane also contains Group by settings. Power BI queries are set to Group by Week, and you're not able to edit this field.

  2. Under Predefined template metrics, view the list of preselected metrics, which appear as gray tags. These metrics are required to set up the Power BI report and you can’t remove them. You can add other metrics by selecting Add metrics, but these metrics won’t be available to use in the Power BI report at this time. Under the Is active filter, select Add condition, then select your organizational data.

    Important

    Low-quality or missing organizational data might affect your metrics and result in warnings or errors. Learn more about data-quality notifications in Data quality in the analyst experience.

  3. Under Select which employees you want to include in the query, choose a filter to identify the employee group you’d like to focus on. We've set one filter for you. You’re not able to add additional filters.

  4. Under Select which employee attributes you want to include in the query, add your organizational attributes. Once the query runs, use these attributes to group and filter the reports.

    Important

    This Power BI query needs some specific attributes to run, and we've preselected them for you. These attributes appear in gray and you can't remove them. We might also include some attributes to improve the relevancy of your results, like "Organization," but aren't required for your query to run. These attributes appear in blue and you can remove them.

    If you notice attributes marked with yellow warnings, that attribute's quality is low. If you notice attributes marked in red and the query's Run button disabled, then your organizational data is missing that attribute.

    Learn more about attributes and data quality in Data quality in the analyst experience.

  5. Select Run on the upper right side of the screen. The query might take a few minutes to generate.

    1. When your query results are ready, go to the Query results page and select the eye symbol above Power BI to view the report.

Report settings

Setting Description
View report by Set the primary group-by attribute for all report pages. You can change this attribute at any time and all report pages will group values by the new attribute.
Filter by Select a category you want to filter your report by:
  • Organization
  • One of the survey's questions
Filter value Filter by a value in the category you selected above. For example, if you selected "Organization" above, you could set "Engineering" here. You'll only see data from the Engineering organization, so setting filters lowers the People included in this report count.
Include Choose whether you want this report to include:
  • Weeks that people are probably out of office, like holiday weeks. These weeks have lower levels of collaboration than others.
  • Employees who collaborate fewer than hours per week. These employees are unlikely to be knowledge workers, or they don’t use Outlook or Teams.
Preferred report language We support the following languages: Chinese (Simplified); Chinese (Traditional); English; French; German; Italian; Japanese; Korean; Portuguese (Brazil); Russian; and Spanish.

People included in this report

To protect privacy, this report doesn't show groups with fewer than the larger of these two numbers: the minimum group size for Viva Insights; or the minimum group size for Viva Glint.

About the report

This report shows two main pieces of information:

  • The Glint score, which is how your organization responded, on average, to a particular question on the Glint survey.
  • The correlation, which is the relationship between the Glint score and a Viva Insights metric. Metrics provide productivity information about your organization's employees—for example, Collaboration hours or Manager coaching hours 1:1.

About correlations and relationships

Throughout this report, correlations indicate whether change in a survey response average is associated with change in a Viva Insights metric, and vice-versa.

In other words, if data for certain metrics change, would Glint scores reflect that change? For example, if employees received fewer manager coaching 1:1 hours, would they rate their relationship with their managers differently when they took a Glint survey? The answer might be "yes" if a metric and a survey question have a high correlation.

Understanding these relationships can help you better contextualize your Viva Insights metric data, and also understand how these numbers are affecting your organization's employees.

How we calculate correlations and determine relationships

We've selected a list of Glint survey questions and Viva Insights metrics that could potentially be related. We curated this list from our entire set of Viva Insights metrics. To help create this list, we drew from academic literature and validated correlations between a sample set of Glint and Viva Insights data pairs.

To arrive at the correlations you see in your report, we use the Pearson correlation coefficient (r) between each pair: survey question responses and data from a Viva Insights behavior metric. Correlations fit within a scale from -1 to 1:

-1 indicates a perfect negative linear relationship—that is, as one variable increases, the other decreases. For example, the behavior metric After-hours collaboration might show high after-hours work time, and all respondents report they don't feel like their company encourages a work-life balance. So, as after-hours work goes up, how employees rate their work-life balance goes down. If you're looking at a -1 correlation on a graph, the data points would form a diagonal line from the top of the y axis to the bottom of the x axis.

0 indicates no relationship. For example, the behavior metric Uninterrupted hours might show varied uninterrupted hours, and respondents give varying answers when asked whether they have time to dedicate to learning at work. If you're looking at a 0 correlation on a graph, there wouldn't be a discernable pattern between the data points.

1 indicates a perfect positive linear relationship—that is, as one variable increases, the other increases. For example, the behavior metric Meeting and call hours with manager 1:1 might show high manager 1:1 time, and all respondents report that they feel coached by their manager. So, as manager 1:1 time goes up, how employees rate feeling coached also goes up. If you're looking at a 1 correlation on a graph, the data points would form a diagonal line from the bottom of the x axis to the top of the y axis.

Using these correlations, we determine whether a relationship between a Glint survey question and a Viva Insights metric is strong, moderate, weak, or if there's no relationship.

For positive correlations For negative correlations
Strong relationship 0.5 to 1 -1 to -0.5
Moderate relationship 0.3 to 0.5 -0.5 to -0.3
Weak relationship 0.1 to 0.3 -0.3 to -0.1

If a survey question and metric have no relationship, the correlation is between -.1 and .1, including 0.

Explore survey and metric relationships

Select a survey question, pair it with a Viva Insights metric, and explore the relationship between the pairing. To dive deeper, add the View report by, Filter by, and/or Filter value to see how this relationship changes for different populations. Refer to Report settings to learn more about these controls.

Screenshot that shows the survey and metric relationships page.

Question and metric relationship

View the average score for the Survey question you selected. The graph below the score card shows how strongly the survey question is connected to the organizational metric you selected. In addition to showing the correlation coefficient and the kind of relationship, the graph represents the distribution of survey scores for your selected question.

Organizational metric averages

View Viva Insights data for the organizational metric you selected, before and after the survey period. For example, if you selected "Meeting and call hours with manager 1:1" as your metric, the area chart would show you how many hours employees were spending on average with their managers before the survey took place, at the time of the survey, and after the survey closed.

Question response sentiments

Compare data for your selected metric with how favorably respondents answered your selected survey question. For example, if you picked "Uninterrupted hours" as your metric and "I feel supported to work in the way that is best for me in terms of when and where I work" as your survey question, the graph would show you the average uninterrupted hours by those who responded favorably, unfavorably, and neutrally. Select Open chart breakdown to view the total number of responses, and three separate graphs: metric data for those who responded favorably, unfavorably, and neutrally.

Glossary

Get definitions for all the metrics used in this report. To view definitions for all metrics in Viva Insights, refer to our metric definition article.

Viva Insights metrics and Glint survey categories

The Power BI report supports a subset of Viva Insights metrics per Glint survey question category. We mapped metrics to Glint categories based on data and research done by our team.

Question category Viva Insights metrics
Clarity
  • Meeting and call hours with manager 1:1
  • Meeting and call hours with skip level 1:1
  • Co-attendance rate
  • After-hours collaboration hours
  • Uninterrupted hours
Empowerment
  • Meeting and call hours with manager 1:1
  • Meeting and call hours with skip level 1:1
  • Co-attendance rate
  • After-hours collaboration hours
  • Uninterrupted hours
Wellbeing
  • After-hours collaboration hours
  • Uninterrupted hours
  • Active connected hours
  • Meeting hours
  • Meetings
  • Collaboration span
  • Meeting and call hours with manager 1:1
  • Meeting and call hours with skip level 1:1
  • Co-attendance rate
Connection
  • Internal network size
  • Diverse ties
  • Strong ties
  • Collaboration hours
  • Meeting and call hours with manager 1:1
  • Meeting and call hours with skip level 1:1
  • Meeting and call hours with skip level 1:1
  • Co-attendance rate
  • Meeting hours
Engagement
  • Meeting and call hours with manager 1:1
  • Meeting and call hours with skip level 1:1
  • Co-attendance rate
  • Internal network size
  • Strong ties
  • Diverse ties
  • Multitasking hours
Custom questions
  • After-hours collaboration hours
  • Uninterrupted hours
  • Active connected hours
  • Meeting hours
  • Meetings
  • Collaboration span
  • Meeting and call hours with manager 1:1
  • Meeting and call hours with skip level 1:1
  • Co-attendance rate
  • Internal network size
  • Strong ties
  • Diverse ties
  • Collaboration hours
  • Multitasking hours
Purpose No related Viva Insights metric available

Power BI tips, FAQs, and troubleshooting

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

Access query results and modify existing queries

Filters