Difference between revisions of "Business intelligence"

From Clinfowiki
Jump to: navigation, search
(2023 working update as part of BMI 512 course)
(2023 working update as part of BMI 512 course. Performed a sweeping update. Most of the original content was replaced or recontextualized. More up-to-date sources were utilized.)
 
(2 intermediate revisions by one user not shown)
Line 1: Line 1:
NOTE: This is a working edit of the page. Further edits will be posted soon.
+
'''Business intelligence''' (BI) is an umbrella term to describe concepts and methods to improve business decision-making by using fact-based support.<ref name="Tutunea"></ref> This page discusses BI primarily from a healthcare perspective.
 
+
'''Business intelligence''' (BI) is an umbrella term to describe concepts and methods to improve business decision-making by using fact-based support. (Tutunea) This page discusses BI primarily from a healthcare perspective.
+
  
 
= Introduction =
 
= Introduction =
  
Business intelligence, described in more detail, comprises the strategies, processes, applications, data, products, technologies and technical architectures used to support the collection, analysis, presentation, and dissemination of business information (Nedim). Its origins are attributed to a 1958 article in IBM's Journal of Research and Development (Luhn) where it was called the business intelligence system. (Mettler, Tutunea)
+
Business intelligence, defined in more detail, comprises the strategies, processes, applications, data, products, technologies and technical architectures used to support the collection, analysis, presentation, and dissemination of business information.<ref name="Dedic"></ref> The term has been noted as early as 1865,<ref name="Devens"></ref> its origins are mainly attributed to a 1958 article in IBM's Journal of Research and Development <ref name="Luhn"></ref> where it was called the business intelligence system.<ref name="Mettler"></ref><ref name="Tutunea"></ref>
  
BI is sometimes viewed from two positions: data-centric and process-centric (Mettler). The data-centric position sees BI as transforming operational data into information using analytical tools to help drive business decisions. This approach often divorces the data from its context, however, jeopardizing its interpretability. The process-centric approach addresses this problem by emphasizing the processes from which the data originate to avoid losing context.
+
BI is sometimes viewed from two positions: data-centric and process-centric.<ref name="Mettler"></ref> The data-centric position sees BI as transforming operational data into information using analytical tools to help drive business decisions. This approach often divorces the data from its context, however, jeopardizing its interpretability. The process-centric approach addresses this problem by emphasizing the processes from which the data originate to avoid losing context -- this is often done with diligent capture of [[metadata]].
  
Some emphasize the presentation of the data: "the integration of data from disparate sources systems to optimize business usage and understanding through a user-friendly interface" (Madsen). Others contend that the term BI is being replaced by the term 'analytics' (Morr). Analytics "involves the use of data, analysis, and modeling to arrive at a solution to a problem or to identify new opportunities." This is uncannily similar to BI. In general, however, analytics refers to the methods used to processing data and BI refers to the over-arching process of curating information to inform business decisions.
+
Some emphasize the presentation of the data: "the integration of data from disparate sources systems to optimize business usage and understanding through a user-friendly interface."<ref name="Madsen">Madsen, L. (2012). Healthcare business intelligence: a guide to empowering successful data reporting and analytics. John Wiley & Sons.</ref> Others contend that the term BI is being replaced by the term [[Data Analytics|analytics]].<ref name="El Morr"></ref> Analytics "involves the use of data, analysis, and modeling to arrive at a solution to a problem or to identify new opportunities." This is uncannily similar to BI. In general, however, [[Data Analytics|analytics]] refers to the methods used to process data and BI refers to the over-arching process of curating information to inform business decisions.
  
= Healthcare BI =
+
= Healthcare Business Intelligence =
  
While business intelligence has long been used in many other industries, healthcare largely did not adopt these techniques until the 21st century (Gartner). The reasons for this are varied (Metter). Most industries have singular management structures while healthcare has both clinical and administrative ones. Most industries have a well-defined group of customers with a relatively constrained product range, whereas healthcare serves the needs of patients, insurance companies, accrediting agencies, governmental authorities, researchers, and clinicians -- while they all might theoretically serve the patient, their paths often cross in antagonistic ways. Most industries also have discrete, reliable metrics, but healthcare metrics are defined differently by the varying customers, often difficult to capture reliably, and must attend to poorly defined patient factors.
+
While business intelligence has long been used in many other industries, healthcare largely did not adopt these techniques until the 21st century.<ref name="Gartner BI"></ref> The reasons for this are varied <ref name="Mettler"></ref>. Most industries have singular management structures while healthcare has both clinical and administrative ones. Most industries have a well-defined group of customers with a relatively constrained product range, whereas healthcare serves the needs of patients, insurance companies, accrediting agencies, governmental authorities, researchers, and clinicians -- while they all might theoretically serve the patient, their paths often cross in antagonistic ways. Most industries also have discrete, reliable metrics, but healthcare metrics are defined differently by the varying customers, often difficult to capture reliably, and must attend to poorly defined patient factors.
  
