We may earn an affiliate commission when you visit our partners.

Clinical Data Models and Data Quality Assessments

Laura K. Wiley, PhD and Michael G. Kahn, MD, PhD

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.

Enroll now

Or subscribe to Coursera Plus

And get unlimited access to Coursera

What's inside

Syllabus

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.

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.

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.

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.

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

In this module, you gather everything you’ve learned to complete a real-world hands-on exercise using ETL methods to convert MIMIC3 data into the OMOP common data model.

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Teaches foundational data science concepts, which are highly relevant to the field of medical research

Taught by experts in the field of clinical data modeling

Provides hands-on experience with real-world clinical data sets

Requires some prior knowledge of SQL and data modeling concepts

Save this course

Save Clinical Data Models and Data Quality Assessments to your list so you can find it easily later:

Save

Reviews summary

Challenging but rewarding clinical data course

Learners say this engaging course is difficult, but offers valuable concepts in data quality assessments and clinical data models. Quizzes and assignments, however, have had some confusing questions and technical issues.

Peer review process provides constructive feedback.

"The final assignment is a peer-reviewed project"

Despite some issues, the course provided valuable concepts in data quality assessments and clinical data models.

"I learned new concepts and processes"

"very little programming actually, The information is repeated numerous times Programming/writing on the other hand is not explained clearly and should be repeated more."

Some material is missing or outdated, making it difficult to complete assignments.

"I have found a key website to be out of date"

"Also, files important to finish assignments are missing"

Instructor has engaging lectures but lacks clarity in explaining concepts.

"The instructor is not really engaging."

"some of them are ambiguous or have answers that can be different given the current state of the art"

"Dr. Kahn's presentation and reading ability is on full display, but what is not on full display is how to actually do what he is describing."

Some quizzes and assignments were unclear and didn't always reflect the material.

"The quizzes contained questions on issues never discussed in the course material"

"multiple choice quizzes with only 6 questions where I had some answers marked "incorrect" when they weren't the "most correct" answer."

"Having a student review 3 assignments is incredibly short sighted unless the final grade for ones own assignment is then averaged."

Career center

Learners who complete Clinical Data Models and Data Quality Assessments will develop knowledge and skills that may be useful to these careers:

Data Analyst

Data Analysts are responsible for collecting, cleaning, and analyzing data to identify trends and patterns. A Clinical Data Models and Data Quality Assessments course may be helpful for this role, as it provides the skills to work with clinical data models and common data models. This can help Data Analysts to understand the structure of clinical data and to extract meaningful insights from it.

See salaries and explore the career path for Data Analyst

Quality Assurance Analyst

Quality Assurance Analysts are responsible for ensuring that data meets the required standards for quality. A Clinical Data Models and Data Quality Assessments course may be useful for this role, as it provides the skills to evaluate and interpret data model designs using Entity-Relationship Diagrams (ERDs). This can help Quality Assurance Analysts to identify and correct errors in data, ensuring that it is accurate and reliable.

See salaries and explore the career path for Quality Assurance Analyst

Data Scientist

Data Scientists are responsible for developing and implementing data-driven solutions to business problems. A Clinical Data Models and Data Quality Assessments course may be helpful for this role, as it provides the skills to work with clinical data models and common data models. This can help Data Scientists to understand the structure of clinical data and to develop models that can accurately predict outcomes.

See salaries and explore the career path for Data Scientist

Clinical Research Associate

Clinical Research Associates are responsible for managing clinical trials and ensuring that they are conducted in accordance with good clinical practice (GCP) guidelines. A Clinical Data Models and Data Quality Assessments course may be helpful for this role, as it provides the skills to work with clinical data models and common data models. This can help Clinical Research Associates to understand the structure of clinical data and to ensure that it is collected and managed in a way that meets the requirements of GCP.

See salaries and explore the career path for Clinical Research Associate

Healthcare Consultant

