Cal State Monterey Bay - Campus Data Warehouse Updates

Update 7/25/2025: The issue with rehoming returning students into their appropriate cohorts that was impacting the Retention and Graduation dashboard has been resolved. Retention and Graduation dashboards are now available to users in QuickSight production.

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.

Update 7/25/2025: The following dashboards with Retention and Graduation data are now available in QuickSight production Shared folders > Dashboards >  Retention and Graduation > Retention and Graduation (Census) > Retention and Graduation Detail Retention and Graduation > Retention and Graduation (Census) > Major Migrations Retention and Graduation > Preliminary Retention and Graduation (Non-Census) > Preliminary Retention and Graduation (Non-Census) Overviews > Retention and Graduation Overview Executive Overview > Executive Overview Academic Program Review > Retention and Graduation WASC > WASC Chancellor's Office Reports > IPEDS > IPEDS - Grad Rates Common Data Set > B - Retention & Graduation Update 12/3/2024: Graduation Initiative 2025 dashboards are now available in Campus Data Warehouse production, but other Retention and Graduation dashboards remain unavailable.  The following dashboards are now available in QuickSight:...

Updated 7/25/2025: The remaining Retention and Graduation dashboards have been released in QuickSight production and the visualization issues outlined below have been resolved on the dashboards: Overviews > Retention and Graduation Overview > Major at Matric control is not showing relevant values - FIXED Retention and Graduation Detail > Trend Overview > Bar graphs view for UDT Cohort Type is coloring is all brown - FIXED Retention and Graduation Detail > Trend Comparisons > Enhance with trend graph visualizations - COMPLETED. Page has been redesigned to better enable trending. Retention and Graduation Detail > Entering Cohort Tracking > In Overview view Enrolled % in table is not correct - FIXED WASC > Retention > L ine trend graphs for First Generation are the same color for all categories - FIXED WASC > Graduation > L ine trend graphs for First Generation are the same color for all categories - FIXED Update 12/3/2024: The Graduation Initative 2025...

Update 7/25/2025: The Retention and Graduation Detail > Equity Gaps dashboard is corrected and now available in QuickSight production. Update 10/4/2024:  The Course GPA Equity Gaps dashboard has been fixed in production to accommodate the changed "CA Legal Gender" labels of "Woman" and "Man" made to OASIS last month. You may now again use this dashboard to see Course GPA Equity Gaps for courses between students identifying as "Woman" or "Man".  The Retention and Graduation Detail > Equity Gaps remain unavailable to users as we continue to work on fixing issues with 'rehoming' returning students and the CA Legal Gender label changes.     Ticket : 23366232   Service : Report a Problem / Computer Software/Application Problem Date created : Fri 9/20/24 2:47 PM Pacific Daylight Time Title: Equity Gaps Dashboards (Retention & Graduation and Grades) CA Legal Gender Broken Changed...

Update 7/25/2025: The issue with Retention and Graduation rates that were not updating on the Executive Overview in Campus Data Warehouse has been resolved in this is now available to users in QuickSight production.

Update 7/1/2025: The daily load was restarted manually and loaded for 6/30/2025. Today's daily load for 7/1/2025 was completed successfully following the automated process. We continue to monitor.

Update 6/26/2025: The issue with access to the legacy Campus Data Warehouse (Oracle) has been resolved. You may now access the legacy system at https:csumb.edu/datawarehouse. Note: we continue to monitor daily loads in the legacy system after several days of data load failures. If you experience any problems with login to Oracle, please open an Optimize case .

Updated 5/20/2025:  The Admissions-related dashboards have been updated in Campus Data Warehouse production to incorporate feedback and bug fixes discovered in our February Data User Advisory Group workshop.  Many thanks to our DUAG members for providing feedback and helping us to make these dashboards better for all campus users! Summary of enhancements and changes by dashboard page:  Admissions Funnel Detail > Global Remove images in note boxes that were not appearing in PRD Layout standardization/alignment Remove on visual menus from title bars/text boxes/layout border boxes Default Group Breakdown Category controls to Academic Plan Admissions Funnel Detail > Admissions Funnel Overview Fix “Admit to Enrollment Yield/Counts” colors/data labels Fix graph subheads Change the Metric selector to radio buttons Conditional color formatting on pivot tables Grand totals on pivot tables Minor layout updates for alignment Admissions Funnel Detail > Admissions Demographic...

The Campus Data Warehouse team is aware of a problem with the DFW Grades and a few other related dashboards in production where the CSU Major Concentration Group Breakdowns (e.g. College Description, Major Long Description, Concentration, etc.) are not populating on the dashboards. We are currently working on a solution.