554 MyCTSC: An open-source solution to harmonizing multiple data sources to improve managing, evaluating, and marketing the clinical and translational science collaborative (CTSC) of Northern Ohio

Abstract

Objectives/Goals: MyCTSC harmonizes data from many sources into one database for evaluation, marketing, and CTSC member management to address current disparate collection and siloed use of data. It simplifies report creation with real-time dashboards so administrators and leadership can view progress quickly and plan for improvements based on real-time data. Methods/Study Population: MyCTSC is built using open-source software like Python, Django, MariaDB, Bootstrap, and Chart.js, and integrates data from sources such as systems for consult requests, pilot/voucher applications, and REDCap surveys. Each data source is imported into the warehouse either automatically via API, if available, or via manual file upload. De-duplication and other data cleaning are performed as well. Customized, real-time dashboards are developed based on the needs of administrators and leadership. While MyCTSC does not have a study population, it does have the stakeholders mentioned above as well as leadership. The development timeline spans three years: initial development and data warehouse population in Year 1, data cleaning and dashboard creation in Year 2, and full rollout to all CTSC members in Year 3. Results/Anticipated Results: MyCTSC aims to create a seamless data and member management system to resolve issues stemming from multiple data sources. Demographic challenges are addressed by implementing data cleaning and consolidating duplicate identities into a single profile. The initiative will enhance stakeholder buy-in by presenting evaluation use cases that show the impacts of CTSC resources. For example, workforce development needs will be met through surveys and integration of a course catalog. MyCTSC will also facilitate targeted resource and event advertising, and support investigator outreach and collaboration by utilizing dashboards and reports. Furthermore, it will serve as the consolidated data source for all CTSC modules, promoting greater interaction and collaboration across administration and modules. Discussion/Significance of Impact: MyCTSC integrates multiple sources, consolidates identities, and simplifies reporting for outreach and collaboration. It enhances interaction with researchers and community members, advancing translational science by linking projects and publications. MyCTSC, built with open-source software, can be made available to other CTSA hubs.