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.

How do I connect to the Data Warehouse?

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.

How do I get access to the data and what kind(s) of data can I get access to?

Upcoming Changes to Data Infrastructure

Pitt IT Analytics is actively building a modern data lake and lakehouse (i.e. data warehouse) hosted in AWS, which should impact only users with a database account.

Currently, data from the Student, Employee, and GL marts is served to the campus community from our on-premise Oracle data warehouse. Users with a database account and an appropriate VPN role can connect directly to the data warehouse to retrieve data with SQL.

For more information, please visit the Analytics Modernization page.

Data Available for All

Through the University’s Federated Authorization process, the following data sources are available for connection via Tableau data sources and dashboards, Cognos reports and query packages, and via direct SQL access.

Student Mart
- Student Mart Tableau Data Sources
- Student Mart Dashboards
- Request access to the Student Mart through Federated Authorization
Employee Mart
- Employee Mart Tableau Data Sources
- HR Analytics
- Request access to the Employee Mart
General Ledger (GL) Mart
- General Ledger Tableau Data Sources (COMING SOON!)
- Fiscal Panther Hub
- Request access to the GL Mart

Specialized Data

The following data sources are currently available as part of an existing dashboard, or via special request/use case. For more information on these data sources, please contact the Pitt IT Helpdesk.

PERIS
Concur
Insite
RMS
Suitable/Outside the Classroom Curriculum
Salesforce
Faculty Information System

Access to Analytics and Reporting Tools

Tableau Desktop and Tableau Server - please visit Tableau page for information on acquiring Tableau
Cognos - Users who have requested and been granted access to the Student Mart, Employee Mart, or GL Mart listed above automatically have access to existing reports and ad hoc report creation capability in Cognos.
Oracle Analytics Cloud - please visit https://prism.pitt.edu/oracle-analytics-cloud-oac/ for information on access to OAC.