Business Intelligence and its Applications in the Public Healthcare System

Puangrat JINPON; Mullica JAROENSUTASINEE; Krisanadej JAROENSUTASINEE

Authors

Puangrat JINPON Centre of Excellence for Ecoinformatics, School of Science, Walailak University, Nakhon Si Thammarat 80161, Thailand
Mullica JAROENSUTASINEE Centre of Excellence for Ecoinformatics, School of Science, Walailak University, Nakhon Si Thammarat 80161
Krisanadej JAROENSUTASINEE Centre of Excellence for Ecoinformatics, School of Science, Walailak University, Nakhon Si Thammarat 80161

Keywords:

Business intelligence, dashboard, decision support system, public health, OLAP, data warehouse

Abstract

Business intelligence (BI) has been known as a popular tool in business management and decision support systems. BI helps to transform raw data into smart information. There are many BI tools such as extract transform and load (ETL), data warehouse, online analytical processing (OLAP), and dashboard. BI tools are usually used in public health fields for financial and administrative purposes. Now BI is also helping public health organisations with diagnosing and treating patients with long term conditions and evaluating alternative treatments based on outcomes analyses. BI is composed of four steps: integration, storage, analysis, and presentation. BI usually uses a dashboard in the presentation step to deliver the information to end users. The development an effective dashboard is still a challenge.

Graphical abstract

Downloads

Download data is not yet available.

Metrics

Metrics Loading ...

References

Q Yi, RE Hoskins, EA Hillringhouse, SS Sorensen, MW Oberle, SS Fuller and JC Wallace. Integrating open-source technologies to build low-cost information systems for improved access to public health data. Int. J. Health Geogr. 2008; 7, 29.

C Sacu and M Spruit. BIDM: The Business Intelligence Development Model. Technical Report, Utrecht, Netherlands. 2010.

M Golfarelli, S Rizzi and I Cella. Beyond data warehousing: what’s next in business intelligence? In: Proceedings of the 7th ACM international workshop on Data warehousing and OLAP, Washington, USA. 2004, p. 1-6.

How business intelligence is making healthcare smarter, Available at: http://www.connectingforhealth.nhs.uk/newsroom/worldview/protti10, accessed June 2009.

X Feng, G Richards and B Raheemi. The road to decision-centric business intelligence. In: Proceedings of the 2nd International Conference on Business Intelligence and Financial Engineering, Beijing, China. 2009, p. 514-8.

L Wu, G Barash and C Bartolini. A Service-oriented architecture for business intelligence. In: Proceedings of IEEE International Conference on Service-Oriented Computing and Applications, Newport Beach, California, USA. 2007, p. 279-85.

Y Bao and X Qian. Research of business intelligence which based upon Web. E-Business and Information System Security. In: Proceedings of the 9th EBISS International Conference, Wuhan, China. 2009, p. 1-4.

LV Subramaniam, TA Faruquie, S Ikbal, S Godbole and MK Mohania. Business intelligence from voice of customer. In: Proceedings of the 25th IEEE International Conference, Shanghai, China. 2009, p. 1391-402.

M Seah, MH Hsieh and P Weng. A case analysis of Savecom: The role of indigenous leadership in implementing a business intelligence system. Int. J. Inform. Manage. 2010; 30, 368-373.

BusinessDictionary.com, Available at: http://www.businessdictionary.com, accessed June 2010.

Enterprise Business Intelligence (BI) Tool Standards and Guidelines, Available at: http://www.utahta.wikispaces.net/file/view/Enterprise+BI+Standards+and+Guidelines+7.20.09.pdf, accessed June 2010.

Using information technology to support knowledge conversion processes, Available at: http://InformationR.net/ir/7-1/paper118. html, accessed June 2010.

W Chung, H Chen and JF Nunamaker. Business intelligence explorer: a knowledge map framework for discovering business intelligence on the Web. In: Proceedings of the 36th Hawaii International Conference on System Sciences, Big Island, Hawaii, USA. 2003, p. 1-10.