Healthcare organizations have historically struggled to find the elusive link between the investment in information technology and improved organizational performance.* Aside from the aforementioned adoption barriers, this gap has also been driven by the use of information technology (IT) to digitize clinical workflows with inadequate attention paid to using the care delivery information to make business decisions.* The strategic value of IT lies in its power to provide clinicians and leadership with direct visibility into the care delivery process.
+
Healthcare organizations have historically struggled to find the elusive link between the investment in information technology and improved organizational performance.* Aside from the aforementioned adoption barriers, this gap has also been driven by the use of information technology (IT) to digitize clinical workflows with inadequate attention paid to using the care delivery information to make business decisions.<ref name="Gartner Healthcare"></ref> The strategic value of IT lies in its power to provide clinicians and leadership with direct visibility into the care delivery process.
  
Nevertheless, the state of modern healthcare is often characterized by its scarcity, poor quality, and financial pressures (Mettler, Cutler), all of which are ideal targets for BI. The hope of BI in healthcare is to solve these problems by using data to optimizing resource allocation, power quality improvement processes, and make strategic decisions that reduce costs and increase revenue.
+
Nevertheless, the state of modern healthcare is often characterized by its scarcity, poor quality, and financial pressures, all of which are ideal targets for BI.<ref name="Mettler"></ref><ref name="Cutler"></ref> The hope of BI in healthcare is to solve these problems by using data to optimizing resource allocation, power quality improvement processes, and make strategic decisions that reduce costs and increase revenue.
  
== Frameworks for Healthcare BI ==
+
== Conceptual Frameworks ==
  
Metter et al. provide a framework for BI in healthcare (see figure 1). Processes are the sets of partially ordered and coordinated tasks that trigger data collection, processing and distribution. They tend to cross boundaries of organizational units, and there are three types: medical, business, and support. Each process serves an internal and/or external 'actor' (i.e., customer), all of which become stakeholders in a BI system. The processes produce information which is then transformed into data using technologies. Data is categorized as either clinical, administrative, or external; when combined, they form a data warehouse from whence BI tools can provide an integrated view of the data.
+
Mettler & Vimarlund provide a framework for BI in healthcare.<ref name="Mettler"></ref> For a visual aid, see Figure 1 in their paper. The framework is organized in four sections: processes, actors, information, and technology.
  
[figure 1]
+
# Processes are defined as sets of partially ordered and coordinated tasks that often cut across organizational units and are the target of data collection and analysis. They separate target processes into three categories: medical (e.g., diagnostics and treatment, research and teaching), business (e.g., finance, risk management), and support (e.g., human resources, logistics and supply).
 +
# Actors are either internal (e.g., doctor, administrator) or external (e.g., patient, government) and have a role in one or more processes. They are important stakeholders in the BI for those processes.
 +
# Information produced by the processes is captured as data, which is categorized as clinical, administrative, or external. Data close to the source are stored in operational data stores (ODS), which provide close to real-time monitoring. When data from multiple sources are processed and combined, they form a [[data warehouse]]. Portions of a data warehouse then may be curated for specific purposes as "data marts."<ref name="Gartner BI"></ref>
 +
# The data is then transformed into information using technologies (e.g., reports, expert systems, data mining).
  
 +
El Morr & Ali-Hassan describes the framework of BI differently using four components: a [[data warehouse]], business analytics, business performance management (BPM), and a user interface.<ref name="El Morr"></ref> The purpose of a [[data warehouse]] is as described above. The business analytics reflect the types of technologies used to process and analyze the data. The BPM separately describes how data is to be used for decision-making, such as identifying metrics and targets, monitoring frequency, and corrective actions. This framework also emphasizes a user interface as an essential component, pointing out the importance of being able to visualize the data (e.g., interactive dashboard, paper report).
  
