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.
提供方
Clinical Data Science 專項課程科罗拉多大学系统課程信息
7,677 次近期查看
學生職業成果
40%
通過此課程獲得實實在在的工作福利
25%
加薪或升職
可分享的證書
完成後獲得證書
100% 在線
立即開始，按照自己的計劃學習。
第 2 門課程（共 6 門）
可靈活調整截止日期
根據您的日程表重置截止日期。
中級
完成時間大約為17 小時
英語（English）
字幕：英語（English）
學生職業成果
40%
通過此課程獲得實實在在的工作福利
25%
加薪或升職
可分享的證書
完成後獲得證書
100% 在線
立即開始，按照自己的計劃學習。
第 2 門課程（共 6 門）
可靈活調整截止日期
根據您的日程表重置截止日期。
中級
完成時間大約為17 小時
英語（English）
字幕：英語（English）
提供方
科罗拉多大学系统
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.
教學大綱 - 您將從這門課程中學到什麼
完成時間為 4 小時
Introduction: Clinical Data Models and Common Data Models
This week describes clinical data models and explains the need for and use of common data models in national and international data networks. We will also cover the features of Entity-Relationship Diagrams (ERDs) to describe the key technical features of data models.
完成時間為 4 小時
9 個視頻 （總計 54 分鐘）, 4 個閱讀材料, 1 個測驗
9 個視頻
Clinical Research Data Warehouses9分鐘
Entity Relationship Diagrams (ERDs)4分鐘
Clinical Data Models4分鐘
Why Common Data Models?10分鐘
A Quick Tour of a Common Data Model: i2b26分鐘
A Quick Tour of a Common Data Model: OMOP5分鐘
A Quick Tour of a Common Data Model: Sentinel6分鐘
A Quick Tour of a Common Data Model: PCORNet5分鐘
4 個閱讀材料
Introduction to Specialization Instructors5分鐘
Course Policies5分鐘
Accessing Course Data and Technology Platform15分鐘
Readings and Course Materials for Module 12小時
1 個練習
Clinical Data Models and Common Data Models30分鐘
完成時間為 3 小時
Tools: Querying Clinical Data Models
We take a deep dive into the technical features of clinical data models using MIMIC3 as our example and research common data models using OMOP as our example.
完成時間為 3 小時
6 個視頻 （總計 59 分鐘）, 1 個閱讀材料, 1 個測驗
6 個視頻
Querying MIMIC-III9分鐘
A Deep Dive into OMOP Data Model13分鐘
Querying OMOP12分鐘
Comparing the MIMIC and OMOP Data Models10分鐘
The OHDSI Community Ecosystem7分鐘
1 個閱讀材料
Readings and Course Materials for Module 21 小時 30 分
1 個練習
Tools: Querying Clinical Data Models30分鐘
完成時間為 3 小時
Techniques: Extract-Transform-Load and Terminology Mapping
This module teaches learners about the processes and challenges with extracting, transforming and loading (ETL) data with real-world examples in data and terminology mapping.
完成時間為 3 小時
6 個視頻 （總計 53 分鐘）, 1 個閱讀材料, 1 個測驗
6 個視頻
The ETL Task7分鐘
Structural versus Terminology Mapping6分鐘
Data Profiling with White Rabbit10分鐘
Data Mapping with the Rabbit in a Hat Tool9分鐘
Terminology Mapping10分鐘
Example mapping of MIMIC Patient to OMOP Person8分鐘
1 個閱讀材料
Readings and Course Materials for Module 32小時
1 個練習
Techniques: Extract-Transform-Load and Terminology Mapping30分鐘
完成時間為 3 小時
Techniques: Data Quality Assessments
We explore the dimensions of data quality by reviewing its challenges, data quality measurements used to measure it, and data quality rules to assess its acceptability for use.
完成時間為 3 小時
5 個視頻 （總計 52 分鐘）, 1 個閱讀材料, 1 個測驗
5 個視頻
Data profiling for data quality assessment10分鐘
Data quality assessment using SQL13分鐘
Callahan and Khare rules8分鐘
OHDSI Achilles and Achilles Heel12分鐘
1 個閱讀材料
Readings and Course Materials for Module 41 小時 30 分
1 個練習
Techniques: Data Quality Assessments30分鐘
審閱
來自CLINICAL DATA MODELS AND DATA QUALITY ASSESSMENTS的熱門評論
由 MK 提供2019年7月21日
Gives a great understanding of ETL and the surrounding concepts from Zero. I personally found that a little boring, but for a total newbie to data and computers this is a perfect course.
由 FG 提供2019年12月12日
An excellent course that provides great guidelines for clinical data models. There are plenty of exercises to cement each block of learning material.
由 MK 提供2019年11月4日
What a great course!! Kudos to the professor for being so detail oriented!! I learned a great deal about the clinical data models from this course!!
由 VT 提供2019年9月13日
Good instructor who took time to explain and walked through each steps of the ETL process. Highly recommended.
關於 Clinical Data Science 專項課程
Are you interested in how to use data generated by doctors, nurses, and the healthcare system to improve the care of future patients? If so, you may be a future clinical data scientist!
常見問題
我什么时候能够访问课程视频和作业？
我订阅此专项课程后会得到什么？
Is financial aid available?
還有其他問題嗎？請訪問 學生幫助中心。
