Clear dashboards for the IC team during the Corona crisis
UMC Utrecht
- Customer case
- Data Engineering
- Data Analytics
- Data projects


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:

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

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.
Receive data insights, use cases and behind-the-scenes peeks once a month?
Sign up for our email list and stay 'up to data':