Use the Location Readiness dashboard

This article is for executive leaders who use the Power BI dashboard to analyze data to help get their employees back to their office locations using the Return to the Workplace solution.

How to view the Location Readiness dashboard

  1. Open Power BI in the Service.

  2. In the search bar, search for Return to the Workplace – Leadership.

    Search for dashboard.

System at a glance

The System at a Glance tab provides visibility into key metrics to monitor virus spread and facility status.

The key metrics are the number of COVID-19 new cases per day, fatal cases per day, 14 day moving average per one hundred thousand population and associated risk level, 14 day moving average fatal cases per million population, reproductive number.

Users can switch between two different views in terms of virus metrics: Worldwide & United States. Virus metrics for worldwide view are shown on a country level and on a state/county level for the United States.

System at a Glance.

A map highlights the locations of facilities, along with the number of facilities that are in a certain phase. Hovering over a facility gives you insights into the virus spread at that location.

Important statistics are provided at the top, including the number of facilities, new cases, new fatal cases, and the reproductive number.

System at a Glance 2.

Key metrics

Phases

Review the phases that facilities are in, the number of facilities, new cases, new fatal cases, and the reproductive number.

System at Glance phases.

Confirmed COVID cases

Information is shown about the number of cases for the last reporting day, 14 day moving average in absolute numbers and per population with the associated risk level, daily trend, and the total number of cases and per population.

System at a Glance cases.

Fatal COVID cases

The data on this tab shows information for COVID-19 cases with fatalities, giving you easy access to information about new fatal cases and total fatal cases in absolute terms and per population, and daily trend.

System at a Glance fatal COVID cases.

Effective Reproductive Number

Effective Reproductive Number is a key measure of how fast the virus is growing or decreasing, showing the average number of people who are infected.

System at a Glance reproductive number.

Filter on a region

When you want to drill down on certain facility locations, you can filter on them based on country/region.

System at a Glance filter by region.

Facility at a Glance

Different from the overall view of System at a Glance, the Facility at a Glance tab lets you drill down to each facility and track details about facility open readiness, employee sentiment, and employee attestation. It helps executive leaders to monitor all kinds of key metrics and determine the facility's opening phase.

Facility view.

Key metrics

Phases/Readiness

In this area, you can find employees average sentiment, reproductive numbers, facilities, and current phases.

Phase readiness.

Readiness Checklist

The checklist shows the steps needed to move facilities through phases.

Readiness Checklist.

Occupancy

The Occupancy section provides metrics regarding facility capacity and usage, such as:

  • Facility’s total capacity, and current capacity based on reopening phase.
  • Number of bookings and visits for the most recent day and daily average for the last seven days.
  • Two charts, that can be filtered by date range:
    • Number of bookings and the current capacity.
    • Average daily occupancy, shown as a black bar. Capacity is represented by the green zone. Facilities with black bars in the red zone are over-capacity.

Readiness Checklist Occupancy.

Employee Activity

The Employee Activity tab provides an overall time-series daily view for employee sentiment and daily passes generated for employees and guests. You can check every day to see where numbers increased or were lower compared to previous days.

Employee Activity.

Tools

Throughout the report you can use numerous tools like sliders, date filters, and bookmarks. The visualizations include bar and column charts, cards, gauge charts, maps, and more.

Slicer

Slicer helps you quickly "slice and dice" the data, focusing only on data points you're interested in. You can use the country or state slicer to select the country and state you're interested in. This slicer supports functions like multiple selections, hierarchy category selections, search, and clean selections.

Slicer.

Tooltip

When you hover over the transition part of the ribbon chart, tooltips give you quick insights into the numbers.

Tooltip.

Data sources

The dashboard consists of data from the model-driven app and the canvas app, but also consists of external data. The following data sources are used:

  1. WHO (cases/deaths): https://covid19.who.int/

    This is an adaptation of an original work: Microsoft-Covid-19 Return to the Workplace/Return to School Free Templates. Adapted from Covid-19-Global Data: World Health Organization(WHO); 2021-22. License: CC BY-NC-SA 3.0 IGO.

  2. USAFACTS (cases/deaths, population US only): USA Facts, CC BY 4.0 (https://creativecommons.org/licenses/by-sa/4.0/), modified by Microsoft

  3. Bing COVID Tracker (cases/deaths for China (mainland), Taiwan, Hong Kong SAR, and Macao SAR: https://github.com/microsoft/Bing-COVID-19-Data

  4. Reproductive factor estimates: https://epiforecasts.io/covid/posts/global/

    EpiForecasts, CC BY 4.0 (https://creativecommons.org/licenses/by-sa/4.0/), modified by Microsoft

  5. Global Population data: UN department of economic and social affairs. United Nations, Department of Economic and Social Affairs, Population Division (2019). World Population Prospects 2019, Online Edition. Rev. 1.

  6. NYTimes (Covid-19 cases and deaths by country). NY Times-Covid-19 Data, (https://github.com/nytimes/covid-19-data/blob/master/LICENSE), modified by Microsoft

Feedback about the solution

To provide feedback about the Return to the Workplace solution, visit https://aka.ms/rtw-community.