Reporting and Analytics (Data Warehouse)

Heads up! For the most up to date information and resources, visit the IT Help Portal to browse a full list of services and instructions.

Data Warehouse is a repository where staff and faculty with appropriate access can run queries and reports of university data. The repository can be accessed from user-friendly analysis tools, including SAS Enterprise Guide (EG), the SAS Add-in for Excel, Microsoft Access, and the SAS Web Application. 

Request Training Request Access Report an Issue

Note: Access requires authorization from the department head or person responsible for authorizing cost center expenditures.

Heads up! Starting May 30, 2023, a campus VPN connection is required when logging into Data Warehouse from on and off campus access.

Downloads

SAS EG and the SAS Add-in for Excel are available for download to those granted Data Warehouse access. No license is required.

BASIS Data Reports

Historical BASIS data is available in standardized reports. Custom reports can be generated by request.
Page Reporting

Training and Resources

Data Warehouse training is available online or in-person (UPTE 208).

About Data Warehouse

Data Warehouse is made up of over 270 tables of financial (purchasing, payroll, general ledger, etc.), academic (UAConnect) and historical BASIS data copied from live production systems at regular intervals.