Student Data Warehouse Project
Quicklink(s)
The Student Data Warehouse will create an on-premises repository of historical, connected, documented, available, and accessible student data, to optimize UCI’s decision-making at strategic, tactical, and operational levels.
Student Data Warehouse (SDW) will consolidate information from various student systems in multiple departments, provide centrally-managed campus reports, and provide ad-hoc query tools and other self-service capabilities.
Establishing a consolidated SDW will provide the comprehensive, updated, complete, consistent, and accurate collection of student data that is vital for reporting, research, analysis, and analytics.
This mission will be accomplished by:
- Adopting a governed process for managing the growth of the SDW over time, including intake and evaluation of requests for additional data to be added to the SDW, and prioritization of SDW work streams
- Partnering with functional stakeholders to define business needs and requirements, and implement and maintain a data-quality feedback process
- Providing a central source of official student data, along with outreach and training on data assets, enabling self-service reporting and analysis to all campus constituents, and reducing the workload on traditional custodians of the data
- Developing tools and processes that facilitate governance of SDW data assets, ensuring compliance with best practices and data security standards
- Adopting and providing tools, processes, training, and user groups to enable users to leverage data effectively
- Standardizing, documenting, and informing users of the definitions, appropriate use, and governance of student data
Goals
- Build various Data Marts that assemble Student Data throughout the life cycle of the Student experience
- Develop ETL (Extract, Transform, and Load) processes in Informatica to collect data on a daily basis
- Develop Census snapshots for official reporting
- Build Tableau Data sources and COGNOS framework around the DataMart for reporting
- Display definitions in the Metadata repository
Deliverables
Program Accomplishments to date:
- Daily Student Enrollment Data Mart sourced from OIR, collecting data on enrolled Students’ attributes and details
- Census Student Enrollment Data Mart with 10 years’ worth of Fall, Winter, Spring, and Summer, 3rd-week and End-of-term data
- Graduate Slate Operational data store that collects Graduate admissions data daily
- Undergraduate Slate Operational data store that collects, most important, Undergraduate admissions data daily
- Metadata Website and repository, that serves as a platform for displaying approved and commonly agreed upon data definitions
- Populated Slate data in Legacy Undergraduate Point-in-time report
- Daily Course Enrollment Data Mart
- Decoupling Daily Student Enrollment Data Mart, from OIR to source data directly from Registrar
- Census Course Enrollment and Transcripts Data Mart
- Decoupling Census Student Enrollment Data Mart, from OIR to source data directly from Registrar
- Academic Center testing Operational Data Store and Data Mart
- Graduate/Degrees awarded Data Mart
Upcoming deliverables include:
- Graduate and Undergraduate admissions Data Mart
- UCOP Census Student and Course Enrollment official reporting
| Project Name | Target Date |
|---|---|
| PRJ0015264 Build Census and decouple Daily Student Enrollment DataMart | 04/14/24 |
| PRJ0015325 Build Undergraduate Admissions DataMart | 04/15/24 |
| PRJ0016599 Build Graduate Admissions DataMart | 05/31/24 |
| PRJ0017211 Build Graduation/Degrees awarded DataMart | 05/17/24 |
| PRJ0020208 Data Lake Assessment | 04/30/24 |
| PRJ0020208 Phase 1 – Student Data Warehouse Cloud Migration | 01/14/25 |
Project Status
- Percentage Complete 48%
Project Phase
Executing
Communities Affected
UCI Campus
Start Date
November 2019
Estimated Completion Date
December 2026
Key Stakeholders
- Client: Campus-wide leaders, analysts, and student success researchers
- Sponsor: Business Transformation Office and Michael Dennin
- Project Manager: Sindhu Aithal
Updated on
April 4, 2024