Data Warehouse
You are here: Home → Data Warehouse
Data Warehouse is a repository where staff and faculty can run queries against university data, usually for reporting purposes. It is made up of financial (purchasing, payroll, general ledger, etc.), academic (ISIS), and historical data, and offers a user-friendly analysis tool for running queries. Distinct from the ISIS and BASIS databases, the Data Warehouse data is copied from the live production systems at regular intervals.Accessing Data Warehouse
Access to the Data Warehouse requires an authorized signature from the department head (or person responsible for authorizing cost center expenditures) and is only available to academic and administrative users. The Data Warehouse is accessible from 7 a.m. to 6 p.m. weekdays and on weekends when maintenance is not scheduled. Call the IT Services Data Center at 575-2303 to verify accessibility on weekends.
To gain access to the Data Warehouse, complete and return the Data Warehouse Access Agreement form (PDF), selecting your Data Warehouse access software: Brioquery, SAS, or Microsoft Access.
Data Warehouse passwords can be reset using Password Manager.
Secure Reporting Environment
Through the Secure Reporting Environment (SRE), the university provides secure and direct access to data sources for personnel with a demonstrated need, while restricting the storage of sensitive data from residing on individual desktops.
Authorized personnel are able to remotely access information, including ad hoc queries, for database investigations and reports through the use of the SRE.
Contact your supervisor for more information.