The data warehouse was built on SQL Server. Access to the application is provided using SharePoint technology. SharePoint access is currently limited to basic users. Advanced users access the system through a database connection in Excel.
The data warehouse is not a transactional warehouse; rather, final data are loaded annually. The data warehouse does not contain provisional data. The data warehouse is constructed on the basis of public health events and does not allow for the tracking of a specific individual over time.
Data are available in four subject areas - Birth, Death, Statewide Inpatient Discharge, and Behavioral Risk Factor Surveillance System (BRFSS). The most recent census data is used to calculate rates and extrapolate data when missing. In addition, county snapshots provide brief glimpses into the health of counties throughout Iowa. These snapshots contain indicators with statistics for the county and the state.