Mount Sinai Data Warehouse

The principal objective of the Mount Sinai Data Warehouse (MSDW) is to make data easily accessible for planning and executing clinical and translational research and for quality of care and process improvement initiatives. A secondary objective is to monitor and improve the quality and integrity of data available for research and analysis.

The Data Warehouse collects and organizes clinical and financial data derived from patient care processes of The Mount Sinai Hospital and Mount Sinai Doctors Faculty Practice. MSDW contains detailed inpatient and outpatient data since 2003, sourced from 25 Mount Sinai systems, and encompasses more than three million patients and approaching two billion facts. Data are extracted from transactional systems and loaded into MSDW nightly.

MSDW is compliant with New York State and HIPAA regulations, and with Mount Sinai PPHS and IRB policies regarding protection of human subjects and participation in research.

Researchers planning new studies or grant applications can (after completing introductory training) utilize our Cohort Query Tool (CQT) and quickly search a de-identified view of the Data Warehouse to quantify eligible cohorts.

For IRB-approved research or quality/process improvement projects, datamarts or custom reports meeting project-specific eligibility and data requirements are prepared. Datamarts and reports may be de-identified or may contain PHI with appropriate approvals.

Training on our self-service Cohort Query Tool, and consultations up to one hour are funded by Icahn School of Medicine at Mount Sinai. Larger projects and custom programming require a funding source. Assistance with estimating Data Warehouse costs for grant application purposes is available upon request.

For more information:
Last Update: October 14, 2013