Analytics Projects
Overview
The Office of Business Intelligence (BI) partners with University stakeholders to identify the analytics to best serve their goals. Below, please find a few key projects that our team has either recently completed, is currently working on, or has put on hold to resume at a later date.
Recently Completed
University Financial Assistance Loans Report
In partnership with the office of University Financial Assistance, BI created a report on loan metrics at an institutional and school level, including total loan indebtedness, private vs. institutional loans, loans by type, etc. The complexity and nuanced nature of financial aid reporting can result in inaccuracy and/or misrepresentation of data. This new report standardized frequently requested data and serves as a historical reference for each aid year.
Source: PeopleSoft Student Admin
Completed: Spring 2026
Executive Dashboards
At the request of the University President and Provost, BI created a series of executive dashboards in University Analytics, providing a standardized, high-level institutional view of new admits and new students across all six schools, as well as general enrollment trends across the institution. The reports incorporated specifications and feedback from the Provost, President, COO, and CFO, and were presented to the University Planning Committee (UPC), Deans Council, and the Board of Regents' Academic Affairs subcommittee.
Source: PeopleSoft Student Admin
Completed: Fall 2025
In Progress
Executive Dashboard: Financial Aid Loans
Following the launch of the University Financial Assistance Loans report in Spring 2026, BI is parterning with the Provost Office and University Financial Assistance to curate a high-level summary for the Executive Dashboards collection.
Source: PeopleSoft Student Admin
Expected Completion: Summer 2026
Graduate Retention Report (OIE)
In collaboration with the Office of Institutional Effectiveness (OIE), BI is building a fifth-week enrollment census-based retention report for the University's graduate programs. This new report will track graduate student retention rates, helping the University better understand student persistence and completion patterns. Similar to first-time undergraduate cohort reporting already offered by the OIE, this addition represents the first phase of a larger project for BI to integrate retention-related metrics into existing University Analytics reports.
Source: PeopleSoft Student Admin
Expected Completion: Fall 2026
University New Student Melt
"Melt" describes the population of admitted applicants for a given admit term who indicated intent to enroll (paid a deposit, etc.) but then dropped, withdrew, or discontinued from their program. The Office of Business Intelligence already offers a New Student Melt report for Seaver undergraduate programs. This report will expand reporting to graduate programs as well.
Source: PeopleSoft Student Admin
Expected Completion: Fall 2026
University Financial Assistance Annual Data Report
In partnership with the office of University Financial Assistance, BI is building a report that includes key financial assistance data points at an institutional and school level, including loan indebtedness, institutional aid, etc. The complexity and nuanced nature of financial aid reporting can result in inaccuracy and/or misrepresentation of data. This new report will standardize frequently requested data and serve as a historical reference for each aid year.
Source: PeopleSoft Student Admin
Expected Completion: Fall 2026
On Hold
Online Learning Report
As the University's online presence continues to grow, BI has worked with the schools to identify and create methods for tracking online programs, courses, and students in PeopleSoft, the University's system of record. In partnership with the Offices of Institutional Effectiveness (OIE) and Online Learning, BI is building a dedicated report collection focusing on these programs, highlighting data and trends pertaining to their particular courses, as well as monitoring on-ground/online course percentages for compliance with accreditation standards.
Source: PeopleSoft Student Admin
On Hold Reason: Pending further discovery and potential scope changes with stakeholders
CRM Recruitment (Waves) Integration
In collaboration with the CRM team, CRM Governance Committee, and University Data Partners, BI is integrating recruitment and admissions data from the University’s Enterprise CRM (Waves) into the Enterprise Data Warehouse and University Analytics. New data models and/or reports will include metrics on application status, recruitment stage, marketing source, and more.
Source: Salesforce Recruitment CRM
On Hold Reason: Initial scope of the project shifted to focus on application counts, based on data
from the Salesforce Data 360 integration.
Cost of Instruction (COI)
The "Cost of Instruction" extension for Blackboard Analytics Student Management will help strategic leadership teams assess instructional costs, providing financial insights and the ability to understand direct margins, revenues, and instructional costs at the course, student, college, and department/division level.
Source: PeopleSoft Student Admin and PeopleSoft HR
On Hold Reason: Pending further discovery and potential scope changes with stakeholders
Data Systems/Integrations/Other
Migration to Power BI Service (Cloud)
University Analytics is currently powered by Microsoft's Power BI Report Server, an on-premise version of Microsoft Power BI. The cloud-hosted version, Power BI Service, offers advanced features and capabilities for report developers and consumers alike. A igh-level comparison is provided below.
Status: Discovery
Salesforce CRM (Data 360)
The original phase of the project will focus on bringing in total application numbers from all six schools' recruitment systems via the University's Constituent Relationship Management (CRM) system - specifically, the Waves org.
Source: Salesforce Recruitment CRM (Waves)
Status: In Progress