A Brief History of Decision Support Systems, Available at: http://DSSResources. COM/history/dsshistory.html, accessed June 2010.

JY Wu. Computational intelligence-based intelligent business intelligence system: concept and framework. In: Proceedings of the 2nd International Conference on Computer and Network Technology (ICCNT), Bangkok, Thailand. 2010, p. 334-8.

SAP Business Suite, Available at: http://www.sap.com/solutions/business-suite /index.epx, accessed August 2010.

Cognos Business Intelligence and Financial Performance Management, Available at: http://www-01.ibm.com/software/data/ cognos/, accessed August 2010.

Oracle and Hyperion, Available at: http://www.oracle.com/hyperion/index.html, accessed August 2010.

Business Intelligence, Available at: http://www.sas.com/technologies/bi/index.html, accessed August 2010.

Business Intelligence Products and Services, Available at: http://www.microstrategy.com/ Products-Services/, accessed August 2010.

What is business intelligence? Available at: http://dssresources.com/faq/index.php?action=artikel&id=4, accessed August 2010.

WF Cody, JT Kreulen, V Krishna and WS Spangler. The integration of business intelligence and knowledge management. IBM Syst. J. 2002; 41, 697-713.

D Krneta, D Radosav and B Radulovic. Realization business intelligence in commerce using Microsoft business intelligence. In: Proceedings of the 6th International Symposium on Intelligent Systems and Informatics, Subotica, Serbia. 2008, p. 1-6.

LM Prevedello, KP Andriole, R Hanson, P Kelly and R Khorasani. Business intelligence tools for radiology: creating a prototype model using open-source tools. J. Digit. Imaging. 2008; 23, 133-41.

What Are Business Intelligence Tools? Available at: http://www.wisegeek.com/ what-are-business-intelligence-tools.htm, accessed July 2010.

Business Intelligence Overview, Available at: http://www.bitpipe.com/bi/bi_overview. jsp, accessed August 2010.

Solution Business Intelligence (BI), Available at: http://www.tripodsoftcs.com/ solution/bi/BI.htm, accessed August 2010.

Y Bédard, P Gosselin, S Rivest, M Proulx, M Nadeau, G Lebel and M Gagnon. Integrating GIS components with knowledge discovery technology for environmental health decision support. Int. J. Med. Inform. 2003; 70, 79-94.

X Zhou, S Chen, B Liu, R Zhang, Y Wang, P Li, Y Guo, H Zhang, Z Gao and X Yan. Development of traditional Chinese medicine clinical data warehouse for medical knowledge discovery and decision support. Artif. Intell. Med. 2010; 48, 139-52.

K Canfield, V Ramesh and S Quirologico. Scenario-based analysis of an agent-based architecture for health care decision support systems. System Sciences volume IV. In: Proceedings of the 31st Hawaii International Conference, Kohala Coast, USA. 1998, p. 523-32.

S Tsumoto and S Hirano. Internet-based decision support: towards E-hospital. In: Proceedings of the 27th Annual International Computer Software and Applications Conference, Dallas, Texas, USA. 2003, p. 595.

M Wang, C Lau, FA Matsen and Y Kim. Personal health information management system and its application in referral management. IEEE T. Inf. Technol. B. 2004; 8, 287-97.

B Collins and M Wagner. Early experiences in using computerised patient record data for monitoring charting compliance, supporting quality initiatives and assisting with accurate charging at Allina Hospitals & Clinics. Int J. Med. Inform. 2005; 74, 917-25.

A Hochlehnert, A Richter, H Bludau, C Bieber, K Blumenstiel, K Mueller, S Wilke and W Eich. A computer-based information-tool for chronic pain patients Computerised information to support the process of shared decision-making. Patient Educ. Couns. 2006; 61, 92–8.

WM Omar and A Taleb-Bendiab. Service oriented architecture for E-HEALTH support services based on grid computing overlay. In: IEEE International Conference on Services Computing, Chicago, USA. 2006, p. 135-42.