Healthcare Consultants provide advice and guidance to healthcare organizations on a variety of topics, such as clinical data management, quality improvement, and strategic planning. A Clinical Data Models and Data Quality Assessments course may be helpful for this role, as it provides the skills to understand the challenges and opportunities associated with clinical data.

See salaries and explore the career path for Healthcare Consultant

Healthcare Data Manager

Healthcare Data Managers are responsible for managing the collection, storage, and analysis of healthcare data. A Clinical Data Models and Data Quality Assessments course may be helpful for this role, as it provides the skills to work with clinical data models and common data models. This can help Healthcare Data Managers to understand the structure of clinical data and to develop systems for managing it effectively.

See salaries and explore the career path for Healthcare Data Manager

Medical Writer

Medical Writers are responsible for writing and editing medical documents, such as clinical trial protocols, patient information sheets, and scientific papers. A Clinical Data Models and Data Quality Assessments course may be helpful for this role, as it provides the skills to understand the structure of clinical data and to communicate it clearly and accurately.

See salaries and explore the career path for Medical Writer

Data Architect

Data Architects are responsible for designing and implementing data architectures for organizations. A Clinical Data Models and Data Quality Assessments course may be helpful for this role, as it provides the skills to work with clinical data models and common data models. This can help Data Architects to understand the structure of clinical data and to develop architectures for managing it effectively.

See salaries and explore the career path for Data Architect

Clinical Data Manager

Clinical Data Managers are responsible for managing the collection, storage, and analysis of clinical data. A Clinical Data Models and Data Quality Assessments course may be helpful for this role, as it provides the skills to work with clinical data models and common data models. This can help Clinical Data Managers to understand the structure of clinical data and to develop systems for managing it effectively.

See salaries and explore the career path for Clinical Data Manager

Medical Librarian

Medical Librarians are responsible for providing access to and managing medical information resources. A Clinical Data Models and Data Quality Assessments course may be helpful for this role, as it provides the skills to understand the structure of clinical data and to develop systems for organizing and retrieving it.

See salaries and explore the career path for Medical Librarian

Health Informatics Specialist

Health Informatics Specialists are responsible for designing, implementing, and managing health information systems. A Clinical Data Models and Data Quality Assessments course may be helpful for this role, as it provides the skills to work with clinical data models and common data models. This can help Health Informatics Specialists to understand the structure of clinical data and to develop systems for managing it effectively.

See salaries and explore the career path for Health Informatics Specialist

Database Administrator

Database Administrators are responsible for designing, implementing, and managing databases. A Clinical Data Models and Data Quality Assessments course may be helpful for this role, as it provides the skills to work with clinical data models and common data models. This can help Database Administrators to understand the structure of clinical data and to develop systems for managing it effectively.

See salaries and explore the career path for Database Administrator

Software Engineer

Software Engineers are responsible for designing, developing, and maintaining software applications. A Clinical Data Models and Data Quality Assessments course may be helpful for this role, as it provides the skills to work with clinical data models and common data models. This can help Software Engineers to understand the structure of clinical data and to develop applications for managing it effectively.

See salaries and explore the career path for Software Engineer

Data Engineer

Data Engineers are responsible for designing, building, and maintaining data pipelines. A Clinical Data Models and Data Quality Assessments course may be helpful for this role, as it provides the skills to work with clinical data models and common data models. This can help Data Engineers to understand the structure of clinical data and to develop pipelines for managing it effectively.

See salaries and explore the career path for Data Engineer

Biostatistician

Biostatisticians are responsible for designing and conducting statistical analyses of medical data. A Clinical Data Models and Data Quality Assessments course may be helpful for this role, as it provides the skills to work with clinical data models and common data models. This can help Biostatisticians to understand the structure of clinical data and to develop models for analyzing it effectively.

See salaries and explore the career path for Biostatistician

Reading list

We've selected 13 books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Clinical Data Models and Data Quality Assessments.

Data Virtualization for Business Intelligence...