Morr et al., on the other hand, describes the framework of BI differently in four components: a data warehouse, business analytics, business performance management (BPM), and a user interface. The business analytics reflect the types of technologies used to process and analyze the data. The BPM separately describes how data is to be used for decision-making, such as identifying metrics and targets, monitoring frequency, and corrective actions. This framework also includes a user interface as an essential component, some way to visualize the data whether it’s an interactive dashboard or a paper report.
+
== Organizational Factors ==
  
Metter et al. also define certain prerequisites for effective healthcare BI: collaboration, knowledge, trust, institutions, governance. BI systems are only as good as the organizational relationships that surround them.
+
Mettler & Vimarlund also define certain prerequisites for effective healthcare BI: collaboration, knowledge, trust, institutions, governance.<ref name="Mettler"></ref> BI systems are only as good as the organizational relationships that surround them.
* Collaboration between different healthcare and social services in an area are important to share BI technology and data to drive decisions for the whole. This is challenging when the services are not all consolidated into one system.
+
* Knowledge of the system's processes, decisional authorities, and lines of communication are becoming more crucial for making decisions. Modern management strategies often don't fit into formalized organizational charts, which makes finding this information difficult.
+
* Trust, whether through contracts, competence, or goodwill, is important for sharing data and responsibility for addressing problems revealed by BI.
+
* Institutional structures formalize rules for BI operations. Clear delineations of processes help make sense of large, complex systems.
+
* Governance is vital in safeguarding information integrity and ensuring appropriate actions are taken.
+
It is important to note that each of these prerequisites contribute to the other. For example, collaboration builds knowledge and trust, which in turn are necessary to create institution and governance. Having an institutional structure and governance can in turn promote trust and collaboration while clarifying knowledge.
+
  
Laura Madsen proposes an alternate set of five 'tenets' of BI, adapted into the following by Morr et al.: data quality, technology, value, change management, and leadership.
+
# Collaboration between different healthcare and social services in an area are important to share BI technology and data to drive decisions for the whole. This is challenging when the services are not all consolidated into one system.
 +
# Knowledge of the system's processes, decisional authorities, and lines of communication are becoming more crucial for making decisions. Modern management strategies often don't fit into formalized organizational charts, which makes finding this information difficult.
 +
# Trust, whether through contracts, competence, or goodwill, is important for sharing data and responsibility for addressing problems revealed by BI.
 +
# Institutional structures formalize rules for BI operations. Clear delineations of processes help make sense of large, complex systems.
 +
# Governance involves processes that safeguard information integrity (see [[Data Governance]]) and ensure appropriate responsive actions are taken.
  
[[File:Datawarehouse reference architecture.jpg|thumb|Datawarehouse reference architecture]]
+
It is important to note that each of these prerequisites contribute to the other. For example, collaboration builds knowledge and trust, which in turn are necessary to create institution and governance. Having an institutional structure and governance can in turn promote trust and collaboration while clarifying knowledge.
  
== Components of a comprehensive business intelligence and data warehousing program ==
+
Madsen proposes an alternate set of five 'tenets' of BI, adapted into the following more modern terms by El Morr & Ali-Hassan: data quality, technology, value, change management, and leadership.<ref name="Madsen"></ref><ref name="El Morr"></ref>
  
* A structured program to capture and manage meta data - "data about data"
+
Regardless of the conceptual framework used, it is clear that deploying effective healthcare BI involves organizational factors in addition to the technological requirements. A BI system cannot stand on its own without organizational support.
* Defined business and clinical rules to cleanse data contained in transactional systems
+
* Tools to extract, translate, and load data from source systems into a format that enables analysis, reporting, and decision support
+
* A [[Data warehouse|database management system]] that integrates and stores information from many source systems into a single solution
+
* Several different business views of data including population or disease specific data marts to support specific business or clinical questions
+
* An operational data store to manage information for real time and near real time monitoring applications
+
  
 
= Analytics =
 
= Analytics =
  
Analytics support the function of BI. These are the techniques that collect, process, analyze, and visualize the data to provide insights. Trevor Strome identifies five basic layers to analytics: business context, data, analytics, quality and performance management, and presentation.  
+
Analytics are the techniques for processing, analyzing, and visualizing the data to provide insights.<ref name="El Morr"></ref> In essence, analytics tries to take data as high up the wisdom hierarchy as possible, from data to information to knowledge to wisdom.<ref name="Rowley"></ref> Healthcare analytics have been described with five basic layers: business context, data, analytics (specifically [[Data Analytics|data analytics]]), quality and performance management, and presentation.<ref name="El Morr"></ref>
  
