OMOP Common Data Model and Extract, Transform & Load Tutorial

Key Info
URL - the landing page for the learning resource: 
https://www.ohdsi.org/common-data-model-and-extract-transform-and-load-tutorial/
Description - a brief synopsis, abstract or summary of what the learning resource is about: 

In this tutorial you will learn about the details of the Observational Medical Outcomes Partnership (OMOP) Common Data Model  (CDM) and how to apply it to Extract, Transform & Load (ETL) data.  The OMOP Common Data Model allows for the systematic analysis of disparate observational databases. The concept behind this approach is to transform data contained within those databases into a common format (data model) as well as a common representation (terminologies, vocabularies, coding schemes), and then perform systematic analyses using a library of standard analytic routines that have been written based on the common format.  In this tutorial, you can observe Best practices of converting data into a data module.
Topics covered within this tutorial include:  
-What is OMOP/OHDSI?
-OMOP Common Data Model (CDM)– Why and How
- How to retrieve data from OMOP CDM
-Setup and Performing of an Extract Transform and Load process into the CDM
-Using WhiteRabbit and Rabbit-In-A-Hat to Build an ETL
- Testing and Quality Assurance

Included with the video presentation of the tutorial include:
Tutorial slides
CDM_QUERY_EXAMPLES.sql
CDM_QUERY_EXAMPLES_EXTRAS.sql
OHDSI-in-a-box
TUTORIAL_ScanReport.xlsx

The OHDSI Common Data Model and Extract, Transform & Load Tutorial took place on September 24rd, 2016 during the 2016 OHDSI Symposium. Recordings were made possible by the generous support of Johnson & Johnson, the JKTG Foundation, and Pfizer.

Authoring Person(s) Name: 
Rimma Belenkaya
Mark Velez
Karthik Natarajan
Erica Voss
Authoring Organization(s) Name: 
The Observational Health Data Sciences and Informatics(OHDSI)
License - link to legal statement specifying the copyright status of the learning resource: 
Standard YouTube License
Access Cost: 
No fee
Primary language(s) in which the learning resource was originally published or made available: 
English
More info about
Keywords - short phrases describing what the learning resource is about: 
Community standards
Data management
Data modeling
Data skills education
Data transformation
Data usage
Data warehousing
Structured Query Language (SQL)
Subject Discipline - subject domain(s) toward which the learning resource is targeted: 
Medicine and Health Sciences
Published / Broadcast: 
Saturday, September 24, 2016
Publisher - organization credited with publishing or broadcasting the learning resource: 
The Observational Health Data Sciences and Informatics(OHDSI)
Media Type - designation of the form in which the content of the learning resource is represented, e.g., moving image: 
Collection - a group or set of items that comprise a single learning resource, e.g., a PDF version of a slide presentation, an audio file of the presentation and a textual representation of the oral transcription of the presentation.
Contributor Organization(s): 
Name: 
Johnson and Johnson
Type: 
Funding and sponsorship
Name: 
Jayne Koskinas Ted Giovanis (JKTG) Foundation
Type: 
Funding and sponsorship
Name: 
Pfizer Inc.
Type: 
Funding and sponsorship
Educational Info
Purpose - primary educational reason for which the learning resource was created: 
Instruction - detailed information about aspects or processes related to data management or data skills.
Learning Resource Type - category of the learning resource from the point of view of a professional educator: 
Learning Activity - guided or unguided activity engaged in by a learner to acquire skills, concepts, or knowledge that may or may not be defined by a lesson. Examples: data exercises, data recipes.
Target Audience - intended audience for which the learning resource was created: 
Data manager
Early-career research scientist
Graduate student
Mid-career research scientist
Research faculty
Research scientist
Intended time to complete - approximate amount of time the average student will take to complete the learning resource: 
More than 1 hour (but less than 1 day)