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 Technology 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 Technology Help Desk for more information.