Cal State Monterey Bay - Campus Data Warehouse Updates

Update 4/24/2025: " GE Class Area"  is displaying as expected across all of the impacted course-related dashboards except for Cost of Instruction, which cannot yet be validated due to ongoing issues with the Cost of Instruction dashboard in production. Example below of GE Class Area "A1" in Fall 2024 shows FYS 111 and HCOM 110 courses in alignment with the source. Academic  Class : APDB Section: Class  Enrollment: Class  Instructor: Cost of Instruction could not yet be validated in PRD due to ongoing failures in the dataset refresh.

Update 4/24/2025: The Academic Program Health dashboard was updated in Campus Data Warehouse production to correct the issue we were previously seeing with Concentrations not appearing correctly for the College of Education.   

Update 4/24/2025 : The Course Enrollment Demographics dashboard in Campus Data Warehouse production was updated to fix parameters not updating on dashboard reset and removal of "Low Income" data visualizations on the Overview. Additional dashboard changes and enhancements included: Overview: Add Class Section count KPI Layout and formatting changes for consistency Race Ethnicity graph reformat Remove Low Income Rearrange graphs  Recolor graphs Formatting all legends and graph labels to make fonts bigger Add the Residence Location drill-down on the Region Color gradation on the Major table Insight added for the top 10 majors  Replace custom narratives with parameters with single-cell tables Default Acad Course Name to HCOM 110 (high enrollment course) Trends Replace custom narratives with parameters with single-cell tables Layout and formatting changes for consistency Reorder on-dashboard controls Fix “% Class Headcount” in the dataset and replace in the pivot table Multilevel...

Update 4/24/2025:  The Course Enrollment Demographics > Trends dashboard page has been updated in Campus Data Warehouse production to modify the "% Class Headcount" field calculation to be aggregate for a given Term rather than Academic Years so that percentage totals are not split across multiple terms when multiple Term Names are selected. 

The Campus Data Warehouse team is aware of a problem with the APDB Section - Term FTES and SFR dashboard (and potentially other APDB Section dashboards). The Group Breakdown data for "CSU APDB Learning Mode" are not correctly populating (all appear null).   We are currently working on a solution.  In the meantime, you may continue to use "Course Modality Group" and "Flexible Course Option Group" breakdowns on the APDB Section dashboards. This issue is being worked on in ITSR# 24296157.  ----- Original Message -----     Ticket - 24296157   Service - Report a Problem / Computer Software/Application Problem Update - Changed Status from New to In Process . Title - APDB Section Term FTES and SFR Trends - CSU APDB Learning Mode Group Breakdown Not Populating The CSU APDB Learning Mode Group Breakdown is not populating as expected on any of the visualizations. I suspect this is a problem either in the QuickSi...

Update 3/27/2025:  After our Spring 2025 APDB Census data load, the Campus Data Warehouse team has identified that data for Spring 2025 on the Cost of Instruction dashboards is incorrect after the APDB load. Values are inflated for Enrollment and potentially other metrics due to an issue with duplicate records. We are working to troubleshoot the problem in both our legacy (Oracle) and modernized (QuickSight) systems. 

The Campus Data Warehouse has been loaded with APDB census data for the spring of 2025.  You may now find updated census data on the following dashboards: Courses: Academic Planning Database (APDB) > APDB Section - Annualized FTES Academic Planning Database (APDB) > APDB Section - Avg Class Size and Credit Load Academic Planning Database (APDB) > APDB Section - Faculty Instruction Academic Planning Database (APDB) > APDB Section - Multilevel Crosstab Table Academic Planning Database (APDB) > APDB Section - Term FTES and SFR Academic Program Review: Student Faculty Ratio > State Sessions (APDB) Common Data Set I - Classes Cost of Instruction (Note: the Campus Data Warehouse team has identified that data for Spring 2025 on the Cost of Instruction dashboards is incorrect after the APDB load. Values are inflated for Enrollment and potentially other metrics due to an issue with duplicate records. We are working to troubleshoot the problem in both our legacy (Oracle) an...

A new Group Breakdown Look-Up dashboard page has been added to the Navigation and Help dashboard in Campus Data Warehouse production.  Users will be able to use this dashboard to search for the "Group Breakdown" field to identify which "Group Breakdown Category" to find the field in across various data models and dashboards.  We will overview and test this with DUAG in our March 27 workshop. Any follow-up issues emerging from DUAG feedback will be submitted as a problem ticket after the workshop.     Ticket - 24115997   Service - Software & Applications / Campus Data Warehouse Model & Report Enhancement Update - Changed Status from New to Completed . Title - Add a help analysis for group breakdowns Group breakdowns with their categories are stored in a Quicksight dataset so a dashboard could be built on top of it for allow for searching of group breakdowns to find the category under which they are display...

Update 3/26/2025: The Degrees (Census) - Academic Years Detail dashboard has been updated in Campus Data Warehouse to fix issues with Academic Plan filters that were not filtering the data on the dashboards as expected. In addition, other minor fixes were made to correct formatting with notes on the dashboards and remove redundant Academic Plan filters on the CSUMB / College / Major Comparisons dashboard.    Multilevel Crosstab Table:  Add a filter for CSU Academic Plan = "pAcademicPlanOwner" to all table views,  CSUMB / College / Major Comparisons:  Remove redundant Acad Plan filters from visualizations,  Fix notes/delete icons,  Degrees Awarded Academic Year Trends:  Fix notes/delete icons,    Update : Changed Percent Complete from "0 %" to "100 %". Ticket : 22794773 Ticket Description : Running the Degrees Awarded AY Trends (attached). Collaborative Health & Human Services in 2...

Updated 3/26/2025: The Course GPA Equity Gaps dashboard in Campus Data Warehouse has been corrected so that the First Generation metrics that previously appeared all as zeros are now populating with the expected values.