Abstract
The New York State Department of Health has created a data warehouse to analyze and evaluate the Medicaid managed care program. Online query tools and reports, grouping tools such as Diagnostic Related Groups, and measurement tools such as Health Plan Data and Information Set (HEDIS) measures have been incorporated into the data warehouse. Other public health data sets including birth certificate data have also been integrated. The result is a powerful data set that can analyze information quickly and efficiently, with built-in data intelligence. Developed over time, this system can provide states, health insurance companies, and health data consortiums a roadmap on how to implement an integrated data warehouse solution.