Resolved: Institution Summary (Retention and Graduation) Inflated Retention Rates in QuickSight

Update 7/25/2025: Inflated retention rates issue is resolved. 

The issue that was causing duplications and inflated retention rates on the Retention and Graduation dashboards in QuickSight has been resolved and Retention and Graduation dashboards are now available to users in production.

Original issue:

The Campus Data Warehouse team is aware of a problem in production where retention rates on the Retention and Graduation dashboards in QuickSight are inflated as compared with our legacy system dashboards. We suspect that students are being counted as retained even if they have a zero unit load. We are currently investigating and working on a solution. 

In the meantime, you may continue to use the Retention and Graduation dashboards in our legacy data warehouse available at csumb.edu/datawarehouse.

The Retention and Graduation dashboards in QuickSight remain unavailable to users until we work to resolve this and a few other issues.

This issue is being worked on in ITSR# 23520439.

Ticket: 23520439  Date created: Thu 10/24/24 8:34 AM Pacific Daylight Time Service: Report a Problem / Computer Software/Application Problem Title: Institution Summary (Retention and Graduation) Inflated Retention Rates in QuickSight Retention Rates on the Retention and Graduation dashboards in QuickSight are displaying inflated values compared with our legacy data warehouse. This is separate from the 'rehoming'  issue we are already working on AWS/QuickSight is counting more students as retained than Oracle. See for example 2023 Fall First-Time Freshman cohort. QuickSight shows 769 students re-enrolling in 2024 Fall (1-year retention) vs. 743 in Oracle. QuickSight: Oracle: ERSS Census in QuickSight shows 743 FTF from 2023 Fall cohort enrolled in 2024 Fall (matches Oracle): Institution Summary in AWS/QuickSight shows 26 additional retained students from this cohort (inflating the retention rate). These are the extra records appearing in AWS/QuickSight for the cohort: 004918386 004930372 004935377 004939212 004942813 004964315 004966005 004981319 004986142 004986298 004994527 005000819 005000832 005005161 005028743 005050544 005051818 005054366 005059514 005061347 005063037 005076063 005076401 005076947 005077103 005103688 Checked a couple of these yesterday and it seems like they have zero unit load for 2024 Fall. Suspect the logic is not checking for zero unit load. Requested by: Michael Dorsch Created by: Michael Dorsch on Thu 10/24/24 8:34 AM Pacific Daylight Time