Mount Sinai Data Warehouse

The Mount Sinai Data Warehouse (MSDW) consists of clinical, operational, and financial data derived from patient care processes of The Mount Sinai Hospital and Mount Sinai Faculty Practice Associates.  Detailed inpatient and outpatient data are extracted from transactional systems, transformed and loaded into MSDW nightly. MSDW contains data since 2003, sourced from 20 transactional systems, encompassing over three million patients and approaching one billion facts.

The principal objective of the Data Warehouse is to make data easily accessible for planning and executing clinical and translational research and for quality of care and process improvement projects.  A secondary objective is to monitor and improve data quality and integrity across Mount Sinai’s many transactional systems.

MSDW is compliant with HIPAA and New York State privacy and security regulations and with Mount Sinai IRB policy regarding protection of human subjects and participation in research.  Researchers planning new studies or grant applications can quickly search the de-identified Data Warehouse to quantify eligible cohorts.  For IRB-approved research or CQI projects, datamarts tailored to specific eligibility and data analysis requirements are prepared.  Datamarts may be de-identified, or may contain PHI with appropriate approvals.