Use the Workplace Care Management dashboard

This article is for health and safety leads who use the Power BI dashboard to gain awareness of employee well-being, and effectively manage and track employee cases across their network of facilities and locations, by using the Return to the Workplace solution.

How to view the Workplace Care Management dashboard

  1. Open Power BI Desktop.

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

    Search for dashboard

Overview page

The Overview page is the default page of the dashboard that provides overall visibility into key metrics and trends related to employee cases. The key metrics include:

  • Total active cases: Number of active cases.

  • Days without new cases: Number of days since a new case hasn't been opened at a facility.

  • Average risk: Average case risk associated with a facility or group of facilities.

  • Average resolution time: Days needed to resolve cases.

  • Cases per case manager: Average number of active cases (in open, investigating, and monitoring phases) per case manager.

The interactive map displays the active cases by stage and location. The size of the bubble represents the number of cases. The case manager overview table contains information about the number of cases, average risk, and average resolution time in days.

System at a glance

Investigating page

The Investigating page provides a detailed view of active cases being investigated with a set of key metrics important for that stage. Key metrics include:

  • Cases being investigated: The number of cases being investigated.

  • Contacts reached: Number of employees that have been reached out of all employee cases under investigation.

  • Time to start investigating: Average time taken from opening a case to starting an investigation.

  • Time to reach a contact: Average time taken from opening a case to contacting an employee.

  • Cases per case manager: Average number of cases under investigation per case manager.

The interactive map displays the location of cases in the investigating stage. You can drill into the data by country, state, and facility. The size of the bubble represents the number of cases.

The case manager overview table contains information about case manager, number of cases, time to start investigating, and time to reach a contact.

System at a glance - cases

Monitoring page

The Monitoring page focuses on active cases that are in the monitoring stage. Key metrics include:

  • Cases being monitored: Number of cases being monitored.

  • Cases per case manager: Average number of cases in the monitoring phase per case manager.

  • Resolved cases: Total number of cases already resolved.

  • Avg resolution time (days): Average time taken for a case from being opened to resolved.

The interactive map displays the location of cases in the monitoring phase. You can drill into the data by country, state, and facility. The size of the bubble represents the number of cases. The case manager overview table contains information about case manager, number of cases, average resolution time, and variance from average.

System at a glance - COVID cases

Clusters page

The Clusters page helps health and safety leads view cases as clusters and assess whether there is an outbreak in a facility. The tab focuses on case contacts and links between active cases, identifying the root cause of the outbreak. It also provides a set of metrics and trends related to case contacts. These metrics include:

  • Case contacts per case: Average number of case contacts per active case.

  • % contacts evaluated: Percentage of case contacts whose evaluation is complete.

  • Average evaluation time: For evaluated case contacts, time taken to evaluate or process a case contact in days.

  • Average linked cases per case: The number of case contacts with an active case of their own per active case.

  • % evaluated within 24 hr: Percentage of case contacts that were evaluated or processed within 24 hours of identification.

Cluster nav map

Users can switch from a map to the table visual, where key metrics are displayed by facility.

Cluster nav table

Map displays active cases by facility. To view a cluster, select a facility on the map.

Cluster nav map facility selected

The clusters view provides information about case contacts and linked cases, and also relationships between active cases for the selected facility and date range. Relationships are visualized in the form of a network, where cases are represented as a circle, colored based on their stage. The thickness of the line displays the exposure score, which measures how close and frequent exposure has been between two cases.

Cluster network

You also can switch from a map view to a table view to see key metrics by case.

Cluster table

The following sets of metrics related to the selected facility are also displayed:

  • Total number of cases linked to a facility.

  • Total number of case contacts.

  • Number of standalone cases: Cases that are not linked to other cases in a facility.

  • Number of cases that are part of a cluster.

Slicers

Slicers help you quickly "slice and dice" the data, focusing only on data points you're interested in. You can filter all three pages by the case creation date and their groups of facilities and locations, down to the level of a single facility.

System at a glance - reproductive number

Give feedback about the solution

To provide feedback about the Return to the Workplace solution, go to the Return to the workplace community page.