Clear dashboards for the IC team during the Corona crisis
UMC Utrecht
- Customer case
- Data Engineering
- Data Analytics
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':
You might find this interesting too:
The COVID-19 Violence Tracker
The outbreak of the corona pandemic in early 2020 has turned the world upside down. In addition to countless infections, hospitalisations and deaths, we also saw an outbreak of violence in many countries. Citizens took to the streets, sometimes violently, to protest against the measures taken, but domestic violence also increased in many places and fear and frustration played a role in racism.
Data Engineering
Deliver reliable and meaningful data to everyone from a solid, scalable infrastructure.
A well-organised data infrastructure
FysioHolland is an umbrella organisation for physiotherapists in the Netherlands. A central service team relieves therapists of additional work, so that they can mainly focus on providing the best care. In addition to organic growth, FysioHolland is connecting new practices to the organisation. Each of these has its own systems, work processes and treatment codes. This has made FysioHolland's data management large and complex.
