Abstract
OBJECTIVE: To describe a novel data integration workflow developed to automate clinical and research electronic health system data integration and harmonization from siloed sources for centralized access, visualization and analysis by clinicians and researchers in an end user-friendly customized analytic platform. MATERIALS AND METHODS: A centralized, semi-automated framework provides data provenance and user access to integrated data sources. Data models are implemented leveraging a centralized server (Alteryx) for high-level analytics including scheduling, integration, and modeling. Data are then sent to a secure Tableau instance for end-user visualization and interaction, with minimal software development required. RESULTS: MMFP-Tableau, named for its origin in the Mitochondrial Medicine Frontier Program (MMFP) at the Children's Hospital of Philadelphia (CHOP), has advanced efforts to realize precision medicine by facilitating expert clinician and researcher end-user direct access to integrated, highly robust health system datasets. This scalable data solution enables translational researchers to link subject and cohort clinical and research parameters with research samples; enhances external biopharma collaborations for clinical trial design, subject recruitment, and data tracking; accelerates retrospective clinical cohort data analysis; and improves complex data visualization for clinicians and researchers. DISCUSSION: MMFP-Tableau promotes complex data integration, visibility, and advanced analytic capabilities to facilitate seamless multidisciplinary research, benefitting clinical care and research in rare disease patients and cohorts. CONCLUSION: The MMFP-Tableau data platform integrates multiple data sources across various siloed data platforms to transform complex data into readily accessible datasets. This approach represents a generalizable workflow concept readily adaptable to implement across diverse fields of medicine.