Difference between revisions of "Journal:A benchmarking analysis of open-source business intelligence tools in healthcare environments"
Shawndouglas (talk | contribs) (Created stub. Saving and adding more.) |
Shawndouglas (talk | contribs) (Saving and adding more.) |
||
| Line 45: | Line 45: | ||
Besides the introduction, this article includes eight sections. The second section provides an approach to the background and related work, in which the concept of business intelligence is addressed and an introduction to the case study is presented. The third section is concerned with the application of BI tools in healthcare environments, followed by the requirements considered essential in these tools, in the section "Tool Requirements in Healthcare Environments." Thereafter, the next section addresses in more detail the tools selected; and the section "Business Intelligence Tools — Assessment Process" discusses our approach to the case study. Finally, the last sections correspond to the results, discussion, and conclusion. | Besides the introduction, this article includes eight sections. The second section provides an approach to the background and related work, in which the concept of business intelligence is addressed and an introduction to the case study is presented. The third section is concerned with the application of BI tools in healthcare environments, followed by the requirements considered essential in these tools, in the section "Tool Requirements in Healthcare Environments." Thereafter, the next section addresses in more detail the tools selected; and the section "Business Intelligence Tools — Assessment Process" discusses our approach to the case study. Finally, the last sections correspond to the results, discussion, and conclusion. | ||
==Background and related work== | |||
===Business intelligence=== | |||
Business intelligence (BI) is the transformation of [[information]] stored in knowledge, enabling us to provide adequate information to a particular user at the appropriate time in order to support the decision-making process in real time. Thus, BI integrates a set of tools and technologies that enables the collection, integration, analysis, and visualization of data. | |||
For the implementation of a BI platform, it is necessary to perform some intermediate steps that are common in the development of this type of software tool, such as the construction of a data warehouse (DW). In this case, the Kimball methodology was chosen in order to design as well as develop and deploy the DW.<ref name="CompletoDesign12">{{cite journal |title=Design and implementation of a data warehouse for benchmarking in clinical rehabilitation |journal=Procedia Technology |author=Completo, J.; Cruz, R.S.; Coheur, L.; Delgado, M. |volume=5 |pages=885–894 |year=2012 |doi=10.1016/j.protcy.2012.09.098}}</ref> Thus, some of these steps are considered crucial for the successful implementation of a BI system, such as: tasks planning and expected results; defining the architecture that aims to follow the BI system; the selection and installation of the most appropriate BI tool; building the data warehouse dimensional model; the extraction, transformation and loading (ETL) process; and, finally, the development of the BI application.<ref name="CompletoDesign12" /> | |||
Thus, in order to develop a BI application, initially, it is necessary to choose the software that is most appropriate for achieving the desired outcomes. Thereby, it is necessary to undertake an analysis of most of the software available and choose the one type that provides the necessary and desired resources.<ref name="MurainaHealthcare11" /><ref name="Côrte-RealAvalia10">{{cite web |url=https://run.unl.pt/bitstream/10362/7477/1/TEGI0269.pdf |format=PDF |title=Avaliação da Maturidade da Business Intelligence nas Organizações |author=Côrte-Real, N. |publisher=Universidade Nova de Lisboa |date=November 2010 |pages=104}}</ref><ref name="TeresoOpen11">{{cite journal |title=Open source business intelligence tools for SMEs |journal=Proceedings of the 6th Iberian Conference on Information Systems and Technologies |author=Tereso, M.; Bernardino, J. |volume=2011 |year=2011}}</ref> | |||
===Examples of application of BI tools in healthcare environments=== | |||
With the urgency of acquiring medical informatics applications, open-source software is receiving increased attention from the healthcare industry. For example, the open-source project [[Care2X]] — composed of a [[hospital information system]], practice management, a central data server, and a health exchange protocol — is under development in Europe. Care2X was developed in order to overcome integration problems in multiple incompatible network programs. It is possible to integrate almost any type of service, system, department, process, data, or communication of a [[hospital]]. Care2X supports the clinical workflow, incorporating diagnosis-related groups (DRG), as well as scheduling and electronic prescribing modules.<ref name="Care2X">{{cite web |url=http://www.care2x.org/ |title=Care2X: The Open Source Hospital Information System |publisher=Care2x Team |accessdate=17 May 2016}}</ref> | |||
[[openEHR]] corresponds to another case, which is sponsored by the openEHR Foundation. It promotes the "development of an open, interoperable health computing platform, of which the major component is clinically effective and interoperable [[electronic health record]]s (EHRs)."<ref name="openEHR">{{cite web |url=http://www.openehr.org/ |title=OpenEHR: An Open Domain-Driven Platform for Developing Flexible e-Health Systems |publisher=openEHR Foundation |accessdate=03 May 2016}}</ref> | |||
[[Canada Health Infoway]], established by Canadian federal and provincial grants, began an open-source initiative in 2005 to develop software that hospitals and developers could use to ensure the secure exchange of medical records of patients between various entities.<ref name="CHI" /> Thereby, these initiatives suggest that open-source is a viable way of developing applications in healthcare.<ref name="WelchElectronic07">{{cite journal |title=Electronic health records in four community physician practices: Impact on quality and cost of care |journal=JAMIA |author=Welch, W.P.; Bazarko, D.; Ritten, K. et al. |volume=14 |issue=3 |pages=320–8 |year=2007 |doi=10.1197/jamia.M2125 |pmid=17329734 |pmc=PMC2244874}}</ref><ref name="GouldeOpen06">{{cite web |url=http://www.chcf.org/publications/2006/03/open-source-software-a-primer-for-health-care-leaders |title=Open Source Software: A Primer for Health Care Leaders |work=iHealth Reports |author=Goulde, M.; Brown, E.; Rymer, J.; Hartzband, D. |publisher=Forrester Consulting |pages=31 |date=March 2006 |accessdate=03 May 2016}}</ref> | |||
==References== | ==References== | ||
Revision as of 22:30, 1 November 2016
| Full article title | A benchmarking analysis of open-source business intelligence tools in healthcare environments |
|---|---|
| Journal | Information |
| Author(s) | Brandão, Andreia; Pereira, Eliana; Esteves, Marisa; Portela, Filipe; Santos, Manuel F.; Abelha, António; Machado, José |
| Author affiliation(s) | University of Minho, Instituto Politécnico do Porto |
| Primary contact | Tel.: +351-967-562-540 |
| Editors | Susilo, Willy |
| Year published | 2016 |
| Volume and issue | 7 (4) |
| Page(s) | 57 |
| DOI | 10.3390/info7040057 |
| ISSN | 2078-2489 |
| Distribution license | Creative Commons Attribution 4.0 International |
| Website | http://www.mdpi.com/2078-2489/7/4/57/htm |
| Download | http://www.mdpi.com/2078-2489/7/4/57/pdf (PDF) |
 |
This article should not be considered complete until this message box has been removed. This is a work in progress. |
Abstract
In recent years, a wide range of business intelligence (BI) technologies have been applied to different areas in order to support the decision-making process. BI enables the extraction of knowledge from the data stored. The healthcare industry is no exception, and so BI applications have been under investigation across multiple units of different institutions. Thus, in this article, we intend to analyze some open-source/free BI tools on the market and their applicability in the clinical sphere, taking into consideration the general characteristics of the clinical environment. For this purpose, six BI tools were selected, analyzed, and tested in a practical environment. Then, a comparison metric and a ranking were defined for the tested applications in order to choose the one that best applies to the extraction of useful knowledge and clinical data in a healthcare environment. Finally, a pervasive BI platform was developed using a real case in order to prove the tool's viability.
Keywords: business intelligence; open-source; healthcare; benchmarking
Introduction
Increasingly, the healthcare sector is looking for computer applications to support the daily practice of health professionals. is particularly desirable in this sector as, besides being free, it has a source code that is fully available to users for viewing, reading, modification, and redistribution, without the restrictions of ownership of the product (unlike free software, which only allows its use without charge).
Open-source software differs fundamentally from an ownership model in terms of the development process and the product licenses. All open-source applications are licensed by an open-source license, which gives the user the right to use the software, access and modify the source-code, and redistribute the software for free. This type of software is very popular due to its many advantages, since it promises to accelerate the diffusion of information technology (IT) solutions in healthcare. Thereby, it can contribute to reduced development costs.[1][2]
One the other hand, the choice of a free license software in health and medical informatics is important because it determines the user’s rights and can influence the developers’ willingness to participate in a project, the quality of the product, and the willingness of users to adopt certain applications.[1][2]
In terms of costs, organizations can save on licensing fees and reduce expenditures on specific computer hardware. However, organizations need to welcome and train specialized collaborators in the adoption of open-source solutions. This type of situation has the hidden costs of highly skilled employees, implementation, maintenance, and a support process, which may lead to adopting proprietary solutions.[1][2]
The acquisition of a business intelligence (BI) tool and its implementation are quite advantageous for the health organization. Extending their use can have a positive global impact. However, the healthcare environment has some particularities that a BI solution should be prepared to answer. For example, the BI system could lead to resource optimization in various departments; it will improve the clinical condition of the patient through efficient diagnosis and the identification and application of the best practice protocols for treatment, among others.[3]
In order to help decision-makers make the best choices, a benchmarking study of BI tools focused on the healthcare environment was performed. After a thorough review of the literature, it was determined which tools were being used in this study. These tools were selected based on their good performance in several areas, such as management, healthcare, or retail.[4][5][6] Thus, the tools selected for this study were QlikView[7], Palo BI Suite[8], Jaspersoft BI[9], Tableau Public[10], SpagoBI[11], and Pentaho BI Suite.[12]
The analysis of this type of software emerged during a project that included the development of a BI platform in maternity care to visualize clinician and management indicators, as well as integrating data mining (DM) predictive models. All the tools were tested using real data provided by the Centro Hospital do Porto (CHP) and Centro Materno Infantil do Norte (CMIN). With this study, it is intended to select the BI tool that best suits the healthcare sector by using a practical case.
Besides the introduction, this article includes eight sections. The second section provides an approach to the background and related work, in which the concept of business intelligence is addressed and an introduction to the case study is presented. The third section is concerned with the application of BI tools in healthcare environments, followed by the requirements considered essential in these tools, in the section "Tool Requirements in Healthcare Environments." Thereafter, the next section addresses in more detail the tools selected; and the section "Business Intelligence Tools — Assessment Process" discusses our approach to the case study. Finally, the last sections correspond to the results, discussion, and conclusion.
Business intelligence
Business intelligence (BI) is the transformation of information stored in knowledge, enabling us to provide adequate information to a particular user at the appropriate time in order to support the decision-making process in real time. Thus, BI integrates a set of tools and technologies that enables the collection, integration, analysis, and visualization of data. For the implementation of a BI platform, it is necessary to perform some intermediate steps that are common in the development of this type of software tool, such as the construction of a data warehouse (DW). In this case, the Kimball methodology was chosen in order to design as well as develop and deploy the DW.[13] Thus, some of these steps are considered crucial for the successful implementation of a BI system, such as: tasks planning and expected results; defining the architecture that aims to follow the BI system; the selection and installation of the most appropriate BI tool; building the data warehouse dimensional model; the extraction, transformation and loading (ETL) process; and, finally, the development of the BI application.[13]
Thus, in order to develop a BI application, initially, it is necessary to choose the software that is most appropriate for achieving the desired outcomes. Thereby, it is necessary to undertake an analysis of most of the software available and choose the one type that provides the necessary and desired resources.[3][14][15]
Examples of application of BI tools in healthcare environments
With the urgency of acquiring medical informatics applications, open-source software is receiving increased attention from the healthcare industry. For example, the open-source project Care2X — composed of a hospital information system, practice management, a central data server, and a health exchange protocol — is under development in Europe. Care2X was developed in order to overcome integration problems in multiple incompatible network programs. It is possible to integrate almost any type of service, system, department, process, data, or communication of a hospital. Care2X supports the clinical workflow, incorporating diagnosis-related groups (DRG), as well as scheduling and electronic prescribing modules.[16]
openEHR corresponds to another case, which is sponsored by the openEHR Foundation. It promotes the "development of an open, interoperable health computing platform, of which the major component is clinically effective and interoperable electronic health records (EHRs)."[17]
Canada Health Infoway, established by Canadian federal and provincial grants, began an open-source initiative in 2005 to develop software that hospitals and developers could use to ensure the secure exchange of medical records of patients between various entities.[6] Thereby, these initiatives suggest that open-source is a viable way of developing applications in healthcare.[18][19]
References
- ↑ 1.0 1.1 1.2 Janamanchi, B.; Katsamakas, E.; Raghupathi, W.; Gao, W. (2009). "The state and profile of open source software projects in health and medical informatics". International Journal of Medical Informatics 78 (7): 457-72. doi:10.1016/j.ijmedinf.2009.02.006. PMID 19321384.
- ↑ 2.0 2.1 2.2 Waring, T.; Maddocks, P. (2005). "Open source software implementation in the UK public sector: Evidence from the field and implications for the future". International Journal of Information Management 25 (5): 411-28. doi:10.1016/j.ijinfomgt.2005.06.002.
- ↑ 3.0 3.1 Muraina, I.D.; Ahmad, A. (30 July 2011). "Healthcare Business Intelligence: The Case of University's Health Center". Universiti Utara Malaysia. pp. 27. http://www.academia.edu/4465749/Healthcare_Business_Intelligence_The_Case_of_University_s_Health_Center.
- ↑ Bernardino, J. (2011). "Open Source Business Intelligence Platforms for Engineering Education" (PDF). Proceedings of the 1st World Engineering Education Flash Week, Lisbon 2011 2011: 693–698. http://www.sefi.be/wp-content/papers2011/T13/164.pdf.
- ↑ Brandão, A.; Pereira, E.; Portela, F. et al. (2015). "Predicting the risk associated to pregnancy using data mining" (PDF). Proceedings of the 7th International Conference on Agents and Artificial Intelligence 2015. doi:10.5220/0005286805940601. http://repositorium.sdum.uminho.pt/bitstream/1822/36738/1/ICAART_2015_178_Andreia.pdf.
- ↑ 6.0 6.1 "Canada Health Infoway". Canada Health Infoway, Inc. https://www.infoway-inforoute.ca/en/. Retrieved 10 July 2016.
- ↑ "Qlik". QlikTech International AB. http://www.qlik.com/us/. Retrieved 12 October 2016.
- ↑ "Jedox". Jedox AG. http://www.jedox.com/en/. Retrieved 12 October 2016.
- ↑ "Jaspersoft". TIBCO Software, Inc. https://www.jaspersoft.com/. Retrieved 12 October 2016.
- ↑ "Tableau Public". Tableau Software, Inc. https://public.tableau.com/s/. Retrieved 12 October 2016.
- ↑ "SpagoBI". Engineering Ingegneria Informatica S.p.A. http://www.spagobi.org/. Retrieved 12 October 2016.
- ↑ "Pentaho". Pentaho Corporation. http://www.pentaho.com/. Retrieved 12 October 2016.
- ↑ 13.0 13.1 Completo, J.; Cruz, R.S.; Coheur, L.; Delgado, M. (2012). "Design and implementation of a data warehouse for benchmarking in clinical rehabilitation". Procedia Technology 5: 885–894. doi:10.1016/j.protcy.2012.09.098.
- ↑ Côrte-Real, N. (November 2010). "Avaliação da Maturidade da Business Intelligence nas Organizações" (PDF). Universidade Nova de Lisboa. pp. 104. https://run.unl.pt/bitstream/10362/7477/1/TEGI0269.pdf.
- ↑ Tereso, M.; Bernardino, J. (2011). "Open source business intelligence tools for SMEs". Proceedings of the 6th Iberian Conference on Information Systems and Technologies 2011.
- ↑ "Care2X: The Open Source Hospital Information System". Care2x Team. http://www.care2x.org/. Retrieved 17 May 2016.
- ↑ "OpenEHR: An Open Domain-Driven Platform for Developing Flexible e-Health Systems". openEHR Foundation. http://www.openehr.org/. Retrieved 03 May 2016.
- ↑ Welch, W.P.; Bazarko, D.; Ritten, K. et al. (2007). "Electronic health records in four community physician practices: Impact on quality and cost of care". JAMIA 14 (3): 320–8. doi:10.1197/jamia.M2125. PMC PMC2244874. PMID 17329734. https://www.ncbi.nlm.nih.gov/pmc/articles/PMC2244874.
- ↑ Goulde, M.; Brown, E.; Rymer, J.; Hartzband, D. (March 2006). "Open Source Software: A Primer for Health Care Leaders". iHealth Reports. Forrester Consulting. pp. 31. http://www.chcf.org/publications/2006/03/open-source-software-a-primer-for-health-care-leaders. Retrieved 03 May 2016.
Notes
This presentation is faithful to the original, with only a few minor changes to presentation. In some cases important information was missing from the references, and that information was added.
