Cal State Monterey Bay - Campus Data Warehouse Updates

Update 3/26/2026:  The issue with Tuition Load Status Description Group Breakdowns has been corrected in Campus Data Warehouse production and is now pulling the expected values on the Enrollment dashboards. 

Update 3/25/2026:  The Admissions-related dashboards based on the Admissions Funnel dataset have been updated with the renaming of Legacy Race / Ethnicity fields and the addition of IPEDS Race / Ethnicity fields. The IPEDS Race / Ethnicity and IPEDS Underrepresented Minority (URM) fields have replaced the Legacy Race / Ethnicity (pre-2026) and Legacy Underrepresented Minority (pre-2026) filters in the Controls dropdowns at the top of each dashboard. Both the IPEDS and Legacy fields are available in the Group Breakdowns, but the Legacy fields will not have data for 2026 Fall applicants.  Additional dashboards will be updated with these changes in the coming months, and we will share updates as these changes are available in the Campus Data Warehouse.

The Admissions (Pre-Census Snapshots) dashboard is updated in Campus Data Warehouse with the following enhancements:  IPEDS Race / Ethnicity filters  have replaced the Legacy Race / Ethnicity and Legacy Underrepresented Minority filters in the Controls section along the top of each dashboard.  Standardized filters so that each page has consistent layout for the on-dashboard filters and Controls dropdown.  Group Breakdown redesign simplifies the steps needed to find a Group Breakdown and enables searching for category or field names.  Link updates for IAR Website/Data Glossary changes.  Notes on Same Point in Time and links to Snapshot Day Number glossary entry.  Admit Term Overview KPIs and redesign for Same Point in Time Comparison with prior term.  NEW Last School Attend page with geospatial visualization by Last School Attend Country, State, and City enables viewing changes in Admissions Funnel metrics for current and prior term by Last Sch...

The Admissions Funnel (Census Snapshots) | Admissions Funnel Detail dashboard is updated in Campus Data Warehouse with the following enhancements:  IPEDS Race / Ethnicity filters  have replaced the Legacy Race / Ethnicity and Legacy Underrepresented Minority filters in the Controls section along the top of each dashboard.  Standardized filters so that each page has consistent layouts for the on-dashboard filters and Controls dropdown. Group Breakdown redesign simplifies the steps needed to find a Group Breakdown and enables searching for category or field names. Link updates for IAR Website/Data Glossary changes. Multilevel Crosstab Table user experience updates enable different table layouts that hide unnecessary Group Breakdown or metric columns. New Related dashboards page.  Group Breakdown controls have been redesigned to combine categories and fields in one dropdown that can be quickly scrolled through or searched using the Search box at the top of the list.

Update 3/25/2026:   The issue with the "Difference in Current Term Metric from Prior Term" and "Percent Difference in Current Term Metric from Prior Term" fields has been resolved on Admissions (Pre-Census Snapshots) > Daily Trends. The metrics are now updating appropriately based on filter selections.

Update 3/25/2026:  The issue with the null data appearing for Race / Ethnicity fields across Enrollment (ERS Student) and Admissions Funnel historical census dashboards has been resolved. These data are now populating across dashboards as expected.

Update 3/25/2026: The Admissions Funnel process has successfully run for the last two days and the Admissions (Pre-Census Snapshots) dashboard is updating as expected with daily snapshots.

The Campus Data Warehouse has been loaded with APDB census data for the Spring 2026.  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 

The Campus Data Warehouse has been loaded with ERS applicant and student census data for Spring 2026.   You may now find updated Spring 2026 census data on the following dashboards:  Enrollment:  Enrollment (Census) > Terms Detail  Enrollment (Census) > Academic Years Detail  Term Enrollment Fast Facts > Enrollment Fast Facts (Census)  Admissions:  Admissions Funnel (Census Snapshots) > Admissions Funnel Detail  Academic Program Review:  Admissions  Demographics   Several Common Data Set and Chancellor's Office Reports dashboards.

The Cost of Instruction dashboard in Campus Data Warehouse (QuickSight) has been decommissioned. A replacement dashboard developed and maintained systemwide by the Chancellor's Office is suggested as an alternative. Background on Known Issues:  Since the launch of Campus Data Warehouse in AWS QuickSight in August 2024, the Cost of Instruction dashboard has experienced ongoing data quality and functionality issues that have not been fully resolved. These issues have impacted the reliability of the dashboard for reporting and analysis. Over the past two years, multiple alerts have documented persistent problems with the Cost of Instruction dashboard, including: Incorrect and inflated metrics due to data duplication and modeling issues.  Data inaccuracies following APDB census data loads, particularly affecting enrollment and other key measures.  Dashboard errors and failures to return results in production.  Ongoing validation and refresh issues preventing reliable use...

Following January DUAG and Focus Group feedback, the following enhancements were made and are now available on the Class Meeting Timeblocks dashboard in Campus Data Warehouse production:  Add Academic Course Name on-dashboard control/filters on all pages (for identifying curriculum conflicts).  Add Combined Course Section control/filter in Controls section all pages.   Note and conditional symbol added to indicate Combined sections on detail table.  Note and link to all Combined Sections for selected filters all pages.  New S3 datasource integration to dataset and URL action (menu) for 25Live space entries added on detail table.     

 A new dashboard, CSUMB Experience Survey 2025 Results , is now available to all users in Campus Data Warehouse production.   The CSUMB Experience Survey 2025 Results dashboard provides reporting on the Spring 2025 administration of the CSUMB Experience Survey, a homegrown survey administered every 3 years since 2009 covering various aspects of students' academic and nonacademic experiences. In Spring 2025, the survey was substantially revised, with campus partners, and administered to all student levels, expanding beyond the undergraduate degree-seekers in past administrations. The response rate for the Spring 2025 survey was 22.5%.  The new dashboard provides improved, flexible reporting with many more options to dig into the data with user friendly tools.  Access is available to all users in Campus Data Warehouse via:  Shared folders > Dashboards > Surveys > CSUMB Experience Survey.  The Overview page summarizes Most Satisfied (Top 10) and...

The Enrollment (Census) Terms Detail > Term Trends page was updated with a fix so that the metrics appropriately change in the pivot table when users change the metric selector on the dashboard.  GC0023143 - Enrollment (Census) Terms Detail Trends Table Not Updating -  The pivot table on the Enrollment (Census) Term Trends page is not updating appropriately when changing the metric from Headcount to various FTE metric options. The metric stays as Headcount even if FTE metric is selected. The graph visuals on the page are updating as appropriate. Note: appears to be a parameter problem (not passing to the table calculation).