Getting Started with the University Data Warehouse


General information and frequently asked questions about the University Data Warehouse



The University Data Warehouse is the central authoritative data source for the University. It provides support for reporting, ad hoc data queries, and analytics. The Oracle-based database is comprised of student, financial, and employee data originating in several University systems. These include the Student Information System (PeopleSoft), PRISM, and PantherExpress (purchase orders). Columns from existing and new systems are regularly added to the Data Marts to meet new reporting and analytics needs.

Access to the University Data Warehouse is available through supported tools (Cognos and Tableau), as well as direct access through a SQL client. Security is governed by a federated authorization process that ensures individuals have access to the data required to be successful in their jobs. See information on Requesting Access to Tools and Data Services.



Frequently Asked Questions




Article ID: 280
Mon 8/7/23 3:54 PM
Tue 2/13/24 3:36 PM

Related Services / Offerings

Related Services / Offerings (1)

DATA Pitt IT Analytics can work with you to create reusable, regularly refreshed data sets to support standard or ad hoc reports.