UCI Compass
Student Data Warehouse
The Student Data Warehouse (SDW) is a secure, centralized, data repository that integrates data from various sources to empower faculty, staff, and students to make data-informed decisions. The SDW stores curated current and historical data in support of operational reporting, institutional analytics, and research.
Like any large and complex institution, UC Irvine has many sources of key institutional data that should be considered strategic University resources. These resources are in a wide variety of systems and formats. UCI is developing a centralized data warehouse where these resources can be brought together to inform strategic decision-making on campus in a manner that makes our institutional data consistently accessible, reliable, and secure.
UCI Student Data Before and After the Student Data Warehouse
BEFORE
Campus Data Silos Before Student Data Warehouse
- No centralized reporting
- Campus units can only get some of the data
- No data curation
- No single source of truth
- Units working independently from the rest of the campus
AFTER
Campus Data Utilizing the Student Data Warehouse
- Centralized repository – reduce shadow systems & silos
- Data are curated – quality control, value-adds
- Data are connected
- Student data – Students, Enrollments, Admissions, Degrees
- Enterprise data – Student, Financial, HR, Space, etc.
- External data – Connectible to SDW data
- Data are protected – access levels & controls, the principle of least privilege
- Governed, documented content
- Support self-service
- Data are accessible
- Facilitate users getting to correct answers
Goals and Benefits of the Student Data Warehouse
CENTRALIZED
Reduce data silos and units sending data to each other
CURATED
Quality control, consistency, value-added features
CONNECTED
Internally, externally, to other warehouses
PROTECTED
Security and access controls, implemented centrally
GOVERNED
Setting rules for content, access, growth, etc.
WELL DEFINED
Agreement on meaning and use of each data element
DOCUMENTED
Definitions published to “Metadata” tool
AGNOSTIC
Data are consumable by myriad tools and users
Features of the Student Data Warehouse
Organization
Organized to support reporting and analysis
Phased Development
- New content prioritized and added over time
- Built with growth/expansion in mind
Current and Historical Data
- Today’s view or any past day/term
- Census snapshots for each term, daily detail within terms
Learn More About Business Intelligence Tools
If you would like to know more about UCI campus data and how it can be accessed with Business Intelligence Tools, go to UCI Compass Explorer.
The Compass Explorer portal is UCI’s front door to student success analytics tools created by TLA, EMA, OIR, and other groups. Explorer provides access to a comprehensive catalog of tools, dashboards, reports, and analytics to track and improve student outcomes. Whether you are an advisor, an instructor, an academic leader, or an academic administrator, you will find something useful on the new UCI Compass Explorer website.
Include Your Data
If you are an owner of campus data and are interested in including your data in the SDW or have any other questions about the SDW, please email sdw-support@uci.edu.