Data Warehouse

Tags Faculty Staff

Pitt IT Analytics supports the University Data Warehouse. Pitt Data Engineers can work with you to create reusable, regularly refreshed data sets to support standard or ad hoc reports. These data sets may be delivered via the data warehouse, data lake, or as Tableau data sources.

 

About This Service

Key Benefits

  • Centralized data: The University Data Warehouse provides a centralized location for all of the University's data, making it easier to access and analyze.
  • Consistent data: The data warehouse ensures that all data is consistent and up-to-date, reducing the likelihood of errors and inconsistencies.
  • Improved data quality: The data warehouse can help improve the quality of data by eliminating duplicate data and identifying and correcting errors.
  • Faster reporting: With the data warehouse, reports can be generated faster and more efficiently, as the data is already centralized and pre-processed.
  • Customized reporting: The data warehouse allows for customized reporting, giving you the ability to access the data you need in the format you prefer. This can help you make more informed decisions based on the customized data.

Getting and Using This Service

How do I access this service?

Users with access to the University Data Warehouse may access it through Cognos packages or Tableau data sources.  Users with SQL query capability can connect directly using their SQL tool of choice. 

Special Considerations

Access to the University Data Warehouse and its Data Marts requires the submission of a Federated Authorization Request. These requests ensure that users are granted access to the data required to successfully complete their work.

How do I request this service?

  • Student Mart Access
    Your access to student data will be governed by your academic center or department. In addition, access to sensitive data (e.g., GPA, ethnicity, birthdate, etc.) requires additional approval. All new users must first request Student Mart access. If restricted access is required, those forms should be submitted as well.

Request Student Mart or Student Mart Restricted Access

  • General Ledger Mart Access
    Your access to general ledger data will be governed by your job responsibilities, your responsibility center, and department/group, as well as the role you request on your form (e.g., Business Administration, Operations, or Grants).

Request General Ledger Mart or General Ledger Mart CDS Group Access

  • SQL Query Access
    If you have access to the University Data Warehouse via the Student or GL Mart, know how to write SQL queries, and would like to have direct SQL Query Access, please submit a ticket by clicking the Request Help button on the upper right hand corner of this page.

Who can use this service?

Faculty, Staff

Support

How do I get help?

Submit a ticket by clicking the Request Help button on the upper right hand corner of this page.

 
Request Help

Related Articles (2)

Pitt Information Technology is responsible for Enterprise Business Intelligence and the University Data Warehouse at the University of Pittsburgh.
General information and frequently asked questions about the University Data Warehouse

Details

Service ID: 22
Created
Tue 5/23/23 3:58 PM
Modified
Mon 12/4/23 11:32 AM