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.
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.If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
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.
E N D
Presentation Transcript
E T L ALPHA OMOP Tathagata Bhattacharjee Tathagata Bhattacharjee
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)
Mapping ALPHA - Residencies to OMOP Source Data Mapping Approach to CDMV6.0
Mapping ALPHA - Residencies to OMOP Table name: OMOP - person
ETL Workflow (On-Ramping) Data Profiling Staging Database Data Mapping ALPHA -> OMOP OMOP CDM Database Site Specific Folder Profiling Report Data Owner
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
