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.

How do I connect to the Data Warehouse?

Access to the University Data Warehouse is available through supported tools (Cognos, Tableau and Alteryx), 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.