Request Information
Ready to find out what MSU Denver can do for you? We’ve got you covered.
About the EDW
The Enterprise Data Warehouse (EDW) is the secured, centralized datastore for MSU Denver. It integrates data from sources across the university to support faculty and staff’s reporting and analytical needs. Reporting from the EDW allows for easy accessibility and sharing of data as well as consistent reporting across the university.
Data in the EDW is refreshed nightly through automated Extraction, Transformation, and Load (ETL) processes. These processes enhance the university’s reporting capabilities by reformatting, summarizing, and/or enriching the EDW’s data. This also allows various types of data tables to be created including snapshot tables which can provides point in time data or summary tables that provide historical data.
EDW Reports
The EDW currently houses hundreds of reports that have been custom built for the university by the BI Reporting & Data Warehouse Team, a unit in the Data & Analytics Branch of the Office of Strategic Initiatives & Analytics. All existing reports can be accessed through the EDW’s reporting environment. These reports range from simple course listings to complex dashboards that can provide a 15-year history of registration trends. The team is also continuously working with university staff and faculty to develop new reports. For a full listing of all approved and verified reports see our report catalogs.
Need Access to the EDW?
To access the EDW, you must receive account authorization from the EDW Team. If you are unsure whether you are an authorized user, contact the EDW team.
If you want to access the EDW for research purposes, you must first obtain IRB approval.
BI Reporting & Data Warehouse Team
Contact the EDW
Have a question or comment?
Contact any of the team members listed above.