Cal State Monterey Bay - Campus Data Warehouse Updates

Since the Amazon Web Services (AWS) launch of the new Quick Suite Data Preparation experience last month, some existing datasets are producing (CONTEXTUAL_UNKOWN_SYMBOL) errors when attempting to migrate updated datasets from our stage to production accounts for Campus Data Warehouse. Impacted datasets (so far): Class Enrollment (Grades, Faculty Student Success, Course Enrollment Demographics dashboards and others) Institution Summary (Retention and Graduation dashboards and others) The impact for our Campus Data Warehouse development team and end users is that we cannot currently migrate any new development that relies on these updated datasets to production. Several bug fix and enhancement tickets that have been completed in our stage environment are pending migration to production. AWS support case 176411999700835 has been submitted, and AWS support acknowledges that the Quick Suite Service Team is aware of these issues and is actively working on it. However, the AWS support team ha...

Following feedback received at our October Data User Advisory Group workshop, we made a few visualization enhancements to the Preliminary Retention and Graduation (Non-Census) Not Retained and Not Graduated page that are now available to Campus Data Warehouse users in production. The map illustrating Not Retained and Not Graduated groups of students by Student Origin: Residence Location has been enhanced with a control that allows users to switch between Not Retained and Not Graduated Count or Percent metrics as the coloring for the map. In addition, a Cohort Term Enrollment filter has been added so that users may filter out residence locations with smaller initial cohort enrollment.  In addition, for a more granular look at cohort retention tracking by Last School Attended, a new table is available at the bottom of the Not Retained and Not Graduated page that groups students by their Last School Attended Type, Country, State, City and Last School Attended.

Updated 12/3/2025:  The issue with the Enrollment Term filter not properly updating the cohort and Matriculation Term displayed on the Preliminary Retention and Graduation (Non-Census) > Not Retained and Not Graduated page has now been fixed in Campus Data Warehouse production.  Users may now select prior Enrollment Terms and Cohort Metrics to see the Not Retained and Not Graduated groups of students from terms prior to the enrollment term students are currently registering for.

Update 11/25/2025:  The issue with terms prior to the 2014 Academic Year on dashboards built off of the Class Enrollment Dataset has been resolved in Campus Data Warehouse production. Grades, FSSD, and Course Enrollment Demographics should now show the historical data when selecting prior Academic Years on the dashboards. Example from Course Enrollment Demographics > Trends showing historical data prior to 2014 Academic Year.

Dashboard changes for the default Race / Ethnicity displayed on data visualizations are coming soon to Campus Data Warehouse.  With the deprecation of CSU Race Reporting Category collection by the Chancellor's Office on October 1, 2025, we will be replacing the default Race / Ethnicity displayed on the various overview dashboards to use the existing IPEDS Race / Ethnicity (IPEDS Race/Ethnicity Reporting Category).  New IPEDS Underrepresented Minority (URM) and IPEDS Race / Ethnicity (Federal) fields will be created using IPEDS Race / Ethnicity.  In addition, the current field names will change to reflect the deprecation of the CSU Race/Ethnicity Reporting Category & Ethnic Code fields. Current Field Name Planned New Field Name Logical Source Data Availability Race / Ethnicity Legacy Race / Ethnicity (pre-2026) CSU Race/Ethnicity Reporting Category & Ethnic Code (Old) Stops collecting data for new applicants as of October 1, 2025 Underrepresented Minority Descripti...

Wait List metrics have been added to the metric selectors on the Class Schedule > Enrollment, Capacity, Units, FTES & SFR page and the Class Schedule > Multilevel Crosstab Table page.  These new metrics will allow users to identify class sections that have large numbers of students on the waitlist and to identify how many class sections across a course have students on the waitlist that may justify adding additional sections of a class to meet demand.  Tip: to sort the Class Schedule by the Total Wait List field, use the Sort feature on the Subject Description, Academic Course Named, and Class Section Code column headers to sort those rows in Descending order by Total Wait List. This will sort the subjects, courses and sections by the Total Wait List and help identify subjects, courses and class sections with more students on the wait list.

Update 11/07/2025:  Changes to the Enrollment (Census) Overviews dashboard to fix the colors on the bar charts to be consistent throughout are now available in production. Additional layout and visualization changes were made for consistency across all visuals on the overviews including making legends a larger font size, moving legend location to the top for all bar visualizations, and widening bar visualizations where appropriate. 

Updated 11/07/2025:  The logic fix for pivoting the "GE Class Area," "Class Attribute: GE 25," and "Class Attribute: General Education 2021-2024" fields on the various course-related dashboards has been migrated to production.  Dashboards with these fields available as filters show the expected values. Classes that satisfy multiple GE areas will have combined descriptions (e.g. 5B |5C for GE 25). For selecting a class which satisfies multiple GE class areas, use the combined description from the filter control dropdown.  Other changes for these fields will be coming soon, including a renaming of the fields to indicate which ones were relevant within date ranges and also additions of the GE25 fields across all of the courses-related dashboards. 

We are pleased to announce that enhancements to the Preliminary Retention and Graduation (Non-Census) dashboard are now available in Campus Data Warehouse.  Enhancements to Preliminary Retention and Graduation (Non-Census) available in Production Consolidated Spring and Fall retention into one page that automatically updates term view based on registration term in progress Additional years added for each tracking metric so that current cohort can be compared with prior 5 cohorts New KPI visualizations showing change for current registration term versus prior cohort Heat map coloring shows intensity for each metric across cohorts New Not Retained and Not Graduated page enables analyses of students from cohort not retained and not graduated by College and Major, Student Origin, Demographics, and Preparation at Matriculation New Multilevel Crosstab with user experience design improvements New Group Breakdown controls, simplified controls Table layouts change based on Group Breakdown s...