The University Medical Centre in Utrecht is a highly regarded hospital and medical research facility in the center of The Netherlands. Due to their central location and their specialized staff, the hospital is also one of the busiest trauma centers in the country. On an annual basis, thousands of trauma patients are admitted through the emergency department for often multi-disciplinary treatment of their injuries. Other than providing the best possible treatment and care for these patients, the UMC Utrecht invests in detailed scientific research and performance management within the trauma care chain. With Jedox, Celcus has now provided them with a powerful tool to streamline their data collection, reporting and analysis processes.
Typically, a hospital’s information systems are not suited for the detailed data collection and analysis of specific patient populations and only provide the means for registration and storage of basic logistics and patient data. These are stored as both structured data (e.g. emergency department visit log, lab results, admission times, etc.) and unstructured data (e.g. emergency room reports, treatment reports, diagnostic reports, etc.). Furthermore, in order to create insight into the full trauma care chain, the integration of third party data (e.g. pre-hospital ambulance data from emergency services) is also required. Therefore, the detailed collection, often done manually through spreadsheets or local standalone relational databases, and analysis is time-consuming and cumbersome.
By placing Jedox at the center of these processes, collection and analysis of trauma data will be streamlined and integrated. By connecting to the relational data sources (internal and third party) ETL can automatically collect and load structured data, while write back functionality still provides users with the opportunity to collect and register the unstructured data directly in the multidimensional cubes. Meanwhile, data validation and a structured workflow guides the detailed registration process from identifying patients, to loading or registering data, and the monitoring and approval by the responsible medical specialist. Finally, standardized dashboards and dynamic reports through web and flexible ad-hoc data discovery through the Excel add-in provide analysts with the means to perform any kind of required (statistical) data analysis.