Cal State Monterey Bay - Campus Data Warehouse Updates

We are pleased to share that a new Academic Program Health dashboard is now available to all users in Campus Data Warehouse production. The Academic Program Health Phase 1 dashboard release consolidates key academic program metrics across Degrees Awarded, Enrollment in Major, and Admissions Demand for both Bachelor's and Master's programs into a single dashboard view that can be filtered to a College, Major, or Concentration.  The new Academic Program Health dashboard in the Phase 1 release includes: Key Performance Indicators for the most recent Academic Years or Fall terms, with change from the prior year, and five-year trends for Degrees Awarded, Enrollment Headcount and FTE in major, and Admissions Funnel metrics (Applicant Count, Admit Count, New Enrollment Count, and admit to Enrollment Yields). A new visualization type available in Amazon QuickSight (Custom Narrative Insights), which provides dynamic narrative bullets below each metric trend that describe the year-over-y...

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...