LATEST UPDATES ON FALL 2021 PLANNING, VACCINES, COVID-19 TESTING AND MORE LATEST UPDATES ON FALL 2021 PLANNING, VACCINES, COVID-19 TESTING AND MORE
MSU Denver

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. 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.

BI Reporting & Data Warehouse Team

Placeholder image

Wes Pembrook

Assistant Director of Enterprise Data Warehouse

[email protected]
Placeholder image

Rishab Marwaha

Senior EDW Architect

[email protected]
Placeholder image

Tony Calhoun

Senior EDW Architect

[email protected]
Placeholder image

Jim Egan

ETL Developer

[email protected]
Placeholder image

Michael Salazar

Business Intelligence Developer

[email protected]
Placeholder image

Eric Curry

Business Intelligence Developer

[email protected]
Placeholder image

Kori Thompson

Business Intelligence Developer

[email protected]

Contact the EDW

Have a question or comment?

Contact Us