Enterprise Data Warehouse

关于EDW

The Enterprise Data Warehouse (EDW) is the secured, centralized datastore for 密歇根州立大学丹佛. 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 每晚 through automated Extraction, Transformation, and Load (ETL) processes. These processes enhance the university’s reporting capabilities by reformatting, 总结, 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报告 & 数据仓库团队, a unit in the Data & 分析 的分支 Office of Strategic Initiatives & 分析. 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 报告目录.