Clear dashboards for the IC team during the Corona crisis

UMC Utrecht

Customer case
Data Analytics
Data projects
Dashboarding

René de Boer

CEO

3 min

28 Apr 2020

In times of the coronavirus (COVID-19), a good overview of the patients in the scaled-up intensive care of the Utrecht medical centre is vital. Employees must be able to view patient characteristics, the most current lab readings and the course of patients' vital signs at a glance. In addition, up-to-date insight into the bed occupancy per department and the capacity of the nursing staff is required. We immediately got started to provide the necessary insights for UMC Utrecht. As a way of also contributing in these times of crisis, we offered our hours free of charge.

Our approach

UMC Utrecht set up a team consisting of a Data Manager, a BI specialist and several consultants. Our Data Engineers started by making the data available directly from the live sources.

UMC Utrecht's usual reporting tool makes it difficult to combine real-time information from different sources into one overview. That's why our Data Analysts used the Power BI data visualisation tool to integrate information from different sources and make real-time dashboards available.

The dashboards had to match the existing reports as much as possible. This allows the Crisis Team and IC staff to interpret the information quickly and intuitively.

UMC Utrecht was closely involved in every step of the development of the dashboards. This was essential to visualise the necessary insights in one week.

The result

The first dashboard that we produced provides an up-to-date overview of patients' health progress in the temporary IC at any time of the day.

Information from various sources has been combined in one clear overview. This makes it easy to see an overall picture for each patient:

An anonymised example of a dashboard with information about a patient in the ICU

The second dashboard provides insight into the current bed occupancy and the capacity of the nursing staff. The number of COVID-19 patients can be monitored by dividing the bed occupancy into

A part of the dashboard with the bed occupancy per department and the available capacity

Both dashboards have been exceptionally well received and are being used to help the intensive care team make the right decisions.

Want to know more?

René will be happy to talk to you about what we can do for you and your organisation as a data partner.

René de Boer

CEO+31(0)20 308 43 90 +31(0)6 14 30 32 62 rene.deboer@digital-power.com

Schedule an online meeting

Receive data insights, use cases and behind-the-scenes peeks once a month?

You might find this interesting too:

Optimisation of marketing activities through an integrated dashboard

Valk Digital, an internet company, aimed to adopt a more data-driven approach. The marketing team was already discussing all the data weekly using an Excel spreadsheet, but due to manual data input, it was time-consuming and more likely to fail. There was a need for an automated, future-proof approach based on reliable data.

Enhanced customer journey through process mining

The Municipality of The Hague was seeking a partner to assist them with their web analysis. In doing so, they had a central goal: to investigate the performance of their future new website and identify opportunities for further optimisation. They enlisted our help to establish and execute the process.

Lean Six Sigma project for optimisation of change management process

A Dutch telecom provider sought to examine and enhance their change management process using Lean Six Sigma. The objective was to maximise successful changes in hardware and software, evaluate risks, inform customers, and conduct assessments. The telco aimed to strengthen operational stability, streamline network and IT maintenance, foster innovation, and optimise service delivery.

Insights into market dynamics for a stronger competitive position

FrieslandCampina Global facilitates local teams in Europe, Asia, and Africa. They want to gain a better understanding of the market and provide the teams with new insights. The goals are to strengthen their competitive position and to identify new opportunities for expansion.

Evaluating brand alignment website with user perception

In October 2022 we launched our new website, in a fresh design style. We asked our partner Kaliber to update our branding and website with a design that fits our brand values. After the website went live, we wanted to know if they succeeded at this. Therefore, our own research consultants designed and conducted a research study to evaluate the effectiveness of the new design in conveying our intended brand values and message.

Comprehensive customer data overview through data warehouse

One of the largest professional service providers in the Netherlands aims to achieve a comprehensive overview of their customer data. They wanted to build a data warehouse or Customer Data Platform (CDP) for this purpose and asked for our help.

Future-proof migration to GA4

From 1 July 2024, it will no longer be possible to process data in Universal Analytics 360 (hereinafter: UA360). Wehkamp collected data in UA360 and was keen to be prepared in time for the migration. In addition, they wanted to collect at least 1 year of historical data for UA360's sunset. This allowed Wehkamp to compare the data in UA360 and in GA4. A key desire was to migrate the measurements as-is.