The business context defines the objective and measurable goal of the analytics. Data should not be collected for its own sake for no particular reason. It should be intentional.
+
# The business context defines the objective and measurable goal of the analytics. '''Data should not be collected for its own sake for no particular reason. It should be intentional.'''
The data is defined by identifying the context, the data source and its quality, and the method for collection and storage.
+
# The data is defined by identifying the context, the data source and its quality, and the method for collection and storage.
• The type of analytics is defined by choosing the appropriate software and algorithms to process the data.
+
# [[Data Analytics|Data analytics]] is defined by choosing the appropriate software and algorithms to process the data. There are four general types: descriptive, diagnostic, predictive, and prescriptive.
Quality and performance measurement refer to the defined metrics, their targets, and strategies for evaluation and improvement.
+
# Quality and performance measurement refer to the defined metrics, their target values, and strategies for evaluation and improvement.
Metrics with defined targets are called indicators. They provide simplified conclusions about whether goals are being met.
+
#* Metrics with defined targets are called indicators. They provide simplified conclusions about whether goals are being met. Indicators that serve particularly vital organizational goals and allow comparison against similar organizations or approved standards are often called "[[#Key Performance Indicators for Healthcare|key performance indicators]]" (or KPIs).<ref name="Khalifa"></ref>
Presentation refers to the data visualization techniques used to communicate the information in the data meaningfully to various stakeholders.
+
#Presentation refers to the data visualization techniques used to communicate the information in the data meaningfully to various stakeholders.
  
 +
= Common Technologies =
  
Business intelligence was defined by David Losehin as the processes, technologies, and tools needed to turn data into information, information into knowledge, and knowledge into plans that drive profitable business applications. As such, business intelligence is a key discpline that needs to be adopted by healthcare organizations to transform the vast quantities of data contained in their transactional EHR systems into a format that enables improved strategic, tactical, and operational decision making.
+
Commonly used technologies in BI include the following:<ref name="Tutunea"></ref>
  
= Examples of business intelligence technologies =
+
* Decision Support Systems (of which [[CDS|clinical decision support]] is a subset)
 
+
* Decision Support Systems  
+
 
* Executive Information Systems  
 
* Executive Information Systems  
 
* Online Analytical Processing (OLAP)  
 
* Online Analytical Processing (OLAP)  
Line 71: Line 65:
 
* Business Process Monitoring  
 
* Business Process Monitoring  
 
* Performance Scorecards and Dashboards
 
* Performance Scorecards and Dashboards
 +
