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
Frequently Asked Questions about the University Data Warehouse
How frequently is the University Data Warehouse updated?
Daily (Monday through Saturday).
How is the University Data Warehouse structured?
The University Data Warehouse uses the star schema method of organizing data, consisting of one or more fact tables referencing any number of dimension tables. For more information on star schema design, click here>.
How can I learn more about the University Data Warehouse?
Visit the BI Practice Group's SharePoint site for videos and documentation on the University Data Warehouse.
How can I request that a new column or data source be added to the University Data Warehouse?
You can request that a new column or an entirely new data source be added to the University Data Warehouse by contacting the 24/7 IT Help Desk. If you are a member of the BI Practice group, you can view previously requested columns and vote for their inclusion on the BI Practice Group's SharePoint site. Pitt IT uses your votes to prioritize the addition of new columns.
Can I automate data extraction from the University Data Warehouse?
Cognos provides jobs that can be configured to run reports or queries and email the results to a user. Tableau extracts can be scheduled to run to update underlying dashboards. Automated data feeds to school, department, or business unit systems may be possible, subject to security, volume, and use considerations. Contact the 24/7 IT Help Desk for more information.