Cal State Monterey Bay - Campus Data Warehouse Updates

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

We are pleased to announce that enhancements to the Enrollment Pre-Census Snapshots) dashboard are now available in Campus Data Warehouse. Enhancements include: Changed logic for Year Ago metrics to use Snapshot Day Number like Enrollment Planning and Admissions Pre-Census. Added additional Enrollment Metrics (FTEs and Units). Group Breakdown Redesign implemented, which will allow easier searching for users. Trends visualizations consistent with changes made to Admissions Pre-Census (difference and percent difference metrics are available in the table below and visuals have been updated to include additional enrollment metric selections).  Multilevel Crosstab Table user experience improvements: New Group Breakdown controls, simplified controls. Table layouts change based on Group Breakdown selections (eliminates extra empty row headers); subtotals added for groups. Heat map coloring shows intensity for each metric across groups.  Getting to the dashboard: Navigation and Help...

Update 10/29/2025:  The Post-Course Outcomes page of the Faculty Student Success dashboard in Campus Data Warehouse now has an "Admission Basis Group" filter that will allow faculty to exclude the Transitory or unknown admission basis group students from the analysis of whether the students continue to be enrolled, graduated, or are not graduated and not enrolled.   By de-selecting "Transitory" and "Unspecified" from the  Admission Basis Group  control, these students will not appear in the data visualizations on the dashboard.  GC0004628 - Add a way to filter Transitory students from FSSD Post-Course Outcomes In our August DUAG workshop, a faculty member highlighted that transitory students appear on the Faculty Student Success dashboard Post-Course Outcomes page as "Not Enrolled and Not Graduated." We can add a filter to enable faculty using this analysis to filter out Transitory students.  

Update 10/22/2025:  After successful load of the Fall 2025 APDB census load on 10/22/2025, the APDB Overview one pager is now showing data for the 2254 (2025 Fall) term as expected. 

The Campus Data Warehouse has been loaded with APDB census data for the summer and fall 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: continues to be unavailable in QuickSight) Note: We need your help ensuring any problems you see are reported. Please submit a  Campus Data Warehouse Problem ticket  for any issues so we can resolve them. 

The Campus Data Warehouse has been loaded with ERS applicant and student census data for the Fall 2025.  You may now find updated census data on the following dashboards: Overviews: Enrollment (Census) Overviews Admissions Funnel (Census) Overview 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 Academic Program Health > Enrollment and Admissions Several Common Data Set and Chancellor's Office Reports dashboards. Note: We need your help ensuring any problems you see get reported. Please submit a  Campus Data Warehouse Problem ticket  for any issues so that we can resolve them. 

The dashboards built on the Class Enrollment Dataset in QuickSight are not displaying data before the 2014 Academic Year.   This issue impacts all Grades dashboards, FSSD, Course Enrollment Demographics, etc.  Both Stage and Production environments show the same behavior.  Identified issue as a filter in the SMSP code that needs to be changed to allow earlier Academic Years and Terms to appear. Optimize Case: GC0007863

The Campus Data Warehouse has recently been loaded with ERS Credential data for the Issuance Year 2024-2025.  You may now find updated data on the following dashboards:   Credentials:   Credential Recommendations  Note: We need your help ensuring any problems you see get reported. Please submit a  Campus Data Warehouse Problem ticket  for any issues so that we can resolve them. 

The Campus Data Warehouse has been loaded with Degrees census data for the summer of 2025.  You may now find updated census data on the following dashboards: Degrees:  Degrees (Census) - Academic Years Detail Degrees (Census) - Terms Detail Time and Average Units to Degree Degrees (Census) - Composite:  Degree Honors Degree (Census) - Composite Multilevel Crosstab Table Academic Program Review:  Academic Program Review > Degrees and Retention and Graduation Academic Program Health > Degrees Awarded Preliminary Retention and Graduation (Non-Census):  Graduation Retention and Graduation:  Graduation Initiative 2025 (all) Retention and Graduation Detail Major Migrations Note: We need your help ensuring any problems you see are reported. Please submit a  Campus Data Warehouse Problem ticket  for any issues so we can resolve them. 

Academic program and Academic plans have the wrong effective date when integrated with the various ERSx data models (e.g. Applicant, Student, etc.)  As a result, Academic Program and Academic Plan fields on the dashboard may reflect changes to these fields beyond the snapshot date of the various ERSx datasets. For example, when we load the self-support census merge into the data models, students that changed their Academic Program or Academic Plan after census may appear in a different program or plan than they were in at Census.  The Data Warehouse team is working on reviewing and updating the logic to use the snapshot date rather than the sysdate or load date 

Update 10/9/2025:  The Campus Data Warehouse interface has been updated and transformed to Amazon Quick Suite .  When you log in, you'll notice that the look and feel is slightly different, though the navigation is very similar. Site Navigation:  The left-hand navigation area still contains the Favorites , Dashboards , and Shared Folders .  There is also a new Home page that is now the default landing page for all users when logging into Campus Data Warehouse or when clicking on the Amazaon Quick Suite logo in the top navigation to return to the navigation interface. New Home page: The new  Home page includes new Widgets that can be added or removed to customize your Home page. Recents , which used to appear in the left-hand navigation area, has now been added to the Home page as a widget. This Recents widget displays the dashboards you have recently viewed. Many of the enhanced AI-powered and agentic features in Amazon Quick Suite are not currently available...

The Campus Data Warehouse has been loaded with ERS applicant and student census data for the summer of 2025.   You may now find updated summer 2025 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.