** A number of dashboard images and interactive examples are viewable on [https://www.datapine.com/dashboard-examples-and-templates/healthcare datapine's website]
 +
** The familiar COVID-19 tracking websites, such as the [https://covid.cdc.gov/covid-data-tracker/#datatracker-home CDC COVID Data Tracker], are also good examples of dashboards.
 
* Data Mining
 
* Data Mining
* Predictive Analytics  
+
* [[Data Analytics]]
 +
 
 +
= Key Performance Indicators for Healthcare =
  
A healthcare organization must also develop a core competency in data warehousing to enable business intelligence applications. Wiliam Inmon defined data warehousing as a "subject-oriented, integrated, non-volatile, time vriant, collection of data organized to support management needs." Data warehousing includes both the process and the technologies required to achieve value from the data assets of an organization.  
+
Key performance indicators (KPIs) are indicators that serve particularly vital organizational goals and allow comparison against similar organizations or approved standards. Khalifa & Khalid qualitatively analyzed key performance indicators (KPIs) at a tertiary hospital, then standardized and validated them against published research and internationally recognized benchmarks such as those from the [[Agency for Healthcare Research and Quality (AHRQ)]] and the [https://www.oecd.org/ Organization for Economic Cooperation and Development (OECD)].<ref name="Khalifa"></ref> They identified 10 categories of KPIs with a total of 58 individual KPIs, only some of which are shown here:
  
== References ==
+
# Patient Access
 +
#* Number of Patients Referred
 +
#* Percentage of Patients Accepted
 +
# Inpatient Utilization
 +
#* Average Length of Stay
 +
#* Average Bed Occupancy Rate
 +
#* Mortality Rate
 +
# Outpatient Utilization
 +
#* Average First Available Slots > 30 Days for New Patients
 +
#* Percentage of No Show Patients
 +
# OR Utilization
 +
#* Percentage of OR Cancellation Rate
 +
#* OR Utilization Rate
 +
# ER Utilization
 +
#* ER Waiting Time (Door to Doctor)
 +
#* ER Treatment Time (Doctor to Disposition)
 +
#* ER Admission Waiting Time (Boarding Time)
 +
#* Percentage of Patients LWBS (left without being seen)
 +
# Generic Utilization
 +
#* Total radiological procedures
 +
#* Total lab procedures
 +
# Patient Safety
 +
#* Unplanned Readmission within 30 Days of Discharge
 +
#* Unplanned Transfer to any Critical Unit/OR
 +
#* Cardiac or Respiratory Arrest
 +
# Infection Control
 +
#* Blood Stream Infection
 +
#* Catheter-related Infection
 +
#* Surgical site infection
 +
# Documentation Compliance
 +
#* Number of Deficient Records (less than 30 days)
 +
#* Number of Delinquent Records (more than 30 days)
 +
# Patient Satisfaction
 +
#* Inpatient Satisfaction Rate
 +
#* Outpatient Satisfaction Rate
  
# Gartner, Hype Cycle for Business Intelligence and Data Warehousing, 2005
+
= References =
# Gartner, Hype Cycle for Healthcare Provider Applications, 2005
+
<references>
# Loshin, David, Business Intelligence: The Savvy Manager's Guide, Addison Wesley, 2003
+
<ref name="Tutunea">Tutunea, M. F., & Rus, R. V. (2012). Business intelligence solutions for SME's. Procedia Economics and Finance, 3, 865-870.</ref>
# TDWI Business Intelligence Fundamentals, The Data Warehousing Institute, January 2005. [http://www.informatics-review.com/wiki/index.php/CDS]
+
<ref name="Dedic">Dedić, N., & Stanier, C. (2016). Measuring the success of changes to existing business intelligence solutions to improve business intelligence reporting. In Research and Practical Issues of Enterprise Information Systems: 10th IFIP WG 8.9 Working Conference, CONFENIS 2016, Vienna, Austria, December 13–14, 2016, Proceedings 10 (pp. 225-236). Springer International Publishing. https://doi.org/10.1007/978-3-319-49944-4_17</ref>
# Mettler T, Vimarlund V. Understanding business intelligence in the context of healthcare. Health Informatics Journal. 2009;15(3):254-264. doi:10.1177/1460458209337446
+
<ref name="Devens">Devens, R. M. (1865). Cyclopaedia of Commercial and Business Anecdotes; Comprising Interesting Reminiscences and Facts, Remarkable Traits and Humors of Merchants, Traders, Bankers Etc. in All Ages and Countries. D. Appleton and Company. p. 210</ref>
# Nedim Dedić, Clare Stanier. Measuring the Success of Changes to Existing Business Intelligence Solutions to Improve Business Intelligence Reporting. 10th International Conference on Research and Practical Issues of Enterprise Information Systems (CONFENIS), Dec 2016, Vienna, Austria. pp.225-236, ff10.1007/978-3-319-49944-4_17ff.
+
<ref name="Luhn">Luhn, H. P. (1958). A business intelligence system. IBM Journal of Research and Development, 2(4), 314-319.</ref>
# Rowley, J. (2007). The wisdom hierarchy: representations of the DIKW hierarchy. Journal of Information Science, 33(2), 163–180. https://doi.org/10.1177/0165551506070706
+
<ref name="Mettler">Mettler, T., & Vimarlund, V. (2009). Understanding business intelligence in the context of healthcare. Health Informatics Journal, 15(3), 254-264. https://doi.org/10.1177/1460458209337446</ref>
# Cutler DM, Scott Morton F. Hospitals, Market Share, and Consolidation. JAMA. 2013;310(18):1964–1970. doi:10.1001/jama.2013.281675
+
<ref name="El Morr">El Morr, C., & Ali-Hassan, H. (2019). Analytics in healthcare: a practical introduction. Springer.</ref>
# L. Madsen, “The Tenets of Healthcare BI,” in Healthcare Business Intelligence: A Guide to
+
<ref name="Gartner BI">Gartner (2005). Hype Cycle for Business Intelligence and Data Warehousing.</ref>
# Empowering Successful Data Reporting and Analytics: Wiley, 2012.
+
<ref name="Gartner Healthcare">Gartner (2005). Hype Cycle for Healthcare Provider Applications.</ref>
# Luhn, H. P. (1958). A business intelligence system. IBM Journal of research and development, 2(4), 314-319.
+
<ref name="Cutler">Cutler, D. M., & Morton, F. S. (2013). Hospitals, market share, and consolidation. JAMA, 310(18), 1964-1970. https://doi.org/10.1001/jama.2013.281675</ref>
# Tutunea, M. F., & Rus, R. V. (2012). Business intelligence solutions for SME's. Procedia economics and finance, 3, 865-870.
+
<ref name="Madsen">Madsen, L. (2012). Healthcare business intelligence: a guide to empowering successful data reporting and analytics. John Wiley & Sons.</ref>
 +
<ref name="Rowley">Rowley, J. (2007). The wisdom hierarchy: representations of the DIKW hierarchy. Journal of Information Science, 33(2), 163–180. https://doi.org/10.1177/0165551506070706</ref>
 +
<ref name="Khalifa">Khalifa, M., & Khalid, P. (2015). Developing strategic health care key performance indicators: a case study on a tertiary care hospital. Procedia Computer Science, 63, 459-466. https://doi.org/10.1016/j.procs.2015.08.368</ref>
 +
</references>
  
  
 
Submitted by Amrish T. Pipalia
 
Submitted by Amrish T. Pipalia
 
[[Category:BMI512-SPRING-23]]
 
[[Category:BMI512-SPRING-23]]

Latest revision as of 07:44, 30 April 2023

Business intelligence (BI) is an umbrella term to describe concepts and methods to improve business decision-making by using fact-based support.[1] This page discusses BI primarily from a healthcare perspective.

Introduction

Business intelligence, defined in more detail, comprises the strategies, processes, applications, data, products, technologies and technical architectures used to support the collection, analysis, presentation, and dissemination of business information.[2] The term has been noted as early as 1865,[3] its origins are mainly attributed to a 1958 article in IBM's Journal of Research and Development [4] where it was called the business intelligence system.[5][1]

BI is sometimes viewed from two positions: data-centric and process-centric.[5] The data-centric position sees BI as transforming operational data into information using analytical tools to help drive business decisions. This approach often divorces the data from its context, however, jeopardizing its interpretability. The process-centric approach addresses this problem by emphasizing the processes from which the data originate to avoid losing context -- this is often done with diligent capture of metadata.

Some emphasize the presentation of the data: "the integration of data from disparate sources systems to optimize business usage and understanding through a user-friendly interface."[6] Others contend that the term BI is being replaced by the term analytics.[7] Analytics "involves the use of data, analysis, and modeling to arrive at a solution to a problem or to identify new opportunities." This is uncannily similar to BI. In general, however, analytics refers to the methods used to process data and BI refers to the over-arching process of curating information to inform business decisions.

Healthcare Business Intelligence

While business intelligence has long been used in many other industries, healthcare largely did not adopt these techniques until the 21st century.[8] The reasons for this are varied [5]. Most industries have singular management structures while healthcare has both clinical and administrative ones. Most industries have a well-defined group of customers with a relatively constrained product range, whereas healthcare serves the needs of patients, insurance companies, accrediting agencies, governmental authorities, researchers, and clinicians -- while they all might theoretically serve the patient, their paths often cross in antagonistic ways. Most industries also have discrete, reliable metrics, but healthcare metrics are defined differently by the varying customers, often difficult to capture reliably, and must attend to poorly defined patient factors.

Healthcare organizations have historically struggled to find the elusive link between the investment in information technology and improved organizational performance.* Aside from the aforementioned adoption barriers, this gap has also been driven by the use of information technology (IT) to digitize clinical workflows with inadequate attention paid to using the care delivery information to make business decisions.[9] The strategic value of IT lies in its power to provide clinicians and leadership with direct visibility into the care delivery process.

Nevertheless, the state of modern healthcare is often characterized by its scarcity, poor quality, and financial pressures, all of which are ideal targets for BI.[5][10] The hope of BI in healthcare is to solve these problems by using data to optimizing resource allocation, power quality improvement processes, and make strategic decisions that reduce costs and increase revenue.

Conceptual Frameworks

Mettler & Vimarlund provide a framework for BI in healthcare.[5] For a visual aid, see Figure 1 in their paper. The framework is organized in four sections: processes, actors, information, and technology.

  1. Processes are defined as sets of partially ordered and coordinated tasks that often cut across organizational units and are the target of data collection and analysis. They separate target processes into three categories: medical (e.g., diagnostics and treatment, research and teaching), business (e.g., finance, risk management), and support (e.g., human resources, logistics and supply).
  2. Actors are either internal (e.g., doctor, administrator) or external (e.g., patient, government) and have a role in one or more processes. They are important stakeholders in the BI for those processes.
  3. Information produced by the processes is captured as data, which is categorized as clinical, administrative, or external. Data close to the source are stored in operational data stores (ODS), which provide close to real-time monitoring. When data from multiple sources are processed and combined, they form a data warehouse. Portions of a data warehouse then may be curated for specific purposes as "data marts."[8]
  4. The data is then transformed into information using technologies (e.g., reports, expert systems, data mining).

El Morr & Ali-Hassan describes the framework of BI differently using four components: a data warehouse, business analytics, business performance management (BPM), and a user interface.[7] The purpose of a data warehouse is as described above. The business analytics reflect the types of technologies used to process and analyze the data. The BPM separately describes how data is to be used for decision-making, such as identifying metrics and targets, monitoring frequency, and corrective actions. This framework also emphasizes a user interface as an essential component, pointing out the importance of being able to visualize the data (e.g., interactive dashboard, paper report).

Organizational Factors

Mettler & Vimarlund also define certain prerequisites for effective healthcare BI: collaboration, knowledge, trust, institutions, governance.[5] BI systems are only as good as the organizational relationships that surround them.

  1. Collaboration between different healthcare and social services in an area are important to share BI technology and data to drive decisions for the whole. This is challenging when the services are not all consolidated into one system.
  2. Knowledge of the system's processes, decisional authorities, and lines of communication are becoming more crucial for making decisions. Modern management strategies often don't fit into formalized organizational charts, which makes finding this information difficult.
  3. Trust, whether through contracts, competence, or goodwill, is important for sharing data and responsibility for addressing problems revealed by BI.
  4. Institutional structures formalize rules for BI operations. Clear delineations of processes help make sense of large, complex systems.
  5. Governance involves processes that safeguard information integrity (see Data Governance) and ensure appropriate responsive actions are taken.

It is important to note that each of these prerequisites contribute to the other. For example, collaboration builds knowledge and trust, which in turn are necessary to create institution and governance. Having an institutional structure and governance can in turn promote trust and collaboration while clarifying knowledge.

Madsen proposes an alternate set of five 'tenets' of BI, adapted into the following more modern terms by El Morr & Ali-Hassan: data quality, technology, value, change management, and leadership.[6][7]

Regardless of the conceptual framework used, it is clear that deploying effective healthcare BI involves organizational factors in addition to the technological requirements. A BI system cannot stand on its own without organizational support.

Analytics

Analytics are the techniques for processing, analyzing, and visualizing the data to provide insights.[7] In essence, analytics tries to take data as high up the wisdom hierarchy as possible, from data to information to knowledge to wisdom.[11] Healthcare analytics have been described with five basic layers: business context, data, analytics (specifically data analytics), quality and performance management, and presentation.[7]

  1. The business context defines the objective and measurable goal of the analytics. Data should not be collected for its own sake for no particular reason. It should be intentional.
  2. The data is defined by identifying the context, the data source and its quality, and the method for collection and storage.
  3. Data analytics is defined by choosing the appropriate software and algorithms to process the data. There are four general types: descriptive, diagnostic, predictive, and prescriptive.
  4. Quality and performance measurement refer to the defined metrics, their target values, and strategies for evaluation and improvement.
    • Metrics with defined targets are called indicators. They provide simplified conclusions about whether goals are being met. Indicators that serve particularly vital organizational goals and allow comparison against similar organizations or approved standards are often called "key performance indicators" (or KPIs).[12]
  5. Presentation refers to the data visualization techniques used to communicate the information in the data meaningfully to various stakeholders.

Common Technologies

Commonly used technologies in BI include the following:[1]

  • Decision Support Systems (of which clinical decision support is a subset)
  • Executive Information Systems
  • Online Analytical Processing (OLAP)
  • Query and Online Reporting
  • Business Process Monitoring
  • Performance Scorecards and Dashboards
    • A number of dashboard images and interactive examples are viewable on datapine's website
    • The familiar COVID-19 tracking websites, such as the CDC COVID Data Tracker, are also good examples of dashboards.
  • Data Mining
  • Data Analytics

Key Performance Indicators for Healthcare

Key performance indicators (KPIs) are indicators that serve particularly vital organizational goals and allow comparison against similar organizations or approved standards. Khalifa & Khalid qualitatively analyzed key performance indicators (KPIs) at a tertiary hospital, then standardized and validated them against published research and internationally recognized benchmarks such as those from the Agency for Healthcare Research and Quality (AHRQ) and the Organization for Economic Cooperation and Development (OECD).[12] They identified 10 categories of KPIs with a total of 58 individual KPIs, only some of which are shown here:

  1. Patient Access
    • Number of Patients Referred
    • Percentage of Patients Accepted
  2. Inpatient Utilization
    • Average Length of Stay
    • Average Bed Occupancy Rate
    • Mortality Rate
  3. Outpatient Utilization
    • Average First Available Slots > 30 Days for New Patients
    • Percentage of No Show Patients
  4. OR Utilization
    • Percentage of OR Cancellation Rate
    • OR Utilization Rate
  5. ER Utilization
    • ER Waiting Time (Door to Doctor)
    • ER Treatment Time (Doctor to Disposition)
    • ER Admission Waiting Time (Boarding Time)
    • Percentage of Patients LWBS (left without being seen)
  6. Generic Utilization
    • Total radiological procedures
    • Total lab procedures
  7. Patient Safety
    • Unplanned Readmission within 30 Days of Discharge
    • Unplanned Transfer to any Critical Unit/OR
    • Cardiac or Respiratory Arrest
  8. Infection Control
    • Blood Stream Infection
    • Catheter-related Infection
    • Surgical site infection
  9. Documentation Compliance
    • Number of Deficient Records (less than 30 days)
    • Number of Delinquent Records (more than 30 days)
  10. Patient Satisfaction
    • Inpatient Satisfaction Rate
    • Outpatient Satisfaction Rate

References

  1. 1.0 1.1 1.2 Tutunea, M. F., & Rus, R. V. (2012). Business intelligence solutions for SME's. Procedia Economics and Finance, 3, 865-870.
  2. Dedić, N., & Stanier, C. (2016). Measuring the success of changes to existing business intelligence solutions to improve business intelligence reporting. In Research and Practical Issues of Enterprise Information Systems: 10th IFIP WG 8.9 Working Conference, CONFENIS 2016, Vienna, Austria, December 13–14, 2016, Proceedings 10 (pp. 225-236). Springer International Publishing. https://doi.org/10.1007/978-3-319-49944-4_17
  3. Devens, R. M. (1865). Cyclopaedia of Commercial and Business Anecdotes; Comprising Interesting Reminiscences and Facts, Remarkable Traits and Humors of Merchants, Traders, Bankers Etc. in All Ages and Countries. D. Appleton and Company. p. 210
  4. Luhn, H. P. (1958). A business intelligence system. IBM Journal of Research and Development, 2(4), 314-319.
  5. 5.0 5.1 5.2 5.3 5.4 5.5 Mettler, T., & Vimarlund, V. (2009). Understanding business intelligence in the context of healthcare. Health Informatics Journal, 15(3), 254-264. https://doi.org/10.1177/1460458209337446
  6. 6.0 6.1 Madsen, L. (2012). Healthcare business intelligence: a guide to empowering successful data reporting and analytics. John Wiley & Sons.
  7. 7.0 7.1 7.2 7.3 7.4 El Morr, C., & Ali-Hassan, H. (2019). Analytics in healthcare: a practical introduction. Springer.
  8. 8.0 8.1 Gartner (2005). Hype Cycle for Business Intelligence and Data Warehousing.
  9. Gartner (2005). Hype Cycle for Healthcare Provider Applications.
  10. Cutler, D. M., & Morton, F. S. (2013). Hospitals, market share, and consolidation. JAMA, 310(18), 1964-1970. https://doi.org/10.1001/jama.2013.281675
  11. Rowley, J. (2007). The wisdom hierarchy: representations of the DIKW hierarchy. Journal of Information Science, 33(2), 163–180. https://doi.org/10.1177/0165551506070706
  12. 12.0 12.1 Khalifa, M., & Khalid, P. (2015). Developing strategic health care key performance indicators: a case study on a tertiary care hospital. Procedia Computer Science, 63, 459-466. https://doi.org/10.1016/j.procs.2015.08.368


Submitted by Amrish T. Pipalia