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 Compass
Student Data Warehouse
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 Campus Data
If you would like to know more about UCI campus data and how it can be accessed with Business Analytics 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
Connect to the SDW
UCI requires users of student data to complete the FERPA Training on the UCI UCLC site. Please complete this before submitting a ticket. You will need to upload your course completion.
Request Access
Use the ServiceNow Catalog Data and Report Request Form to request data extracts, new reports, or access to data assets in the data warehouse. If you need access to an existing report, please request it via KSAMS.
MAPSS (Metrics & Analytics Promoting Student Success) Certificate Program
MAPSS Foundations of Data Literacy is now available!
In its vision to increase student success through campus-wide digital fluency, UCI is launching the MAPSS (Metrics & Analytics Promoting Student Success) Certificate Program for faculty and staff – at no cost to learners. This innovative program is organized in role-specific learning paths to fulfill professional development criteria and enhance 21st-century career path growth.
UCI Compass MAPSS Foundations for Data Literacy
Start your journey through MAPSS with “Welcome to UCI Compass MAPSS!” for an overview of the Data Culture that UCI is building.