Ready to find out what MSU Denver can do for you? We’ve got you covered.
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.
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.
Interim Director Enterprise Data Warehouse[email protected]
ETL Developer[email protected]
Business Intelligence Developer[email protected]
Senior Business Intelligence Developer[email protected]
Data Warehouse Architect/BI Engineer[email protected]
Senior Enterprise Data Warehouse Architect[email protected]
Interim Director of Data & Analytics[email protected]
Have a question or comment?
Contact any of the team members listed above.