UNIVERSITY DATA WAREHOUSE (DWH)
Overview
The University Data Warehouse is a repository of information extracted from various transaction systems across campus. Data are organized in tables that have been designed to make report writing simpler. The Data Warehouse contains student data from Fall 1998 to the present. *Snapshots of the data are captured nightly until the midpoint of the term when the data is frozen and is no longer updated. Student and Housing data can also be viewed through IPORT. The Data Warehouse is available daily from 7AM to midnight and is taken offline for refreshes at midnight.
Data Warehouse Benefits
- The Data Warehouse is the official source for University data. Data are constantly being reviewed by the data owner to ensure accuracy and consistency.
- The Data Warehouse is a source of integrated data across multiple transaction systems. Having all the data in a central place allows decision makers to see the “BIG” picture and enables them to make more informed decisions.
- The Data Warehouse can save you money. Dollars spent on maintaining independent shadow systems can be redirected when units move their data to the University Data Warehouse.
Access Data Warehouse
To gain access to the Data Warehouse, please complete the Data Access Request Form and obtain the signature(s) of the appropriate data steward(s). To obtain any additional data request forms, visit our Forms and Documents page.
Current Data Sources Update Schedule
Data Source(s) | Details |
Taleo | Weekly |
Banner | Updated daily |
OneUSG | Updated daily |
PS Financial | Updated daily |
Housing | Paused |
Study Abroad | Updated annually |
Grants and Research | Updated daily |
Digital Measures | Updated weekly |
Degree Works | Updated January, June and September |
Clearing House | Updated as needed |
Contact Us
Office of Institutional Effectiveness
Office of Enterprise Data Management and Analytics
Address
