Data Warehouse

Service Category: 
Administrative and Business
Service Provider: 
Information Services
Aliases: 

BI Query, data warehouse, the legacy data warehouse, DWHS

Service Offering Description: 

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.

Service Levels: 

Data Warehouse will be unavailable Fridays from 7pm-9pm for maintenance.

Requirements: 
Service Charges: 

n/a

Accessing the Service: 

Contact your department head. Department heads: contact Noreen Hogan at isapps@uoregon.edu or 541-346-1727.

Support Contact: 

See http://bg.uoregon.edu/content/data-warehouse-welcome.

For Student Data Warehouse support, contact Jim Blick at jblick@uoregon.edu or 541-346-3246. 

For HRIS support, contact Shelby Cooper at shelbyc@uoregon.edu or 541-346-3092.

For FIS support, contact Bruce Abrahamson at babraham@uoregon.edu or 541-346-3032.

For installation support, contact Randall Klein at randallk@uoregon.edu or 541-346-1770.

Feedback Mechanism: 

Contact Noreen Hogan at isapps@uoregon.edu or 541-346-1727.