From Siloed Data to Integrated Insights: Building College Profiles

Wednesday, May 27, 2026

10:15 AM - 11:00 AM East Coast USA Time

Location: Shaw/LeDroit Park

Institution Type: 4-year institutions

Target Audience: Any

Presenter(s)

Michele J. Hansen, Ph.D.

Associate Vice President, Institutional Research and Planning
The Ohio State University
Columbus, Ohio, United States
Jay Johnson, M.A., PMP

Assistant Vice President for Institutional Research and Reporting
The Ohio State University
Columbus, Ohio, United States
Katie Smillie, MS

Assistant Director of Student Success Analytics
The Ohio State University
Columbus, Ohio, United States
NN

Negash J. Negash, BS

Senior Data Analytics Specialist
The Ohio State University
Columbus, Ohio, United States

Session Abstract: Institutional leaders and stakeholders need integrated, accessible, and actionable data to support planning, decision making, accreditation, and program review. This session focuses on how, the Institutional Research and Planning team at The Ohio State University developed College Profile Dashboards within the Reporting and Analytics Environment (RAE)—a centralized AWS Redshift–based system built on Medallion Architecture (Bronze, Silver, Gold layers). The dashboards combine data across HR, Finance, Advancement, and Student domains. We will demonstrate how the College Profiles were conceptualized to integrate quantitative metrics with clear definitions and college level context, offering stakeholders a holistic view of strengths, opportunities, and progress across Academic Excellence Plan metrics.

Keywords: Integrated Data Dashboard, Data Literacy, Data Governance, College Profiles