Abstract
ABSTRACTPurposeTo 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.MethodsA 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. A secure Tableau instance hosts end-user visualizations, with minimal software development required.ResultsMMFP-Tableau, named for its origin in the Mitochondrial Medicine Frontier Program (MMFP) at Children’s Hospital of Philadelphia, facilitates direct access to integrated, highly robust health system datasets. This scalable data solution enables integration of 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.ConclusionMMFP-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. This approach represents a generalizable workflow concept readily adaptable to implement across diverse fields of medicine
Publisher
Cold Spring Harbor Laboratory