title: Using business intelligence for efficient inter-facility patient transfer.
abstract: In the context of inter-facility patient transfer, a transfer operator must be able to objectively identify a destination which meets the needs of a patient, while keeping in mind each facility's limitations. We propose a solution which uses Business Intelligence (BI) techniques to analyze data related to healthcare infrastructure and services, and provides a web based system to identify optimal destination(s). The proposed inter-facility transfer system uses a single data warehouse with an Online Analytical Processing (OLAP) cube built on top that supplies analytical data to multiple reports embedded in web pages. The data visualization tool includes map based navigation of the health authority as well as an interactive filtering mechanism which finds facilities meeting the selected criteria. The data visualization is backed by an intuitive data entry web form which safely constrains the data, ensuring consistency and a single version of truth. The overall time required to identify the destination for inter-facility transfers is reduced from hours to a few minutes with this interactive solution.
authors: University of Northern British Columbia.
authors: Waqar
authors: W
authors: Haque
authors: Northern Health Authority.
authors: Beth Ann
authors: BA
authors: Derksen
authors: University of Northern British Columbia.
authors: Devin
authors: D
authors: Calado
authors: University of Northern British Columbia.
authors: Lee
authors: L
authors: Foster
mesh_terms: D002170:Canada; D003628:Database Management Systems / Q000458:organization & administration; D016208:Databases, Factual; D057286:Electronic Health Records / Q000458:organization & administration*; D006751:Hospital Information Systems / Q000458:organization & administration*; D020407:Internet / Q000458:organization & administration; D008498:Medical Record Linkage / Q000379:methods; D017146:Models, Organizational; D010360:Patient Transfer / Q000379:methods / Q000458:organization & administration*; D012984:Software; D014584:User-Computer Interface; D057188:Workflow