К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Clinical Data Models and Data Quality Assessments · LearnSpace
Назад в каталог
courseraАнализ данных

Clinical Data Models and Data Quality Assessments

Курс от University of Colorado System
Средний≈ 17.5 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

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.

Навыки, которые вы освоите

Data QualityData ModelingRelational DatabasesExtract, Transform, LoadQuery LanguagesSQLData IntegrityDatabase DesignData IntegrationClinical Data ManagementData MappingData ValidationData TransformationHealth InformaticsData Dictionary

Программа курса

5 модулей · 46 учебных материалов

01Introduction: Clinical Data Models and Common Data Models15 материалов

Welcome to Clinical Data Models and Common Data Models

Welcome to Clinical Data Models and Data Quality AssessmentsВидеоGet help and meet other learners in this course. Join your discussion forums!Чтение

Introduction to Instructors

Introduction to Specialization InstructorsЧтение

Getting Started

Учитесь у экспертов

Laura K. Wiley, PhD

Associate Professor

Michael G. Kahn, MD, PhD

Professor of Clinical Informatics

Clinical Data Models and Data Quality Assessments
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 17.5 ч

5 модулей

Язык: Английский

Субтитры: Арабский, Французский, Украинский, Китайский (Китай), Греческий, Итальянский, Бразильский португальский, Нидерландский, Корейский, Немецкий, Русский, Тайский, Индонезийский, Шведский, Турецкий, Испанский, Хинди, Японский, Казахский, Польский

Часть программы вашего университета
Course PoliciesЧтение
Accessing Course Data and Technology PlatformЧтение

Clinical Research Data Warehouses

Clinical Research Data WarehousesВидео

Entity Relationship Diagrams (ERDs)

Entity Relationship Diagrams (ERDs)Видео

Clinical Data Models

Clinical Data ModelsВидео

Why Common Data Models?

Why Common Data Models?Видео

A Quick Tour of a Common Data Model: i2b2

A Quick Tour of a Common Data Model: i2b2Видео

A Quick Tour of a Common Data Model: OMOP

A Quick Tour of a Common Data Model: OMOPВидео

A Quick Tour of a Common Data Model: Sentinel

A Quick Tour of a Common Data Model: SentinelВидео

A Quick Tour of a Common Data Model: PCORNet

A Quick Tour of a Common Data Model: PCORNetВидео

Readings and Course Materials for Module 1

Readings and Course Materials for Module 1Чтение

Summative Assessment

Clinical Data Models and Common Data ModelsЗадание
02Tools: Querying Clinical Data Models8 материалов

A Deep Dive into the MIMIC-III Data Model

A Deep Dive into the MIMIC-III Data ModelВидео

Querying MIMIC-III

Querying MIMIC-IIIВидео

A Deep Dive into OMOP Data Model

A Deep Dive into OMOP Data ModelВидео

Querying OMOP

Querying OMOPВидео

Comparing the MIMIC and OMOP Data Models

Comparing the MIMIC and OMOP Data ModelsВидео

The OHDSI Community Ecosystem

The OHDSI Community EcosystemВидео

Readings and Course Materials for Module 2

Readings and Course Materials for Module 2Чтение

Summative Assessment

Tools: Querying Clinical Data ModelsЗадание
03Techniques: Extract-Transform-Load and Terminology Mapping8 материалов

The ETL task

The ETL TaskВидео

Structural versus Terminology Mapping

Structural versus Terminology MappingВидео

Data Profiling with White Rabbit

Data Profiling with White RabbitВидео

Data Mapping with the Rabbit in a Hat tool

Data Mapping with the Rabbit in a Hat ToolВидео

Terminology Mapping

Terminology MappingВидео

Example mapping of MIMIC Patient to OMOP Person

Example mapping of MIMIC Patient to OMOP PersonВидео

Readings and Course Materials for Module 3

Readings and Course Materials for Module 3Чтение

Summative Assessment

Techniques: Extract-Transform-Load and Terminology MappingЗадание
04Techniques: Data Quality Assessments7 материалов

Data quality dimensions / fitness for use

Data quality dimensions / fitness for useВидео

Data profiling for data quality assessment

Data profiling for data quality assessmentВидео

Data quality assessment using SQL

Data quality assessment using SQLВидео

Callahan and Khare rules

Callahan and Khare rulesВидео

OHDSI Achilles and Achilles Heel

OHDSI Achilles and Achilles HeelВидео

Readings and Course Materials for Module 4

Readings and Course Materials for Module 4Чтение

Summative Assessment

Techniques: Data Quality AssessmentsЗадание
05Practical Application: Create an ETL Process to Transform a MIMIC-III Table to OMOP8 материалов

Welcome to Practical Applications!

Welcome to Practical Applications!Чтение

Review of the ETL process

Review of the ETL processВидео

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

Example: Transforming MIMIC Patient to OMOP Person Steps 1 and 2Видео

Example: Transforming MIMIC Patient to OMOP Person Step 3

Example: Transforming MIMIC Patient to OMOP Person Step3Видео

Example: Transforming MIMIC Patient to OMOP Person Step 4

Example: Transforming MIMIC Patient to OMOP Person Step 4Видео

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

Example: Transforming MIMIC Patient to OMOP Person Steps 5 and 6Видео

Example: Transforming MIMIC Patient to OMOP Person Step 7

Example: Transforming MIMIC Patient to OMOP Person Step 7Видео

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

Practical Application Project: Create an ETL Process to Transform a MIMIC-III Table to OMOPВзаимная проверка