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
Open Power BI in the Service.
In the search bar, search for Return to the Workplace – Leadership.
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.
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.
Review the phases that facilities are in, the number of facilities, new cases, new fatal cases, and the reproductive number.
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.
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.
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.
Filter on a region
When you want to drill down on certain facility locations, you can filter on them based on country/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.
In this area, you can find employees average sentiment, reproductive numbers, facilities, and current phases.
The checklist shows the steps needed to move facilities through phases.
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.
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.
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 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.
When you hover over the transition part of the ribbon chart, tooltips give you quick insights into the numbers.
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:
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.
USAFACTS (cases/deaths, population US only): USA Facts, CC BY 4.0 (https://creativecommons.org/licenses/by-sa/4.0/), modified by Microsoft
Bing COVID Tracker (cases/deaths for China (mainland), Taiwan, Hong Kong SAR, and Macao SAR: https://github.com/microsoft/Bing-COVID-19-Data
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
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.
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.