Healthcare Data Warehouse on the OMOP CDM

A clinical data warehouse built on the OMOP Common Data Model v5.4, the open standard of the OHDSI research network. Synthea synthetic patient records are loaded and transformed with dbt into the CDM, checked by dbt tests and data-quality checks, used to define study cohorts and to train a patient-level prediction model, and explored in a secure web application. The student version runs on a laptop CPU with DuckDB in about two minutes; the same dbt project builds the full version on PostgreSQL 16 with an Apache Superset dashboard.

Category: Healthcare Data Engineering / Clinical Data Warehousing / Health Informatics / Data Analytics

CSE Project 24 from ProTechSC Academy, with graphical abstract, video demonstration and project guidance.