About this Course

10,356 recent views

100% online

Start instantly and learn at your own schedule.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Intermediate Level

Approx. 20 hours to complete

Suggested: 5 weeks of study, 2-4 hours/week...

English

Subtitles: English

100% online

Start instantly and learn at your own schedule.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Intermediate Level

Approx. 20 hours to complete

Suggested: 5 weeks of study, 2-4 hours/week...

English

Subtitles: English

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

About University of Colorado System

The University of Colorado is a recognized leader in higher education on the national and global stage. We collaborate to meet the diverse needs of our students and communities. We promote innovation, encourage discovery and support the extension of knowledge in ways unique to the state of Colorado and beyond....

Frequently Asked Questions

  • Once you enroll for a Certificate, you’ll have access to all videos, quizzes, and programming assignments (if applicable). Peer review assignments can only be submitted and reviewed once your session has begun. If you choose to explore the course without purchasing, you may not be able to access certain assignments.

  • When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.

More questions? Visit the Learner Help Center.