lable business intelligence (BI) platform. As a primary outcome, we discuss some performance metrics of the dashboards, and as a secondary outcome, we outline some operational enhancements and financial savings associated with deploying the dashboards. METHODS: Data were transferred from the EHR to our departmental servers using several parallel processes. A custom structured query language (SQL) query was written to extract the relevant data fields and to clean the data. Tableau was used to design multiple dashboards for clinical operation, performance improvement, and business management. RESULTS: Before deployment of the dashboards, detailed case counts and attributions were available for the operating rooms (ORs) from perioperative services; however, the same level of detail was not available for non-OR locations. Deployment of the yearly case count dashboards provided near-real–time case count information from both central and non-OR locations among multiple campuses, which was not previously available. The visual presentation of monthly data for each year allowed us to recognize seasonality in case volumes and adjust our supply chain to prevent shortages. The dashboards highlighted the systemwide volume of cases in our endoscopy suites, which allowed us to target these supplies for pricing negotiations, with an estimated annual cost savings of $250,000. Our central venous pressure (CVP) dashboard enabled us to provide individual practitioner feedback, thus increasing our monthly CVP checklist compliance from approximately 92% to 99%. CONCLUSIONS: The customization and visualization of EHR data are both possible and worthwhile for the leveraging of information into easily comprehensible and actionable data for the improvement of health care provision and practice management. Limitations inherent to EHR data presentation make this customization necessary, and continued open access to the underlying data set is essential....

中文翻译：

---

可视化分析以利用麻醉电子健康记录

标签商业智能（BI）平台。作为主要成果，我们讨论了仪表板的一些性能指标，作为次要成果，我们概述了与部署仪表板相关的一些运营增强和财务节省。方法：使用多个并行进程将数据从 EHR 传输到我们的部门服务器。编写了自定义结构化查询语言 (SQL) 查询以提取相关数据字段并清理数据。Tableau 用于为临床操作、绩效改进和业务管理设计多个仪表板。结果：在部署仪表板之前，可以从围手术期服务中获得手术室 (OR) 的详细病例计数和归因；但是，对于非手术室地点，没有相同级别的详细信息。年度病例计数仪表板的部署提供了来自多个校区的中心和非 OR 位置的近实时病例计数信息，这在以前是不可用的。每年月度数据的可视化呈现使我们能够识别案例数量的季节性并调整我们的供应链以防止短缺。仪表板突出显示了我们内窥镜检查室中全系统的病例数量，这使我们能够针对这些用品进行定价谈判，估计每年可节省 250,000 美元的成本。我们的中心静脉压 (CVP) 仪表板使我们能够提供个体从业者反馈，从而将我们每月的 CVP 检查表合规性从大约 92% 提高到 99%。结论：EHR 数据的定制和可视化对于将信息转化为易于理解和可操作的数据以改善医疗保健提供和实践管理来说既是可能的也是值得的。EHR 数据呈现固有的局限性使得这种定制成为必要，并且对基础数据集的持续开放访问是必不可少的......