2019 Tutorial – Extraction, Transformation, and Load Process (ETL)

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

Videos

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

Watch on YouTube

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

Materials on Github – Includes readme files, AWS setup, recommended readings and slides
Tutorial Slides

Sponsors
bayer1jsn_logo_jj_vert_color_rgb