N Lavrac, M Bohanec, A Pur, B Cestnik, M Debeljak and A Kobler. Data mining and visualisation for decision support and modeling of public health-care resources. J. Biomed. Inform. 2007; 40, 438-47.

OO Olugbara, MO Adigun, SO Ojo and P Mudali. Utility grid computing and body area network as enabler for ubiquitous rural e-healthcare service provisioning. In: Proceedings of the 9th IEEE International Conference, Taipei, Taiwan. 2007, p. 202-7.

MD Aronson, N Neeman, A Carbo, AV Tess, JJ Yang, P Folcarelli, KF Sands and ML Zeidel. A model for quality improvement programs in academic departments of medicine. Am. J. Med. 2008; 121, 922-9.

EC Conley, DR Owens, SL Luzio, M Subramanian, AS Ali, A Hardisty and O Rana. Simultaneous trend analysis for evaluating outcomes in patient-centred health monitoring services. Health Care Management Science volume XI. In: Proceedings of IMA Conference, London, UK. 2008, p. 152-66.

B Keogh. Health Informatics Review Report. Annual NHS Connecting for Health Clinicians Conference, Central Hall Westminster. 2008, p. 5.

JA Kim, I Cho and Y Kim. CDSS (Clinical Decision Support System) architecture in Korea. In: Proceedings of ICHIT International Conference, Daejeon, Korea. 2008, p. 700-3.

N Botts, B Thoms, A Noamani and TA Horan. Cloud computing architectures for the underserved: public health cyber-infrastructures through a network of health ATMs. In: Proceedings of the 43rd Hawaii International Conference, Honolulu, USA. 2010, p. 1-10.

ML Popovich, JM Henderson and J Stinn. Information technology in the age of emergency public health response. IEEE Eng. Med. Biol. 2002; 21, 48-55.

DJ Berndt, AR Hevner and J Studnicki. Bioterrorism surveillance with real-time data warehousing. Lect. Notes Comput. SC. 2003; 3073, 322-35.

EB Sloane, E Rosow and J Adam. Strategic graphic dashboards for improved technology management decisions. In: Proceedings of the 25th Annual International Conference of the IEEE EMBS, Cancun, Mexico. 2003, p. 3634-5.

K Coulombe and E Rosow. Clinical bed management and a patient-focused bed management dashboard. Nurs. Leader 2004; 2, 39-41.

A Bei, SD Luca, G Ruscitti and D Salamon. Health-mining: a disease management support service based on data mining and rule extraction. In: Proceedings of the IEEE 27th Annual Conference, Shanghai, China. 2005, p. 5466-70.

E Sloane, E Rosow, J Adam and D Shine. Clinical engineering department strategic graphical dashboard to enhance maintenance planning and asset management. In: Proceedings of the IEEE 27th Annual Conference, Shanghai, China. 2005, p. 7107-10.

EK Neumann and D Quan. Biodash: A semantic web dashboard for drug development. Pac. Symp. Biocomput. 2006; 11, 176-87.

ML Popovich and T Watkins. Applied medical & care computnetics to public health disease surveillance and management: leveraging external data sources - a key to public health preparedness. St Heal T. 2006; 3, 151-61.

CS Li. Survey of Early Warning Systems for Environmental and Public Health Applications. In: Life Science Data Mining. World Scientific Publishing, 2006, p. 1-15.

J Zhang, J Gong, J Zhu, B Xu and X Wu. A GI services grid for public health management and disease control. In: Proceedings of the IGARSS '05 IEEE International, Beijing, China. 2005, p. 627-30.

MN Podgornik, A Postema, R English, KB Uhde, S Bloom, P Hicks, P McMurray, J Copeland, L Brammer, WW Thompson, JS Bresee and JI Tokars. The influenza data summary: a prototype application for visualising national influenza activity. In: D. Zeng et al. (ed). BioSurveillance. LNCS 4506, 2007, p. 159-68.

