BI Query, data warehouse, the legacy data warehouse, DWHS
The Data Warehouse consists of three separate data sets: financial data (FIS), Human Resources data (HRIS), and student data (SIS). Each contains a subset of the information that is stored in Banner. Users can use the Data Warehouse to more easily examine data and craft ad-hoc queries of the data.
The data is refreshed nightly and remains static during the day.
Note: UO currently has two data warehouses: this one, which is accessed via BI/Query tools, and the newer IDR Data Warehouse, which is still in the process of being developed and which can be accessed via Cognos tools (see Integrated Data and Reporting). The two data warehouses will operate in parallel until the older Data Warehouse is phased out.
Data Warehouse will be unavailable Fridays from 7pm-9pm for maintenance.
Access form at https://it.uoregon.edu/sites/is2.uoregon.edu/files/dw.pdf. VPN access is required; see https://it.uoregon.edu/node/2701.
Contact your department head. Department heads: contact Noreen Hogan at firstname.lastname@example.org or 541-346-1727.
For Student Data Warehouse support, contact Jim Blick at email@example.com or 541-346-3246.
For HRIS support, contact Shelby Cooper at firstname.lastname@example.org or 541-346-3092.
For FIS support, contact Bruce Abrahamson at email@example.com or 541-346-3032.
For installation support, contact Randall Klein at firstname.lastname@example.org or 541-346-1770.
Contact Noreen Hogan at email@example.com or 541-346-1727.
See the following links: