Integrating clinical and laboratory data for exploration and analysis: Clinical Laboratory Information Portal (CLIP)

Authors

• MA Makiya
• AJ Glogowski
• HA Abbasi
• T Ahmed
• S Xu
• KQ Chukwurah
• BB Smith
• AD Klion

Abstract

Studies conducted in the Human Eosinophil Section generate clinical and internal laboratory data that reside in disparate sources (NIH data repositories, internal Excel files, etc.). Moreover, the data span multiple years across multiple clinical protocols for a single patient. Researchers needed a way to conduct ad-hoc queries and visualize data for patients and lab tests across these disparate data sources throughout the data collection process, without relying on technical resources. To address these issues, we developed a knowledge management platform called Clinical Laboratory Information Portal (CLIP) to help clinical researchers integrate and access their clinical and laboratory data from a single location. Data were transformed and mapped to Research Trust, a data model that is compatible with common biomedical and clinical models. Data were then loaded into a secure SQL server environment. Through interactive visualizations created in Tableau, researchers can query and visualize data for patients at an individual or aggregate level for clinical observations and lab tests of interest. Selected data for patient cohorts of interest can be exported to Excel for further analysis. By removing data integration and analysis challenges, CLIP allows researchers to spend time on identifying trends, outliers, and gaining other insights from their data as it is collected.

Scientific Focus Area: Research Support Services

This page was last updated on Friday, March 26, 2021