SELECT submit_wardid,request_MRSA
FROM callout
WHERE submit_wardid IN (23, 50)Analysis Report One - What’s Your Data Strategy
Executive Summary
“What’s Your Data Strategy”, discusses how there are different strategies to manage data. There are different goals of each, defensive focuses on things such as compliance, and offensive data focus on the customer. There needs to be the right balance of defensive and offensive strategy. Depending on the industry, the balance may not look the same.
Introduction
The article, “What’s Your Data Strategy” discusses that many companies do not use the abundance of data they have to their advantage. The article focuses on two difference strategies, defensive and offensive strategy. Defensive strategy focus on areas like data privacy and limiting fraud and offensive strategy focuses on customer satisfaction and increasing revenue. The core concept is, these strategies are not standardized but need to be customized for each company, and the process continues to evolve. “Our framework addresses two key issues: It helps companies clarify the primary purpose of their data, and it guides them in strategic data management. Unlike other approaches we’ve seen, ours requires companies to make considered trade-offs between “defensive” and “offensive”.” (DalleMule and Davenport (2017))
The Healthcare Context
“What’s Your Data Strategy” relates to healthcare context in many ways. Defense data is incredibly important in healthcare due to all the strict regulations a hospital must follow. For example, HIPAA Security Rule protects patient’s privacy and helps ensure personal information is not given out without permission. While protocols are set in place, healthcare continue to struggle with HIPAA breaches. Administrators need to periodically do risk assessments to decrease the risk of a HIPAA breach by identifying issues, this could be an internal risk or an external risk, such as a cyber threat. For cyber threats, “The most effective tool for Security Rule compliance would be the assistance of security product vendors who could conduct risk analyses, choose appropriate security mechanisms, and follow up with covered entities periodically to ensure that their technology is updated.” (Hoffman and Podgurski 2007) Patient experience is crucial with offense data because healthcare facilities are rated by “stars” on patient experience. “Specifically, a higher number of stars for patient experience had a statistically significant association with lower rates of many in-hospital complications. A higher patient experience star rating also had a statistically significant association with lower rates of unplanned readmission to the hospital within 30 days.” (Trzeciak et al. 2016) Administrators should not wait for for a bad reviews to make implementation. Administrators should not just review surveys but also interact with patients and staff members to find ways to continue improving patient satisfaction.
Visualization One - Offensive
ggplot(data = myquery10,
aes(x = submit_wardid)) +
geom_bar() +
theme_minimal() + # Cleans up the background grid lines
labs(
title = "Visualization showing relative frequencies of MRSA Precautions in different wards",
subtitle = "Data taken from Callout table within MIMIC-III",
x = "Ward",
y = "Count of MRSA Special Precautions",
caption = "Source: MIMIC-III Clinical Database v1.4"
)
Recommendations for Industry
This table from MIMIC=III Clinical Database shows two different wards, ward 23 and ward 50 with MRSA related precautions. MRSA precautions help prevent spreading of MRSA infections to others in the hospital. As an offensive approach, complications from infections can negatively impact patient experience because this can result in longer hospital stays and decrease trust with the facility. Hospital administrators should monitor MRSA related precautions and infections for trends, if trends are noted, the administrator should investigate and take action steps if needed. These action steps could include reeducation to clinical staff on policies or procedures and the janitorial staff cleaning protocols. Keeping infections under control will help increase patient satisfaction by decreasing infection related complications. Keeping infections under control will help increase patient satisfaction by decreasing infection related complications. (Andersson, Lindholm, and Fossum 2011)
Visualization Two - Defensive
SELECT eventtype, curr_wardid
FROM transfers
WHERE curr_wardid LIKE (45)#Put your ggplot visualization in this block
ggplot(data = myquery6,
aes(x = eventtype)) +
geom_bar() +
theme_minimal() + # Cleans up the background grid lines
labs(
title = "Visualization showing transfer or admit",
subtitle = "Data taken from transfers table within MIMIC-III",
x = "Ward 45",
y = "Amount of transfer or admit",
caption = "Source: MIMIC-III Clinical Database v1.4"
)
Recommendations for Industry
This table from MIMIC-II Clinical Database shows how many patients are an admission vs transfer on ward 45. When patients are transferred from one unit to another they are transferred in the same hospital bed. “The hospital bed is comprised of different components, which pose a potential risk of infection for the patient if not adequately decontaminated.” (Creamer and Humphreys (2008)) From a defensive strategy, if there is a a instance of infection complications with patients’ that have transferred, the administrator should investigate and see if there is a trend with a certain ward. If a trend is identified, the identified ward itself will need further investigation to determine the cause of the complications. For example, if 75% of transfers from ward 30 are developing a MRSA infection, ward 30 needs infection control education and training.
References
Andersson, Helene, Christina Lindholm, and Bjöörn Fossum. 2011. “MRSA–Global Threat and Personal Disaster: Patients’ Experiences.” International Nursing Review 58 (1): 47–53.
Creamer, E, and H Humphreys. 2008. “The Contribution of Beds to Healthcare-Associated Infection: The Importance of Adequate Decontamination.” Journal of Hospital Infection 69 (1): 8–23.
DalleMule, Leandro, and Thomas H Davenport. 2017. “What’s Your Data Strategy.” Harvard Business Review 95 (3): 112–21.
Hoffman, Sharona, and Andy Podgurski. 2007. “Securing the HIPAA Security Rule.” Journal of Internet Law, Spring, 06–26.
Trzeciak, Stephen, John P Gaughan, Joshua Bosire, and Anthony J Mazzarelli. 2016. “Association Between Medicare Summary Star Ratings for Patient Experience and Clinical Outcomes in US Hospitals.” Journal of Patient Experience 3 (1): 6–9.