--SQL code in this block
SELECT insurance
FROM admissions
WHERE insurance IS NOT NULL Analysis Report One - What’s Your Data Strategy
Executive Summary
Data is a critical asset in any organization, especially in healthcare organizations because it aids in operational efficiency, patient outcomes, and overall organizational performance. In the article, The Rise of the Healthcare CIO, it discusses the Chief Informational Officer has a great deal with leadership but also balancing the defensive data responsibilities while understanding the importance and utilizing offensive data to improve patient outcomes (Butcher 2021). In “What’s Your Data Strategy”, the authors argue how organizations have to balance between two strategies, offensive and defensive, when approaching data management. Offensive data help organizations look at customer-focused business functions whereas defensive data is about minimizing risk and ensuring compliance (DalleMule and Davenport 2017). When reflecting this into healthcare organizations, healthcare leaders should prioritize understanding the data and all it has to offer. In healthcare organization, data driven decision making can improve patient outcomes and experiences and make better decisions as an organization that positively impacts the community. Executive leaders should ensure that the data provided is aligned with organizational goals while upholding data security. Data-driven innovation can help healthcare organizations strive and strengthen operational performance, dive into what is working in the company and create a sustainable organization.
Introduction
In the article, What’s Your Data Strategy, the core argument is that organizations should prioritize and manage data as a strategic business asset instead of data just being apart of daily operations. Many organizations do not look at the data from both perspectives, offensive and defense, and overall struggle with the data at hand instead of embracing it. The authors used offensive and defensive data arguments in the framework of this article to help readers understand data strategy. Offensive strategies consist of improving revenue, responding to market changes, understanding customer analytics, developing new products, and overall being able to adapt and innovate as needed to impact the growth and development of the company (DalleMule and Davenport 2017). Defensive strategies consist of preventing cyber attacks and data breaches, improving IT infrastructure, improving data quality and security, and being able to streamline back office systems (DalleMule and Davenport 2017). Having these two frameworks help organizations decide where to focus their resources while maintaining balance between the two. The overall foundation concept of the article is that data is just as valuable to companies as any other assets and should be treated as such. Organizations should invest in understanding the data at hand and use it as a tool for success rather than dwelling in the misunderstanding. Organizations collect a vast amount of data on a daily basis and do not understand where to start with it, but investing in it could help alleviate the misunderstanding. Understanding offensive and defensive data and how to utilize the data at hand helps organizations have a clearer understanding for how data supports business objectives as a whole.
The Healthcare Context
The article, “What’s Your Data Strategy,” is relevant to what is happening in healthcare organizations because healthcare heavily relies on data to continuously improve the organizational performance and patient outcomes. Offensive and defensive data drive a huge part in understanding strategic and analytic data in any organization including healthcare. In healthcare, offensive data would primarily consist of but not limited to electronic health records, or EMR, community health assessments, quality metrics, patient surveys, and health outcome predictions. Offensive data gives healthcare leadership a deeper understanding of the data but also the ability to use it to identify trends and outcomes, enhance patient experience and support the community with organizational growth. Understanding what the offensive data has to offer also gives light to what data needs to be protected as well. This is the defensive data strategies and challenges organizations face. In the article, Towards insighting cybersecurity for healthcare domains: A comprehensive review of recent practices and trends, reviews how healthcare organizations have become more vulnerable to cyber security issues, phishing schemes, data breaches that aim at EMR systems (Javaid 2023). Many healthcare organizations continue to expand on their digital technologies, such as telehealth visits, patient portals, digital health devices such as continuous glucose monitors that give data to your phone, all which give cause for healthcare systems to take a defensive data strategy and increase their cybersecurity measures. The article, Towards insighting cybersecurity for healthcare domains: A comprehensive review of recent practices and trends, discusses why cybersecurity is so crucial in healthcare. The type of data that is available in healthcare organizations is strongly tied to patient records in EMR systems. Having a defensive approach to data ensures that key cybersecurity tools and techniques are utilized in healthcare organizations. Some but not limited to, anti-malware systems, data loss prevention, cloud security measures, and backup recovery systems (Javaid 2023). These techniques ensure that the defensive approach and increased cybersecurity supports data protection and privacy, trained staff that can point out phishing schemes and having a trusted foundation in the digital healthcare systems (Javaid 2023). Reviewing both articles, they give the foundation that successful healthcare organizations have to use both defensive and offensive data strategies in order to operate and use the data efficiently but securely. Utilizing both data strategies together, healthcare executives are able to develop a balanced data strategy that supports data driven decision making skills while maintaining effective cybersecurity and privacy practices in order to keep the crucial healthcare data safe.
Data Visualizations
Visualization One - Offensive
ggplot(data = myquery1,
aes(x = insurance)) +
geom_bar() +
theme_minimal() + # Cleans up the background grid lines
labs(
title = "Patient Admissions by Insurance Type",
subtitle = "Data taken from admissions table within MIMIC-III",
x = "Insurance Type",
y = "Number of Admissions",
caption = "Source: MIMIC-III Clinical Database v1.4"
)Visualization Two - Defensive
--Put your SQL code in this block
SELECT gender
FROM patients#Put your ggplot visualization in this block
ggplot(data = myquery2,
aes(x = gender)) +
geom_bar()+
theme_minimal() + # Cleans up the background grid lines
labs(
title = "Patient Demographic by Gender",
subtitle = "Data taken from patients table within MIMIC-III",
x = "Gender",
y = "Number of Patients",
caption = "Source: MIMIC-III Clinical Database v1.4"
)Recommendations for Industry
In the first visualization with offensive data, I have created a visualization to show the insurance type for the patients and the number of admissions each insurance payer has. This visualization helps healthcare organizations understand what type of patient population they have and which type of insurance sees more admission than they other. This type of offensive data is important to healthcare organizations because leaders and CIO’s are able to see which type of insurance payers have the highest admission and readmission but also see from a financial aspect to see what type of payments are received from the different insurances and also how quickly they pay the organizations. Analyzing this data can help hospital administrators have a better understanding of the financial circumstance they are in with insurance payers. Understanding the amount of admissions per insurance payer can help administrators make better financial decisions, have better communication and contracts with the the payers but also improve the types of patient access provided to the community. Understanding which type of group is being admitted and readmitted helps healthcare organizations plan and prepare for the patient population they have coming in more regularly than those that are not. Overall, understanding what insurances are more frequent at a healthcare facility help organizational leaders focus on revenue, growth and future planning with this type of offensive data.
In the second visualization, I have created a bar graph that shows a defensive data strategy that shows the patient demographic of gender and how many patients are male or female. This defensive data is crucial for healthcare organizations because it shows healthcare executives the demographics of their patient population. Having a greater understanding of the patient demographics, like gender, helps organizations maintain a accurate patient record that aids in health reporting, aids in the data for the community health assessments. This type of defensive data matter in healthcare because when healthcare executives or CIO’s look at data for the area, they are able to determine which community, or gender, may be struggling or not. Healthcare organizations should prioritize this type of defensive data to ensure patient demographics maintain accurate information for the patients. It is important for healthcare administrators to maintain data quality and complete audits to ensure the data is complete and accurate.