Report documents and laptop computer.
770 gradient

Title

Enterprise Data Warehouse

University data organized in integrated subject areas, optimized for analytics and reporting.

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:
  • 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

    Getting Started

    Intended Audience

    Students
    Instructors
    Researchers
    Staff & Departments
    IT Staff and Partners

    Cost

    University-funded: no charge.