Skip to content

UC Data Warehouse

Once completed, the University of California Data Warehouse (UCDW) will provide an integrated, universal source for reporting, analytics and business intelligence. Functioning as an analytical data warehouse, it will store historical institutional data sourced from University of California campuses transactional databases via flat files and enrichment data from external educational bodies and boards, such as California Department of Education (CDE) and IPEDS. Data taken from campuses directly may not necessarily match information provided to the CDE or IPEDS. These agencies have various definitions for reporting that are not initially stored in source systems, and thus are not necessarily imported into the data warehouse. The enrichment data will be utilized for comparative analysis and as such, are sourced at aggregated levels.

The vision of the UC data warehouse is for this repository to be the source of authorized information around student, staff, faculty, budget and staff data. This data warehouse will be accessible by university executives, faculty, staff, administrators and researchers. It is expected that this analytical enterprise data source will provide UC with the following benefits:

  • Tools To Combine Data Differently – The data warehouse environment will give users a tool for looking at data differently. This tool allows decision makers to ask new questions and an opportunity to solve problems differently. This benefit is related to reporting and its associated tools.
  • End User Empowerment – The warehouse will empower institutional decision makers by placing inquiry and analysis tools at their fingertips.
  • Timely Information Access – The data warehouse will shorten the time span between user reporting data needs and information delivery, giving decision makers instant access to historical (static) data through the use of ad-hoc query and reporting tools.
  • Future Vision From Historical Trends – The data warehouse will provide the data needed for effective business analysis which includes forecasting and trending using historical multiple academic years, or terms, worth of data using various points in time—snapshots.

Subject areas currently available are:

  • Student Enrollment
  • Course Enrollment
  • Degree
  • Undergraduate Enrollment
  • Contracts and Grants
  • Climate Survey
  • UCUES
  • Payroll/Personnel

Please forward any questions regarding the UC Information Center Data Warehouse (ICDW) by email to irap@ucop.edu.