Implementation of a Self-Service Data Exploration Tool Within an Academic Medical Center Department of Pharmacy

Purpose: The validation and implementation of a self-service data exploration and reporting tool in an academic medical center is described. Summary: Macro-level data is abundant within hospitals and health systems. In the absence of a data scientist, other solutions were explored within Medical University of South Carolina (MUSC) Health pharmacy's technology. A data exploration tool within the electronic health record was validated for widespread use. Based on limited experiences, an educational session was conducted to satisfy Practice Advancement Initiative (PAI) 2030 recommendations for staff competence and personnel professional development desires. Epic SlicerDicer was leveraged by frontline staff for data-driven decision-making in operational and clinical arenas. The MUSC Health Department of Pharmacy incorporated the tool into a data-driven culture. The tool had widespread use upon implementation. After disseminating the tool, impact was measured and evaluated. Its utility impacted operations, drug distribution, formulary management, resident research, quality improvement, and staff satisfaction. There now exists an accessible tool for staff to utilize on-demand for data-driven recommendations and interventions. Conclusion: A data exploration tool within the electronic health record improved operational efficiency, cost savings, and research productivity. It offers elevated decision-making and enhanced professional development for staff.