Learn about best practices and OHDSI tools developed to help with designing an extract, transform, & load process to take your database from raw observational data to the OMOP Common Data Model.
Target Audience: Data holders, researchers, and regulators who want to learn more about the Extraction, Transformation, and Load process.
Course prerequisites: knowledge of OMOP CDM & Vocabulary Tutorial or working experience with the OMOP CDM and OMOP Vocabulary.
Faculty: Clair Blacketer, Erica Voss
2019 OHDSI Tutorials – Extraction, Transformation, and Load Process (ETL) (1 of 3)
Introduction
2019 OHDSI Tutorials – Extraction, Transformation, and Load Process (ETL) (2 of 3)
Data Model Vocabulary Mapping
2019 OHDSI Tutorials – Extraction, Transformation, and Load Process (ETL) (3 of 3)
Data Quality
2019 OHDSI Tutorials – Extraction, Transformation, and Load Process (ETL) (1 of 3)
2019 OHDSI Tutorials – Extraction, Transformation, and Load Process (ETL) (2 of 3)
2019 OHDSI Tutorials – Extraction, Transformation, and Load Process (ETL) (3 of 3)
Materials on Github – Includes readme files, AWS setup, recommended readings and slides
Tutorial Slides
