Development and implementation of real-time web-based dashboards in a multisite transfusion service

Abstract

Background: In hospital transfusion services, visualization of blood product inventory in the form of web-based dashboards has the potential to improve the workflow and efficiency of blood product inventory management. While off-the-shelf “business intelligence” solutions by external vendors may offer the ability to display and analyze blood bank inventory data, laboratories may lack resources to readily access this technology. Using in-house talent, our transfusion service developed real-time, web-based dashboards to replace manual processes for managing both blood product inventory and cooler tracking at two large academic hospital blood banks. Methods: Dashboards were developed using Hypertext Markup Language, Cascading Style Sheets, and Hypertext Preprocessor scripting/programming languages. Data are extracted in real time from Sunquest (v7.3) Laboratory Information Systems Database (InterSystems Cache) and are refreshed every 2 min. Data are hosted internally by our institution's web servers and are accessed on a webpage via Microsoft Group Policy shortcuts. Results: Dashboards were designed and implemented to provide a fully customizable, dynamic, and secure method of displaying blood product inventory and blood product cooler status. Transfusion service staff utilized dashboard data to maintain adequate blood product supply, modify blood product replacement orders to prevent excess inventory, and transfer short-dated blood products between our facilities to minimize wastage. Conclusions: Dashboard technology can be readily implemented at hospital transfusion services with minimal capital expenditure. The implementation of real-time web-based dashboards for blood product inventory and cooler management at our centers facilitated on-demand blood product monitoring and replaced a tedious, manual process with a user-friendly and intuitive electronic tool.

Keywords

• Blood bank
• dashboard
• data visualization
• inventory management
• laboratory information system