UCI | Office of Information Technology

SDW wordmark logo
UCI Compass Student Data Warehouse
Data Request Form
MAPSS Certificate Program

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.

 

Unlock the Power of Student Data: Discover the UC Irvine Compass Student Data Warehouse

Are you interested in analyzing student and course enrollment data? Join our upcoming webinar to learn how you can leverage the UCI Compass Student Data Warehouse (SDW) for your analytical and reporting needs.

September 26, 2024 // 11:00 a.m. – 12:00 p.m.

Register to Attend

What You’ll Learn

Overview of the Student Data Warehouse and Explorer tool • Current data sources available

How to access curated reports and self-service query • How to connect to SDW using Tableau or Tibco

Special Features

Data analysis and visualization tools • No Tableau license or previous Tableau experience needed for pre-existing reports

UCI affiliates of all levels of technical ability who are interested in accessing and analyzing student data are welcome to attend!

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
Figure of UCI campus data before SDW

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
Diagram illustrating Campus Data Utilizing the Student Data Warehouse

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

Pyramid model of Business Intelligence Tools for different types of users

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. 

Data Request Form

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.

Start your journey through MAPSS