Linda C. Alongi MSN (is Surgical Quality Improvement Coordinator, Park Nicollet Methodist Hospital, St. Louis Park, Minnesota), Brady Alsaker MSN (formerly Clinical Analyst, Park Nicollet Methodist Hospital, is Registered Nurse, Minnesota Department of Veterans Affairs, St. Paul, Minnesota), David J. Willis MD (is Surgeon, Park Nicollet Methodist Hospital, and System Medical Director of Quality Improvement, Surgical Services, HealthPartners, Minneapolis), William A. Burns (is Primary Research Assistant, HealthPartners Institute, Bloomington, Minnesota), Charles R. Watts MD, PhD (is Neurosurgeon and Chair of Neurosurgery, Park Nicollet Methodist Hospital. Please address correspondence to Charles R. Watts)
{"title":"使用先进的可视化数据分析工具开发标准化流程来可视化、分析和交流NSQIP数据。","authors":"Linda C. Alongi MSN (is Surgical Quality Improvement Coordinator, Park Nicollet Methodist Hospital, St. Louis Park, Minnesota), Brady Alsaker MSN (formerly Clinical Analyst, Park Nicollet Methodist Hospital, is Registered Nurse, Minnesota Department of Veterans Affairs, St. Paul, Minnesota), David J. Willis MD (is Surgeon, Park Nicollet Methodist Hospital, and System Medical Director of Quality Improvement, Surgical Services, HealthPartners, Minneapolis), William A. Burns (is Primary Research Assistant, HealthPartners Institute, Bloomington, Minnesota), Charles R. Watts MD, PhD (is Neurosurgeon and Chair of Neurosurgery, Park Nicollet Methodist Hospital. Please address correspondence to Charles R. Watts)","doi":"10.1016/j.jcjq.2025.01.003","DOIUrl":null,"url":null,"abstract":"<div><h3>Background</h3><div>To help surgeons improve quality, the American College of Surgeons National Quality Improvement Program (ACS NSQIP) Semiannual Reports and Interim Semiannual Reports provide high-level views of 30-day morbidity and mortality rates. Surgeons at one hospital requested the ability to visualize data with interactive navigation and analysis of comorbidities monthly. Using advanced visual data analytics, the authors constructed a surgical scorecard to provide the desired feedback.</div></div><div><h3>Methods</h3><div>The authors undertook a proof-of-concept project tracking surgical site infections (SSIs) and associated medical comorbidities. An anonymized training dataset of 3,438 patients was sampled between January 1, 2021, and October 31, 2022, from the hospital's NSQIP data. For proof-of-concept interface/system testing and to maintain data privacy, a synthetic 5,000-patient NSQIP database was generated using the Synthetic Data Vault, Python 3.7. Comorbidity variables were: diabetes mellitus, HgbA1c, immunosuppressive therapy, hypertension requiring medication, body mass index, and smoking within one year. The primary outcome was SSI. The research team generated scorecards for SSIs as a function of time, surgical department, and medical comorbidity. Odds ratios with confidence intervals and chi-square tests were used to analyze the relationships between SSI and comorbidities.</div></div><div><h3>Results</h3><div>Advanced visual data analytics improved the timeliness of NSQIP Semiannual Reports and Interim Semiannual Reports from 6 months to 45 days. The scorecard allowed for visualization of data trends as a function of time, specialty, and procedural group. Statistical testing allowed for the identification of surgeons who were statistical outliers with regard to SSIs.</div></div><div><h3>Conclusion</h3><div>Implementation of an on-demand scorecard for data visualization and analysis allowed for up-to-date analysis of the relationship between medical comorbidities and SSI and identification of performance outliers.</div></div>","PeriodicalId":14835,"journal":{"name":"Joint Commission journal on quality and patient safety","volume":"51 5","pages":"Pages 361-367"},"PeriodicalIF":2.3000,"publicationDate":"2025-01-16","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"Developing a Standardized Process to Visualize, Analyze, and Communicate NSQIP Data Using an Advanced Visual Data Analytics Tool\",\"authors\":\"Linda C. Alongi MSN (is Surgical Quality Improvement Coordinator, Park Nicollet Methodist Hospital, St. Louis Park, Minnesota), Brady Alsaker MSN (formerly Clinical Analyst, Park Nicollet Methodist Hospital, is Registered Nurse, Minnesota Department of Veterans Affairs, St. Paul, Minnesota), David J. Willis MD (is Surgeon, Park Nicollet Methodist Hospital, and System Medical Director of Quality Improvement, Surgical Services, HealthPartners, Minneapolis), William A. Burns (is Primary Research Assistant, HealthPartners Institute, Bloomington, Minnesota), Charles R. Watts MD, PhD (is Neurosurgeon and Chair of Neurosurgery, Park Nicollet Methodist Hospital. Please address correspondence to Charles R. Watts)\",\"doi\":\"10.1016/j.jcjq.2025.01.003\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"<div><h3>Background</h3><div>To help surgeons improve quality, the American College of Surgeons National Quality Improvement Program (ACS NSQIP) Semiannual Reports and Interim Semiannual Reports provide high-level views of 30-day morbidity and mortality rates. Surgeons at one hospital requested the ability to visualize data with interactive navigation and analysis of comorbidities monthly. Using advanced visual data analytics, the authors constructed a surgical scorecard to provide the desired feedback.</div></div><div><h3>Methods</h3><div>The authors undertook a proof-of-concept project tracking surgical site infections (SSIs) and associated medical comorbidities. An anonymized training dataset of 3,438 patients was sampled between January 1, 2021, and October 31, 2022, from the hospital's NSQIP data. For proof-of-concept interface/system testing and to maintain data privacy, a synthetic 5,000-patient NSQIP database was generated using the Synthetic Data Vault, Python 3.7. Comorbidity variables were: diabetes mellitus, HgbA1c, immunosuppressive therapy, hypertension requiring medication, body mass index, and smoking within one year. The primary outcome was SSI. The research team generated scorecards for SSIs as a function of time, surgical department, and medical comorbidity. Odds ratios with confidence intervals and chi-square tests were used to analyze the relationships between SSI and comorbidities.</div></div><div><h3>Results</h3><div>Advanced visual data analytics improved the timeliness of NSQIP Semiannual Reports and Interim Semiannual Reports from 6 months to 45 days. The scorecard allowed for visualization of data trends as a function of time, specialty, and procedural group. Statistical testing allowed for the identification of surgeons who were statistical outliers with regard to SSIs.</div></div><div><h3>Conclusion</h3><div>Implementation of an on-demand scorecard for data visualization and analysis allowed for up-to-date analysis of the relationship between medical comorbidities and SSI and identification of performance outliers.</div></div>\",\"PeriodicalId\":14835,\"journal\":{\"name\":\"Joint Commission journal on quality and patient safety\",\"volume\":\"51 5\",\"pages\":\"Pages 361-367\"},\"PeriodicalIF\":2.3000,\"publicationDate\":\"2025-01-16\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"Joint Commission journal on quality and patient safety\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://www.sciencedirect.com/science/article/pii/S1553725025000248\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"Q2\",\"JCRName\":\"HEALTH CARE SCIENCES & SERVICES\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"Joint Commission journal on quality and patient safety","FirstCategoryId":"1085","ListUrlMain":"https://www.sciencedirect.com/science/article/pii/S1553725025000248","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"Q2","JCRName":"HEALTH CARE SCIENCES & SERVICES","Score":null,"Total":0}
Developing a Standardized Process to Visualize, Analyze, and Communicate NSQIP Data Using an Advanced Visual Data Analytics Tool
Background
To help surgeons improve quality, the American College of Surgeons National Quality Improvement Program (ACS NSQIP) Semiannual Reports and Interim Semiannual Reports provide high-level views of 30-day morbidity and mortality rates. Surgeons at one hospital requested the ability to visualize data with interactive navigation and analysis of comorbidities monthly. Using advanced visual data analytics, the authors constructed a surgical scorecard to provide the desired feedback.
Methods
The authors undertook a proof-of-concept project tracking surgical site infections (SSIs) and associated medical comorbidities. An anonymized training dataset of 3,438 patients was sampled between January 1, 2021, and October 31, 2022, from the hospital's NSQIP data. For proof-of-concept interface/system testing and to maintain data privacy, a synthetic 5,000-patient NSQIP database was generated using the Synthetic Data Vault, Python 3.7. Comorbidity variables were: diabetes mellitus, HgbA1c, immunosuppressive therapy, hypertension requiring medication, body mass index, and smoking within one year. The primary outcome was SSI. The research team generated scorecards for SSIs as a function of time, surgical department, and medical comorbidity. Odds ratios with confidence intervals and chi-square tests were used to analyze the relationships between SSI and comorbidities.
Results
Advanced visual data analytics improved the timeliness of NSQIP Semiannual Reports and Interim Semiannual Reports from 6 months to 45 days. The scorecard allowed for visualization of data trends as a function of time, specialty, and procedural group. Statistical testing allowed for the identification of surgeons who were statistical outliers with regard to SSIs.
Conclusion
Implementation of an on-demand scorecard for data visualization and analysis allowed for up-to-date analysis of the relationship between medical comorbidities and SSI and identification of performance outliers.