Enterprise Data Warehouse | IT@UMN | The people behind the technology

Overview

The Enterprise Data Warehouse (EDW) is built to provide a flexible and scalable platform using a star-schema data model that leverages facts and dimensions. This design is optimized for analytics, allowing greater reuse through more combinations of complex data, and ultimately, allowing more diverse questions to be answered.

The Office of Information Technology (OIT) is working with the Enterprise Data Management and Reporting (EDMR) organization and the University Pillars to prioritize the data subject areas brought into EDW. As EDW is being built, the Legacy Data Warehouse will have a larger breadth of data for a period of time, and users will need to make a determination if the subject areas in EDW can be leveraged or if the Legacy Data Warehouse should continue to be used.

Access to EDW is provided via UM Analytics. This Business Intelligence platform allows central units at the University (Finance, Human Resources, Research, Student, and University Services) to pre-build and publish analyses, dashboards, and visualizations, utilizing common business logic and enterprise data definitions. It also enables campuses, colleges, units, and individuals to author their own data queries and create advanced dashboards and visualizations.

Highlights

Consolidated data from multiple source systems, structured for analytics using dimensional modeling techniques
Consume this data via published dashboards/analyses from Central Units in the UM Analytics Catalog, which can also be accessed on a report-by-report basis in the MyU Portal, Reporting Center:
- University Finance
- Student, Academic Support Resources
- Office of Human Resources
- University Services (Space)
Advanced users can author and share personal analyses and dashboards using the the query builder in UM Analytics
The Enterprise Data Subject Area Map outlines targeted subject areas to include in the Enterprise Data Warehouse, which currently include the following:
- Finance - General Ledger
- Finance/Research - Grants, Projects, and Contracts (Sponsored Projects)
- Human Resources - Position, Job, and Compensation
- Student - Course Enrollment
- Coming Soon...
  - Student - Undergraduate Degree Progress