Monthly Subscription Starting at AED 99 + VAT

Clinical Data Models and Data Quality Assessments
  • Level Professional
  • Duration 18 hours
  • Course by University of Colorado System
  • Offered by

About

This course aims to teach the concepts of clinical data models and common data models. Upon completion of this course, learners will be able to interpret and evaluate data model designs using Entity-Relationship Diagrams (ERDs), differentiate between data models and articulate how each are used to support clinical care and data science, and create SQL statements in Google BigQuery to query the MIMIC3 clinical data model and the OMOP common data model.

Modules

Welcome to Clinical Data Models and Common Data Models

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Welcome to Clinical Data Models and Data Quality Assessments

1 Readings

  • Get help and meet other learners in this course. Join your discussion forums!

Introduction to Instructors

    • 1 Readings
Show info about module content

1 Readings

  • Introduction to Specialization Instructors

Getting Started

    • 2 Readings
Show info about module content

2 Readings

  • Course Policies
  • Accessing Course Data and Technology Platform

Clinical Research Data Warehouses

    • 1 Videos
Show info about module content

1 Videos

  • Clinical Research Data Warehouses

Entity Relationship Diagrams (ERDs)

    • 1 Videos
Show info about module content

1 Videos

  • Entity Relationship Diagrams (ERDs)

Clinical Data Models

    • 1 Videos
Show info about module content

1 Videos

  • Clinical Data Models

Why Common Data Models?

    • 1 Videos
Show info about module content

1 Videos

  • Why Common Data Models?

A Quick Tour of a Common Data Model: i2b2

    • 1 Videos
Show info about module content

1 Videos

  • A Quick Tour of a Common Data Model: i2b2

A Quick Tour of a Common Data Model: OMOP

    • 1 Videos
Show info about module content

1 Videos

  • A Quick Tour of a Common Data Model: OMOP

A Quick Tour of a Common Data Model: Sentinel

    • 1 Videos
Show info about module content

1 Videos

  • A Quick Tour of a Common Data Model: Sentinel

A Quick Tour of a Common Data Model: PCORNet

    • 1 Videos
Show info about module content

1 Videos

  • A Quick Tour of a Common Data Model: PCORNet

Readings and Course Materials for Module 1

    • 1 Readings
Show info about module content

1 Readings

  • Readings and Course Materials for Module 1

Summative Assessment

    • 1 Assignment
Show info about module content

1 Assignment

  • Clinical Data Models and Common Data Models

A Deep Dive into the MIMIC-III Data Model

    • 1 Videos
Show info about module content

1 Videos

  • A Deep Dive into the MIMIC-III Data Model

Querying MIMIC-III

    • 1 Videos
Show info about module content

1 Videos

  • Querying MIMIC-III

A Deep Dive into OMOP Data Model

    • 1 Videos
Show info about module content

1 Videos

  • A Deep Dive into OMOP Data Model

Querying OMOP

    • 1 Videos
Show info about module content

1 Videos

  • Querying OMOP

Comparing the MIMIC and OMOP Data Models

    • 1 Videos
Show info about module content

1 Videos

  • Comparing the MIMIC and OMOP Data Models

The OHDSI Community Ecosystem

    • 1 Videos
Show info about module content

1 Videos

  • The OHDSI Community Ecosystem

Readings and Course Materials for Module 2

    • 1 Readings
Show info about module content

1 Readings

  • Readings and Course Materials for Module 2

Summative Assessment

    • 1 Assignment
Show info about module content

1 Assignment

  • Tools: Querying Clinical Data Models

The ETL task

    • 1 Videos
Show info about module content

1 Videos

  • The ETL Task

Structural versus Terminology Mapping

    • 1 Videos
Show info about module content

1 Videos

  • Structural versus Terminology Mapping

Data Profiling with White Rabbit

    • 1 Videos
Show info about module content

1 Videos

  • Data Profiling with White Rabbit

Data Mapping with the Rabbit in a Hat tool

    • 1 Videos
Show info about module content

1 Videos

  • Data Mapping with the Rabbit in a Hat Tool

Terminology Mapping

    • 1 Videos
Show info about module content

1 Videos

  • Terminology Mapping

Example mapping of MIMIC Patient to OMOP Person

    • 1 Videos
Show info about module content

1 Videos

  • Example mapping of MIMIC Patient to OMOP Person

Readings and Course Materials for Module 3

    • 1 Readings
Show info about module content

1 Readings

  • Readings and Course Materials for Module 3

Summative Assessment

    • 1 Assignment
Show info about module content

1 Assignment

  • Techniques: Extract-Transform-Load and Terminology Mapping

Data quality dimensions / fitness for use

    • 1 Videos
Show info about module content

1 Videos

  • Data quality dimensions / fitness for use

Data profiling for data quality assessment

    • 1 Videos
Show info about module content

1 Videos

  • Data profiling for data quality assessment

Data quality assessment using SQL

    • 1 Videos
Show info about module content

1 Videos

  • Data quality assessment using SQL

Callahan and Khare rules

    • 1 Videos
Show info about module content

1 Videos

  • Callahan and Khare rules

OHDSI Achilles and Achilles Heel

    • 1 Videos
Show info about module content

1 Videos

  • OHDSI Achilles and Achilles Heel

Readings and Course Materials for Module 4

    • 1 Readings
Show info about module content

1 Readings

  • Readings and Course Materials for Module 4

Summative Assessment

    • 1 Assignment
Show info about module content

1 Assignment

  • Techniques: Data Quality Assessments

Welcome to Practical Applications!

    • 1 Readings
Show info about module content

1 Readings

  • Welcome to Practical Applications!

Review of the ETL process

    • 1 Videos
Show info about module content

1 Videos

  • Review of the ETL process

Example: Transforming MIMIC Patient to OMOP Person Steps 1 and 2

    • 1 Videos
Show info about module content

1 Videos

  • Example: Transforming MIMIC Patient to OMOP Person Steps 1 and 2

Example: Transforming MIMIC Patient to OMOP Person Step 3

    • 1 Videos
Show info about module content

1 Videos

  • Example: Transforming MIMIC Patient to OMOP Person Step3

Example: Transforming MIMIC Patient to OMOP Person Step 4

    • 1 Videos
Show info about module content

1 Videos

  • Example: Transforming MIMIC Patient to OMOP Person Step 4

Example: Transforming MIMIC Patient to OMOP Person Steps 5 and 6

    • 1 Videos
Show info about module content

1 Videos

  • Example: Transforming MIMIC Patient to OMOP Person Steps 5 and 6

Example: Transforming MIMIC Patient to OMOP Person Step 7

    • 1 Videos
Show info about module content

1 Videos

  • Example: Transforming MIMIC Patient to OMOP Person Step 7

Practical Application Project: Create an ETL Process to Transform a MIMIC-III Table to OMOP

    • 1 PeerReview
Show info about module content

1 Peer Review

  • Practical Application Project: Create an ETL Process to Transform a MIMIC-III Table to OMOP

Auto Summary

Explore "Clinical Data Models and Data Quality Assessments" on Coursera, a professional-level course in the Data Science & AI domain. Learn to interpret clinical data models, use Entity-Relationship Diagrams, and create SQL queries in Google BigQuery for MIMIC3 and OMOP models. Ideal for professionals, the course spans 1080 minutes and offers a Starter subscription.

Laura K. Wiley, PhD
Instructors

Laura K. Wiley, PhD

Michael G. Kahn, MD, PhD
Instructors

Michael G. Kahn, MD, PhD