Introduction

Completed

The Ways of working assessment dashboard in Power BI uses a Power Business Intelligence (BI) template that's populated with Viva Insights through Workplace Analytics data. You use this behavioral data to gain insights into how employees collaborate in an organization. This dashboard directionally highlights collaboration patterns for different levels and groups, offering a starting point for identifying opportunities to streamline collaboration and improve the employee experience.

Imagine you are an HR people analytics manager. Your Chief Human Resources Officer (CHRO) is overseeing some initiatives designed to streamline ways of working, reduce burnout risk and boost manager effectiveness. The initiatives will require continuously piloting interventions, measuring their impact, and refining execution as they roll out across the company. To date, information about your company's working styles has come primarily from employee surveys, which, while valuable, are subject to completion bias and not conducive to tracking real-time change.

To bridge that gap with objective, dynamic metrics, you set up the Ways of working assessment template and dashboard – providing your CHRO with a data-driven baseline about employee working patterns and manager practices, which enables the leadership team to identify opportunities and measure the impact of their initiatives.

Learning objectives

In this module, you'll learn to:

  • Explain what the Ways of working assessment dashboard in Power BI is, and why it provides an important perspective.
  • Use the Query designer template to run the queries, load the data, and select your settings.
  • Interpret the results from multiple reports in the dashboard.

Prerequisites

  • Familiarity with the Workplace Analytics data sources in Viva Insights
  • Basic knowledge of Microsoft Power BI software
  • Basic knowledge of the Query designer and query structure