Journal of Pathology Informatics

TECHNICAL NOTE
Year
: 2019  |  Volume : 10  |  Issue : 1  |  Page : 3-

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


Jennifer S Woo, Peter Suslow, Russell Thorsen, Rosaline Ma, Sara Bakhtary, Morvarid Moayeri, Ashok Nambiar 
 Department of Laboratory Medicine, University of California, San Francisco, CA, USA

Correspondence Address:
Dr. Ashok Nambiar
University of California, San Francisco, 505 Parnassus Avenue, San Francisco, CA
USA

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.


How to cite this article:
Woo JS, Suslow P, Thorsen R, Ma R, Bakhtary S, Moayeri M, Nambiar A. Development and implementation of real-time web-based dashboards in a multisite transfusion service.J Pathol Inform 2019;10:3-3


How to cite this URL:
Woo JS, Suslow P, Thorsen R, Ma R, Bakhtary S, Moayeri M, Nambiar A. Development and implementation of real-time web-based dashboards in a multisite transfusion service. J Pathol Inform [serial online] 2019 [cited 2019 Apr 25 ];10:3-3
Available from: http://www.jpathinformatics.org/article.asp?issn=2153-3539;year=2019;volume=10;issue=1;spage=3;epage=3;aulast=Woo;type=0