{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,6,30]],"date-time":"2026-06-30T19:06:45Z","timestamp":1782846405023,"version":"3.54.5"},"reference-count":16,"publisher":"JMIR Publications Inc.","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["JMIR Perioper Med"],"abstract":"Abstract<\/jats:title>\n \n Background<\/jats:title>\n Enhanced recovery after surgery (ERAS) programs bundle evidence-based interventions to standardize care, expedite recovery, and improve outcomes. As ERAS programs have expanded, it has become clear that a major challenge is monitoring the compliance of bundle elements and outcomes to feedback performance to stakeholders and guide changes. Manual data abstraction is onerous and not feasible. Reliance on receiving new reports from busy health system IT groups is challenging. Therefore, we sought to address this unmet need at our hospital by developing a novel ERAS Datamart system.<\/jats:p>\n <\/jats:sec>\n \n Objective<\/jats:title>\n Our objectives were to develop a novel Datamart and Tableau dashboard to (1) enable continuous analysis of data, harvested directly from the electronic medical record (EMR), measure compliance and outcomes, and (2) enable end users (e.g., an ERAS coordinator) to create reports customized based on surgical procedure types, requested data variables, and custom date ranges.<\/jats:p>\n <\/jats:sec>\n \n Methods<\/jats:title>\n \n After \u201cbuy-in\u201d from hospital leadership and other stakeholders, data metrics were identified and categorized according to phase of care, that is, preoperative, intraoperative, and postoperative. A multidisciplinary team reviewed\n International Classification of Diseases, Tenth Revision<\/jats:italic>\n procedure codes to capture EMR data for patients undergoing ERAS procedures. IT was given a master list with metric names, definitions, and screenshots of the discrete field in the EMR to assist with building the metrics. Validations of the novel Datamart were done against known ERAS patient populations maintained by the surgery clinic.\n <\/jats:p>\n <\/jats:sec>\n \n Results<\/jats:title>\n The Datamart and Tableau dashboard has been built, is functional, and contains over 17,000 patients across 5 ERAS service lines: colorectal (n=1742), joint replacement (n=4235), surgical oncology (n=941), bariatric (n=1130), and cesarean section (n=9390). Currently, 56 metrics spanning the perioperative period have been validated across these populations. Reports can be tailored according to patients, time frames, and metrics. If desired, patient-level raw data can be exported for statistical analyses. Two use cases (total joint replacement and surgical oncology ERAS programs) are presented showing how the Datamart can be used.<\/jats:p>\n <\/jats:sec>\n \n Conclusions<\/jats:title>\n Discrete fields within an EMR can be successfully captured into a novel Datamart and visualized using a custom Tableau dashboard for providing stakeholder feedback, facilitating quality improvement analyses, and auditing pathways.<\/jats:p>\n <\/jats:sec>","DOI":"10.2196\/82472","type":"journal-article","created":{"date-parts":[[2026,2,12]],"date-time":"2026-02-12T05:41:41Z","timestamp":1770874901000},"page":"e82472-e82472","source":"Crossref","is-referenced-by-count":1,"title":["A Novel Customizable Datamart and Tableau Dashboard to Monitor Multiple Enhanced Recovery After Surgery Programs: Development and Validation Study"],"prefix":"10.2196","volume":"9","author":[{"ORCID":"https:\/\/orcid.org\/0000-0002-9418-9849","authenticated-orcid":false,"given":"Sunitha Margaret","family":"Singh","sequence":"first","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0009-0002-1406-2520","authenticated-orcid":false,"given":"Susannah","family":"Oster","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0009-0008-6199-2337","authenticated-orcid":false,"given":"Efrat","family":"Bolze","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0009-0009-2534-8656","authenticated-orcid":false,"given":"Aaron","family":"Sasson","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0009-0006-9449-1737","authenticated-orcid":false,"given":"James","family":"Nicholson","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0000-0001-8659-8098","authenticated-orcid":false,"given":"Elliott","family":"Bennett-Guerrero","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"1010","published-online":{"date-parts":[[2026,2,11]]},"reference":[{"issue":"1","key":"R1","doi-asserted-by":"publisher","DOI":"10.1186\/s13012-017-0597-5","article-title":"Implementation of enhanced recovery after surgery: a strategy to transform surgical care across a health system","volume":"12","author":"Gramlich","journal-title":"Implement Sci"},{"issue":"4","key":"R2","doi-asserted-by":"publisher","first-page":"430","DOI":"10.1016\/j.jamcollsurg.2014.12.042","article-title":"Standardization of care: impact of an enhanced recovery protocol on length of stay, complications, and direct costs after colorectal surgery","volume":"220","author":"Thiele","journal-title":"J Am Coll Surg"},{"issue":"1","key":"R3","doi-asserted-by":"publisher","DOI":"10.1186\/s13741-021-00185-5","article-title":"Types of surgical patients enrolled in enhanced recovery after surgery (ERAS) programs in the USA","volume":"10","author":"Singh","journal-title":"Perioper Med (Lond)"},{"issue":"5","key":"R4","doi-asserted-by":"publisher","first-page":"933","DOI":"10.1002\/jpen.1961","article-title":"Failure in systems and culture: barriers that prevent implementation of evidence-based fasting times for patients in the acute care setting","volume":"45","author":"Carey","journal-title":"JPEN J Parenter Enteral Nutr"},{"key":"R5","unstructured":"ERAS interactive audit system - EIAS by Encare. Encare Enhancing Eras. URL: https:\/\/encare.net\/products-and-services\/eras-interactive-audit-system-eias\/ [Accessed 12-12-2024]"},{"issue":"1","key":"R6","doi-asserted-by":"publisher","DOI":"10.1186\/s13741-021-00209-0","article-title":"Enhanced recovery after surgery protocol and postoperative opioid prescribing for cesarean delivery: an interrupted time series analysis","volume":"10","author":"Langnas","journal-title":"Perioper Med (Lond)"},{"key":"R7","doi-asserted-by":"publisher","DOI":"10.5402\/2012\/368014","article-title":"Fast-track surgery in gynaecology and gynaecologic oncology: a review of a rolling clinical audit","volume":"2012","author":"Carter","journal-title":"ISRN Surg"},{"issue":"7","key":"R8","doi-asserted-by":"publisher","first-page":"840","DOI":"10.1007\/DCR.0b013e31821645bd","article-title":"Enhanced recovery after colon surgery in a community hospital system","volume":"54","author":"Archibald","journal-title":"Dis Colon Rectum"},{"issue":"1","key":"R9","doi-asserted-by":"publisher","first-page":"112","DOI":"10.4103\/jmas.jmas_42_22","article-title":"Intra- and post-operative outcomes in benign gynaecologic surgeries before and after the implementation of enhanced recovery after surgery protocols: a comparison","volume":"19","author":"Sinha","journal-title":"J Minim Access Surg"},{"issue":"4","key":"R10","doi-asserted-by":"publisher","DOI":"10.1001\/jamasurg.2019.6024","article-title":"Association between use of enhanced recovery after surgery protocol and postoperative complications in total hip and knee arthroplasty in the Postoperative Outcomes Within Enhanced Recovery After Surgery Protocol in Elective Total Hip and Knee Arthroplasty Study (POWER2)","volume":"155","author":"Ripoll\u00e9s-Melchor","journal-title":"JAMA Surg"},{"issue":"2","key":"R11","doi-asserted-by":"publisher","DOI":"10.3390\/jpm11020065","article-title":"GENERATOR Breast DataMart\u2014the novel breast cancer data discovery system for research and monitoring: preliminary results and future perspectives","volume":"11","author":"Marazzi","journal-title":"J Pers Med"},{"key":"R12","doi-asserted-by":"publisher","DOI":"10.3389\/fcvm.2023.1104699","article-title":"GENERATOR HEART FAILURE DataMart: an integrated framework for heart failure research","volume":"10","author":"D\u2019Amario","journal-title":"Front Cardiovasc Med"},{"issue":"1","key":"R13","doi-asserted-by":"publisher","DOI":"10.1017\/cts.2020.499","article-title":"Development of an electronic health records datamart to support clinical and population health research","volume":"5","author":"Hurst","journal-title":"J Clin Transl Sci"},{"issue":"3","key":"R14","doi-asserted-by":"publisher","DOI":"10.3390\/ijns8030049","article-title":"Developing an online dashboard to visualize performance data\u2014Tennessee newborn screening experience","volume":"8","author":"Lechner","journal-title":"Int J Neonatal Screen"},{"issue":"5","key":"R15","doi-asserted-by":"publisher","DOI":"10.1002\/lio2.1315","article-title":"Implementation and impact of a surgical dashboard on pediatric tonsillectomy outcomes: a quality improvement study","volume":"9","author":"Dang","journal-title":"Laryngoscope Investig Otolaryngol"},{"issue":"4","key":"R16","doi-asserted-by":"publisher","DOI":"10.1136\/bmjoq-2022-002033","article-title":"Evaluating a novel, integrative dashboard for health professionals\u2019 performance in managing deteriorating patients: a quality improvement project","volume":"11","author":"Alhmoud","journal-title":"BMJ Open Qual"}],"container-title":["JMIR Perioperative Medicine"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/periop.jmir.org\/2026\/1\/e82472","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2026,6,30]],"date-time":"2026-06-30T18:16:26Z","timestamp":1782843386000},"score":1,"resource":{"primary":{"URL":"https:\/\/periop.jmir.org\/2026\/1\/e82472"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2026,2,11]]},"references-count":16,"URL":"https:\/\/doi.org\/10.2196\/82472","relation":{},"ISSN":["2561-9128"],"issn-type":[{"value":"2561-9128","type":"electronic"}],"subject":[],"published":{"date-parts":[[2026,2,11]]},"article-number":"v9i1e82472"}}