Reporting and Analytics (Data Warehouse)

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

Alert: Data Warehouse access is only available to academic and administrative users. Access requires authorization from the department head or person responsible for authorizing cost center expenditures.

Downloads

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

Heads up! The ODBC driver is required for setting up Data Warehouse in SAS EG, the SAS Add-in and MS Access.

BASIS Data Reports

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

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.