Skip to content

UC Data Warehouse (UCDW) Plan

Majority of UCOP’s decision support needs are being met through a hybrid of an outdated corporate data warehouse running on legacy unsupported technology and the DSS (now known as the UC Data Warehouse [UCDW]). It is anticipated that through a strategic plan that spans the next five years, all the data in the legacy data warehouse will be migrated into the new UCDW. In addition, various enrichment data will be incorporated to enhance the business intelligence and reporting capability of the Information Center reporting infrastructure.

Our vision for the UC Data Warehouse has expanded greatly beyond traditional reporting. It is now expected to be a source of business intelligence reporting, business analytics, predictive analytics and academic analytics.  It is also intended to be the source of data that feeds the new UC Information Center website. Our roadmap (pdf) for the next four years is expansive but we are committed to accomplishing the goals set before us.

The UC Information Center infrastructure is made up of ten components (pdf):

  1. Configuration Management Framework - defines processes and tools for establishing amd maintaining consistency of the reporting infrastructure's accuracy, performance and functional attributes.
  2. Internal and Public-Facing Websites – includes both public-facing sites and internal UC sites.
  3. Change Management Framework – streamlines and manages the processes around change requests and updates to the UC Data Warehouse.
  4. Support and Training Framework – encapsulates all support and training activities around keeping the entire Information Center running and usable.
  5. Communication Framework - involves the strategies developed to ensure effective communication to all stakeholders and target audiences.
  6. User Acceptance Testing (UAT) and Validation Framework – provides avenues to increase data quality within the enterprise data warehouse.
  7. Enterprise Data Warehouse – includes the star-schemas and data marts.
  8. Business Intelligence and Reporting Framework – provides business intelligence canned and ad-hoc reporting
  9. Reference Data Management Framework  – includes all applications and tools to help centralize and manage master data and also processes for stewardship and governance of data.
  10. Release Management Framework - involves processes around managing, planning, scheduling and controlling updates or changes to the UC Data Warehouse infrastructure.

Success will be determined using the following indicators:

  • The provision of a single data source to support analysis and reporting with expanded access to integrated data.
  • Reduction in time from data collection to analysis and to reporting by housing data in a way it can be used.
  • Provision of an improved reporting environment (complete with Business Intelligence and Data Visualization tools) with robust attributes and an intuitive interface to support advanced analytics and strategic planning (this includes the integration of the reporting layer and analytic tools).
  • Standardized and documented data definitions. This may require the role of a metadata analyst or architect.
  • Standardized and easily updatable data interfaces (i.e. reference data). For example, adding a new major.
  • Evidence of improved data quality and transparency.
  • Automated and streamlined data validation process to increase efficiency and reduce file submission to load timeline.
  • Automation of all routine reports.