Data Warehouses: Enterprise Data Warehouse and Legacy Data Warehouse
Enterprise Data Warehouse
The Enterprise Data Warehouse (EDW) is the University's data warehouse for governed data. It sources data from PeopleSoft and other enterprise systems, runs it through a governance process to provide business term definitions, structures data using a fact and dimension model, and provides analyses and dashboards built off of this governed data.
Data from the enterprise data pillars (Finance, Human Resources, Physical Asset Management, Research, and Student) are built into subject areas within the warehouse in collaboration with each pillar and the OIT Enterprise Data and Analytics team. Work is prioritized by the Enterprise Data Management and Reporting Steering Committee.
The primary platform for the Enterprise Data Warehouse is UM Analytics, an Oracle platform. UM Analytics provides access control, navigation, report, and dashboard capabilities. Data in the Enterprise Data Warehouse can also be accessed using the Unify Connector.
Central reporting built using the Enterprise Data Warehouse is available to the University community through dashboards published on the MyU Reporting Center. To create ad-hoc analyses or dashboards in the Enterprise Data Warehouse via UM Analytics, request authoring permissions by filling out the UM Analytics ARF.
You can find more information on the service details page for the Enterprise Data Warehouse.
Legacy Data Warehouse
The Legacy Data Warehouse (LDW or DWE) contains tables of data people find useful for reporting and integrations. Similar to the Enterprise Data Warehouse, this Legacy Data Warehouse also sources data primarily from PeopleSoft, but this data does not go through a governance process and the data is stored using a relational model very similar to the data in the source systems.
Access to the Legacy Data Warehouse requires filling out the Legacy Data Warehouse ARF.
You can find more information on the service details page for the Legacy Data Warehouse.