CD Corley and AR Mikler. A computational framework to study public health epidemiology. Systems Biology and Intelligent Computing. In: Proceedings of International Joint Conference on Bioinformatics, Systems Biology and Intelligent Computing, Shanghai, China. 2009, p. 360-3.

H Liang, Y Xue and BA Berger. Web-based intervention support system for health promotion. Decis. Support Syst. 2006; 42, 435-49.

T Gao, T Massey, L Selavo, M Welsh and M Sarrafzadeh. Participatory user centered design techniques for a large scale ad-hoc health information system. In: Proceedings of the 1st ACM SIGMOBILE international workshop on Systems and networking support for healthcare and assisted living environments, San Juan, Puerto Rico, USA. 2007, p. 43-8.

JL Mathe, A Ledeczi, A Nadas, J Sztipanovits, JB Martin, LM Weavind, A Miller, P Miller and DJ Maron. A model-integrated, guideline-driven, clinical decision-support system. IEEE Software. 2009; 26, 54-61.

H Masum and PA Singer. A visual dashboard for moving health technologies from “lab to village”. J. Med. Internet Res. 2007; 9, e32.

R Farcot and T Kades. Digital dashboard technology visualise the possibilities. Decision support and analysis volume VII. In: Proceedings of the CBI/SCIP, Philadelphia, USA. 2004, p. 57-9.

SL Foldy, PA Biedrzycki, BK Baker, GR Swain, DS Howe, D Gieryn, EN Barthell and KR Pemble. The public health dashboard: a surveillance model for bioterrorism preparedness. J. Public Health Manag. Pract. 2004; 10, 234-40.

L Baskett, C Lerouge and MC Tremblay. Using the dashboard technology properly. Health Progress. 2008; 89, 16-23.

E Turban, D Leidner, E Mclean and J Wetherbe. Information Technology for Management: Transforming Organisations in the Digital Economy, 5th ed. Hoboken: John Wiley & Sons, 2006, p. 456-505.

What Is Dashboard Software and Why Is It Useful?, Available at: http://www. thefreelibrary.com/What+Is+Dashboard+Software+and+Why+Is+It+Useful%3f-a01074003385, accessed August 2010.

M Edwards and T Lippeveld. Decision support systems for improving the analytic capacity of decentralized routine health information systems in developing countries. In: Proceedings of the 37th Hawaii International Conference on System Sciences, Big Island, Hawaii, USA. 2004, p. 1-9.

E Sloane, E Rosow, J Adam and D Shine. JEDI - an executive dashboard and decision support system for lean global military medical resource and logistics management. In: Proceedings of the 28th IEEE EMBS Annual International Conference, New York City, USA. 2006, p. 5440-3.

Dashboards, Analysis Mind Share, and KPIs, Available at: http://www.rossmorrissey.com /uv/rossmorrissey_dashboards.pdf, accessed August 2010.

Contribution to Beyond GDP “Virtual Indicator Expo”, Available at: http://www. beyond-gdp.eu/download/bgdp-ve-seea.pdf, accessed August 2010.

Dashboard Design: Beyond Meters, Gauges, and Traffic Lights, Available at: http://www. bi-bestpractices.com/view-articles/4666, accessed August 2010.

L Harrington, E Hoffman, PM Allard, BJ Adams, P Hamilton, K Wright and V Cargo. Nursing research dashboard a tool for managing your nursing research program. J. Mnl. Nurse Leader. 2006; 4, 54-7.

RW Selby. Measurement-driven dashboards enable leading indicators for requirements and design of large-scale systems. In: Proceedings of the 11th IEEE International Symposium on Software Metrics, Como, Italy. 2005, p. 10-22.

New Hampshire’s Healthcare Dashboard 2009, Available at: http://www.nhpolicy.org/ reports/dashboard09final.pdf, accessed August 2010.

NSW Health System Performance Indicators August 2003, Available at: http://www. health.nsw.gov.au, accessed August 2010.