About this Course

7,257 recent views
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Flexible deadlines
Reset deadlines in accordance to your schedule.
Intermediate Level
Approx. 17 hours to complete
English
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Flexible deadlines
Reset deadlines in accordance to your schedule.
Intermediate Level
Approx. 17 hours to complete
English

Offered by

Placeholder

University of Colorado System

Syllabus - What you will learn from this course

Week
1

Week 1

4 hours to complete

Introduction: Clinical Data Models and Common Data Models

4 hours to complete
9 videos (Total 54 min), 4 readings, 1 quiz
9 videos
Clinical Research Data Warehouses9m
Entity Relationship Diagrams (ERDs)4m
Clinical Data Models4m
Why Common Data Models?10m
A Quick Tour of a Common Data Model: i2b26m
A Quick Tour of a Common Data Model: OMOP5m
A Quick Tour of a Common Data Model: Sentinel6m
A Quick Tour of a Common Data Model: PCORNet5m
4 readings
Introduction to Specialization Instructors5m
Course Policies5m
Accessing Course Data and Technology Platform15m
Readings and Course Materials for Module 12h
1 practice exercise
Clinical Data Models and Common Data Models30m
Week
2

Week 2

3 hours to complete

Tools: Querying Clinical Data Models

3 hours to complete
6 videos (Total 59 min), 1 reading, 1 quiz
6 videos
Querying MIMIC-III9m
A Deep Dive into OMOP Data Model13m
Querying OMOP12m
Comparing the MIMIC and OMOP Data Models10m
The OHDSI Community Ecosystem7m
1 reading
Readings and Course Materials for Module 21h 30m
1 practice exercise
Tools: Querying Clinical Data Models30m
Week
3

Week 3

3 hours to complete

Techniques: Extract-Transform-Load and Terminology Mapping

3 hours to complete
6 videos (Total 53 min), 1 reading, 1 quiz
6 videos
Structural versus Terminology Mapping6m
Data Profiling with White Rabbit10m
Data Mapping with the Rabbit in a Hat Tool9m
Terminology Mapping10m
Example mapping of MIMIC Patient to OMOP Person8m
1 reading
Readings and Course Materials for Module 32h
1 practice exercise
Techniques: Extract-Transform-Load and Terminology Mapping30m
Week
4

Week 4

3 hours to complete

Techniques: Data Quality Assessments

3 hours to complete
5 videos (Total 52 min), 1 reading, 1 quiz
5 videos
Data profiling for data quality assessment10m
Data quality assessment using SQL13m
Callahan and Khare rules8m
OHDSI Achilles and Achilles Heel12m
1 reading
Readings and Course Materials for Module 41h 30m
1 practice exercise
Techniques: Data Quality Assessments30m

Reviews

TOP REVIEWS FROM CLINICAL DATA MODELS AND DATA QUALITY ASSESSMENTS

View all reviews

Frequently Asked Questions

More questions? Visit the Learner Help Center.