The University Data Warehouse is the central authoritative data source for the University, providing support for reporting, ad hoc data queries, and analytics. The University Data Warehouse comprised of data originating in multiple University systems, including the Student Information System (PeopleSoft) and PRISM. The data is extracted from those systems, then optimized for speed and ease of use, and placed into Data Marts. A Data Mart is a subset of the University Data Warehouse and is oriented toward a particular type of data, or a particular function.
Enterprise Tableau resources, dashboards and data sources, are automatically made available to users depending on their Data Mart access.Users with Student Mart access automatically have access to the student-related resources. With the recently expanded student data access (see announcement here), row-level mart access reaches across the campus-level data, which will grant access to additional rows of student data and broadens the scope of information available for analysis and decision-making.
If you have GL Mart Access, you will automatically see have access to the financial resources and data you're authorized to view.
Accessing Dashboards & Data Sources
Review the Federated Authorization Community page for detailed instructions and FAQs about request routing.
Review the related correlating resources and Data Marts below.
Complete the Federated Authorization form for the appropriate Data Mart.
PeopleSoft access is separate from Student Mart. It requires a distinct access request.
To view Restricted Fields (performance indicators, demographics, personal identifiers) special permission is needed. Your Fed Auth request should reflect this need and a clear justification or business need for accessing these fields.
If you do not have access to restricted fields, you will see null values in the dashboards.
Student Mart
Request access to the Student Mart
Employee Mart
Request access to the Employee Mart
General Ledger (GL) Mart
General Ledger Tableau Data Sources (COMING SOON!)
Request access to the GL Mart
First, read through the “Getting Started” article in Pitt IT’s Knowledge Base. Then, speak to your Federated Authorization contact so they can understand your needs and be prepared to review your request. Click on one of the links below to identify the appropriate Federated Authorization contact.Where to Begin with Access Requests
Keeping Data Safe
Access to restricted data is managed through “column-level.” Protected categories of columns – like those for financial aid and social security numbers – will require approval from the University’s data stewards via the Federated Authorization process.
As always, users are expected to utilize the data solely for official University business in accordance with University policies.Policies Related to Student Data Use
The Office of Compliance, Investigation and Ethics provides online FERPA training (beginning early in 2025).