Student Data in the Reporting and Analytics Environment (RAE)

The Student Data in the RAE project will democratize and extend access to data in a single central source of validated core raw data and appropriately curated data sets built from the raw data for use in business data domain related projects across the university. This effort, in particular, will add student-based raw and curated data sets into the RAE which could then be used by multiple other data analysts/engineers and be comparable, joined, and enabled for shared and integrated applications across multiple business data domains (HR, Finance, etc.).

Key Contacts: Glenn Donaldson, CK Bhatia

What strategic pillars does it support? 

  • Teaching 
  • Research 
  • Operational Excellence & Innovation 
  • Culture of Belonging 

Why is it important? 

This project is an important effort to bring together raw student data with high quality curated cumulative datasets built from the raw data into a central, governed source in the Reporting and Analytics environment. While raw student data is currently available to university analysts in our Oracle data warehouse, many curated datasets have been created by analytics units which are not available across the wider university. Migrating raw student data along with these critical datasets into the RAE will unlock the analytics potential of our institutional data by democratizing existing data resources. 

Who will benefit? 

The project will be of immediate benefit to analysts, decision makers, and students across the University. Analysts who use student data directly will see efficiency gains from enhanced availability and governance of curated cumulative datasets. Those who rely on timely and accurate analysis of student data for decision-making, including faculty and staff leadership, will benefit from increased analyst efficiency as well as the entirely new analyses that access to curated datasets will enable. Finally, students will be the ultimate beneficiaries of this project as the increased access, visibility, and governance resulting from the project will allow OSU leadership to make data-driven decision making to improve the student experience.  

What is the timeline? 

  • Work on the project began July 1, 2023 
  • Work on the project will continue until December 31, 2024  

Who are our partners and sponsors? 

Office of Academic Affairs – Brad Harris 

Office of Institutional Research and Planning – Michele Hansen 

Office of Strategic Enrollment Management – Linda Katunich

What other OTDI groups will be needed?

  • Research Technology and Infrastructure (Breon) 
  • Service Desk (Max) 

How will success be measured? 

  • # of tables ingested, # of data elements 
  • # of reports, dashboards, users that consume this data 
  • $ savings from making this data easily accessible
Learning, Research, Innovation and Belonging icons highlighted within IT Pillars Supported graphic