Manager effectiveness report
The Manager effectiveness report uses a template populated by Microsoft Viva Insights data to analyze people-manager behaviors in your organization. HR analysts can use this analysis to measure behaviors and trends of people managers across five key themes within your organization: manager capacity, coach, empower, connect, and model.
Each theme includes insights about manager effectiveness and ways to help maintain or increase preferred leadership behaviors. Key metrics are used to deep-dive into each theme, along with a Why this matters interpretation and best practices recommended by industry experts.
To populate the report in Power BI, you’ll need to set up and successfully run the predefined Manager effectiveness 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:
Be assigned the role of Insights Analyst in Viva Insights.
Have the December 2022 (or newer) 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.
- Have SupervisorIndicator, the attribute that identifies managers, included as part of your organizational data.
Report setup
Run query
In the Viva Insights analyst experience, select Analysis.
Under Power BI templates, navigate to Manager effectiveness and select Start analysis. To get more information about the Manager effectiveness template before running your analysis, select Learn more.
Under Query setup:
- Type a Query name.
- Select a Time period. Time period defaults to Last 6 months.
- Set Auto-refresh (optional). You can set the query to automatically update by checking the Auto-refresh box. When you select the Auto-refresh option, your query automatically runs and computes a new result every time Viva Insights gets updated collaboration data for licensed people.
Note
If organizational data used in an auto-refreshing query changes (for example, an attribute name is altered or an attribute is removed), the query might stop auto-refreshing.
- Type a Description (optional).
- 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, refer to Metric rules.
Note
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.
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.
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.
In Select which employees you want to include in the query, add filters to narrow down the employees in scope for your report. Don’t remove the predefined “Is Active” filter. For more details about filter and metric options, refer to Filters. If you notice a warning or error here, it's because one of your attributes is missing from your organizational data or is of low quality.
Under Select which employee attributes you want to include in the query, add up to 14 organizational attributes, including the required Organization and HireDate attributes, and the optional LevelDesignation attributes. Once the query runs, you can use these attributes to group and filter the reports.
Important
This PowerBI 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 that help your template, 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.
Under Select which spotlight attributes you want to include in the query, add at least one and up to five attributes to use as a legend for insights in the report. You’ll also be able to focus on a specific group of employees in the report. Insights for this group will be highlighted.
Under Select an attribute that indicates the employee’s engagement score, you can optionally select an attribute that represents how engaged employees are.
Select Run on the upper right side of the screen. The query might take a few minutes to run.
When your query results are ready, go to the Query results page and select the Power BI icon. Download the Power BI template and get the partition and query identifiers. You’ll need these identifiers later.
Link report to query
- Open the downloaded template.
- If you're prompted to select a program, select Power BI.
- When you're prompted by Power BI:
- Paste in the partition and query identifiers.
- Set the Minimum group size for data aggregation within this report's visualizations in accordance with your company's policy for viewing Viva Insights data.
- Select Load to import the query results into Power BI.
- If prompted by Power BI, sign in using your organizational account. Power BI then loads and prepares the data. For large files, this process might take a few minutes.
Important
You need to sign in to Power BI with the same account you use to access Viva Insights. If available, select Organizational account from the left. You might have to sign in more than once.
Report settings
After the Manager effectiveness report is set up and populated with Viva Insights data in Power BI, map values as prompted, which are listed below.
| Value | Prompt |
|---|---|
| Individual contributor | Select the attribute values that identify employees as individual contributors who do not manage people within your organization |
| Manager indicator | Select the attribute values that identify managers who manage people within your organization, such as Mgr and Mgr+. |
After this initial prompt, you can then select Settings at top right of any page to view and change the following parameters:
| Setting | Description |
|---|---|
| Select the time period for the report | Select the time period for which you want to view data in the report. |
| Select an attribute to group data by | Select the primary group-by attribute shown in all the reports. You can change this attribute at any time and all report pages will show group values by the new attribute. |
| Select optional report filter | Select the organizational attribute and values you want to filter the employees in the report. |
| Exclusions | Use the check boxes to:
|
| Select the preferred language for your report – | Change the language for your report. |
About this report
The report contains one report page per theme, and each report page asks a related business question. The following section:
- Lists the report pages that fall under each theme and describes which data they contain.
- Describes the report’s Behavioral trends and Take action pages.
Manager capacity
Do managers have enough time for their employees?
Discover the weekly average number of hours that managers spent collaborating with people in the company, divided into groups and types of communication (meetings, emails, chats, and calls). Also view the average percentage of collaboration time that managers spent with direct reports as compared to others in the organization.
Coach
Are employees receiving sufficient coaching time with their manager?
Analyze managers’ behavior in scheduling 1:1 time with their direct reports by groups. Metrics include monthly average number of minutes in 1:1 meetings with direct reports, percentage of employees who receive a different number of 1:1 hours with their manager, and the average frequency of 1:1 time (weekly, monthly, or quarterly).
Empower
Are managers balancing oversight with employee autonomy?
View the percentage of employees whose managers co-attend their meetings and might be micromanaging them as direct reports. You can also see weekly average number of hours that managers co-attended meetings and spent in 1:1 meetings with their direct reports.
Connect
How well-connected are managers and do they leverage their network to help build connections for their employees?
Find out the internal network size distribution of managers as compared to the full organizational population, calling out the share of managers who are among the top 25% most connected employees in the company. Also view the average internal network size of managers as compared to individual contributors broken out by group.
Model
Are managers modeling good work-life balance habits?
View the distribution of managers by average weekly time spent in after-hours collaboration, calling out the share of managers spending more than five hours per week in collaboration outside of their set working hours. You can also see the difference in average after-hours collaboration hours for managers and individual contributors, broken out by group.
Behavioral trends
How are manager behaviors evolving?
Understand trends for key leading indicator metrics for managers, including metrics about coaching and empowerment, network connections, and after-hours work habits.
Take action
How can manager effectiveness be improved?
Review opportunity areas with related best practices and recommendations and links to related articles about ways to help your managers improve in each area.
Glossary
The Glossary describes metrics used in the report pages.
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.