Enterprise Data Warehouse
Northwestern Medicine Enterprise Data Warehouse (NMEDW) was designed create a single, comprehensive and integrated repository of all clinical and research data sources on the campus to facilitate research, clinical quality, healthcare operations and medical education.
The NMEDW currently stores observations on more than 6.6 million distinct patients. Each day, it loads more than 2.8 billion new data elements from 142 separate sources, including electronic health records, pathology data from the hospital and research laboratories, biomarker data from research databases and research transactional data from our eIRB and other institutional systems. The NMEDW has a mature data steward model, supported by an electronic workflow that enables rapid review of data requests.
The following graphic is a representation of high-level content areas, though the NMEDW has considerably more data and loads more systems on a regular basis:
It’s important to note that the older data are not always of the highest utility, and we strongly recommend that investigators who plan to use the NMEDW in their research contact the NMEDW prior to grant submission.
Using the NMEDW for Research
The primary ways to use the NMEDW for research are:
- i2b2 Feasibility Query Tool: A self-service tool for investigators to explore cohort availability.
- NMEDW Data Analysts: Use the research data request form to contact the analyst team. The fee to work with an NMEDW analyst is $83/hour, and the average charge for a research request is $996 (12 hours).
- NMEDW Pilot Data Program: A grant that allows young investigators to obtain feasibility or early pilot data in order to seek sustained funding.
Powerusers :Individualswho have skills using advanced database languages can apply via email to become a Poweruser and be granted direct access to the NMEDW.
See the frequently asked questions below, and review our EDW Exception Process FAQ for more information.