Abstract:Background: Visual analytics is the science of analytical reasoning supported by interactive visual interfaces called dashboards. In this report, we describe our experience addressing the challenges in visual analytics of anesthesia electronic health record (EHR) data using a commercially available 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.

Leveraging business intelligence to make better decisions: Part II

Closed-loop control in EMR based on a BI system

Do-It-Yourself Business Intelligence for the Radiologist-Lessons Learned From 10-Year Trends in an Abdominal Imaging Division at a Tertiary Medical Center

Utilizing Data Analytics And Business Intelligence Tools In Laboratory Workflow

Business intelligence and the leverage of information in healthcare organizations from a managerial perspective: a systematic literature review and research agenda

Using Behavioral Insights to Strengthen Strategies for Change. Practical Applications for Quality Improvement in Healthcare

Exploring business intelligence applications in the healthcare industry: A comprehensive analysis

Elaborating the Role of Business Intelligence (BI) in Healthcare Management

Visual Analytics to Leverage Anesthesia Electronic Health Record

The Effects of Using Business Intelligence Systems on an Excellence Management and Decision-Making Process by Start-Up Companies: A Case Study

Business Analytics in Healthcare: Past, Present, and Future Trends

Improving the Efficiency and Ease of Healthcare Analysis Through Use of Data Visualization Dashboards

Sharing adverse drug event data using business intelligence technology

Performance management in small practices

Improving pathology reports using business intelligence techniques: An experimental study

The Application of Collaborative Business Intelligence Technology in the Hospital SPD Logistics Management Model

Applicability and potentiality in the use of Business Intelligence tools in Primary Health Care

The Use of Business Intelligence Software to Monitor Key Performance Indicators (KPIs) for the Evaluation of a Computerized Maintenance Management System (CMMS)

Case study: how to apply data mining techniques in a healthcare data warehouse

Enterprise imaging: planning and business justification

Using a Clinical Data Warehouse to Calculate and Present Key Metrics for the Radiology Department: Implementation and Performance Evaluation