Deep Dive into ETL Workflow for Integrating OMOP Data Models

This content delves into the process of ETL (Extract, Transform, Load) for integrating OMOP (Observational Medical Outcomes Partnership) data models, focusing on mapping ALPHA residencies to the OMOP person table. It covers loading data, data profiling, and mapping strategies in a detailed demonstration.

• ETL
• OMOP
• Data Integration
• Data Modeling
• Mapping Strategies

belen Follow

Uploaded on Jul 22, 2024 | 1 Views

Download Presentation

Please find below an Image/Link to download the presentation.

The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.

Presentation Transcript

1. E T L ALPHA OMOP Tathagata Bhattacharjee Tathagata Bhattacharjee

2. Analysing Longitudinal Population-based HIV/AIDS data on Africa (ALPHA) ALPHA Data Spec Residencies (ALPHA 6.1) ALPHA Data Spec HIV Testing (ALPHA 6.2b) Observational Medical Outcomes Partnership Common Data Model (OMOP CDM)

3. Mapping ALPHA - Residencies to OMOP Source Data Mapping Approach to CDMV6.0

4. Mapping ALPHA - Residencies to OMOP Table name: OMOP - person

6. Deep dive into OMOP CDM staging area

7. ETL Workflow (On-Ramping) Data Profiling Staging Database Data Mapping ALPHA -> OMOP OMOP CDM Database Site Specific Folder Profiling Report Data Owner

8. Demonstration This demonstration will focus on the following: Loading data into the staging database Data profiling and profiling report Mapping from ALPHA Residencies to OMOP person table

9. Thank you