Cal State Monterey Bay - Campus Data Warehouse Updates

Configuration changes have been completed on the Campus Data Warehouse QuickSight production environment that will now allow users to be directed to Okta Single Sign On screen automatically when clicking on a shared dashboard link or share this view dashboard link.   Previously, users had to first login to Campus Data Warehouse through the CSUMB dashboard before accessing shared links.  This change should make it faster to share dashboards with other users and to avoid extra steps of going to the CSUMB dashboard to login. 

GC0006332 - GE Class Area and GE 25 Attributes - The "GE Class Area", "Class Attribute: GE 25", and "Class Attribute: General Education 2021-2024" logic as currently implemented is not working as intended. Descriptions are repeated on the dashboard (e.g. "A1~A1 Oral Communication~A1 Oral Communication"). The intention of pivoting the GE areas was that we expected some of the classes to have multiple GE Areas as attributes. Given that, we expected to see some descriptions that are combinations of various GE Areas. Need to adjust pivot logic and handle records with delete flag "Y".  Current impact for end-users is that using the GE Class Area as a filter and selecting an area, user will not see classes returned in the results that may have an additional GE Class Area that the class satisfies.

Update 9/25/2025: The Degrees Awarded (Academic Years) visualizations on the Academic Program Health dashboard have been modified on both the Bachelor's - Degrees, Enrolls, Admits and Master's - Degrees, Enrolls, Admits dashboard pages so that the Academic Year filters will automatically update to include the most recent five academic years for which degrees census data are available. 

Updated 9/25/2025:  "Academic Plan" filter controls have been added to the following Academic Program Review dashboards in are now accessible in Campus Data Warehouse production: Dashboards > Academic Program Review > Demographics [ERS Student],  Dashboards > Academic Program Review > Admissions [Admissions Funnel] Dashboards > Academic Program Review > Retention and Graduation [Institution Summary] Dashboards > Academic Program Review > Degrees [ERS Degree]

Updated 9/25/2025:  The "1-Year Retention %" metric calculation was modified to suppress the metric for cohorts where the retention rate is preliminary.  All census-based Retention and Graduation tracking dashboards have been updated globally.  All other retention and graduation metrics were checked to ensure preliminary metrics do not appear on census-based dashboards. Preliminary rates are still available on the Preliminary Retention and Graduation (Non-Census) dashboard.

The Campus Data Warehouse team is pleased to have recently launched a redesigned Faculty Student Success dashboard (FSSD). The redesigned FSSD is now available for all faculty members to access in the Campus Data Warehouse.  Each faculty member only sees data for the courses and students they have taught or are teaching. The FSSD is a personalized tool that enables individual faculty members to gain powerful insights into how their students are doing — before, during, and after the students are enrolled in the faculty member's classes. With access to academic performance data, Canvas engagement metrics, demographic information, and equity metrics, faculty can explore trends in grades, identify students who may require support, and compare outcomes across terms or course sections. Please share the following with faculty in your area: Faculty Student Success Dashboard Informational Flyer Accessing the FSSD Log in to the Campus Data Warehouse through the Cal State Monterey Bay dash...

Phase 2 Release Update 9/4/2025:  The Academic Program Health dashboard was recently updated with the Phase 2 dashboard release, which includes two additional pages with Key Performance Indicators for Retention and Graduation Rates for Fall Matriculation Term Cohorts.  Please share the following with others in your area who may have use for this information: Academic Program Health Dashboard Information Flyer The new Academic Program Health dashboard pages in the Phase 2 release include: Bachelor's - Retention and Graduation Master's - Retention and Graduation

Resolution update 9/4/2025: The Course Grades Overview Earning Credit % metrics in the visualizations are now working as expected. Class Enrollment Dataset and its children were updated and migrated from STG to PRD.

Resolution update 9/4/2025: As part of the layout of the newly released Faculty Student Success dashboard at the beginning of Fall 2025, we have added a note to the applicable dashboard pages where the Missing Assignments appears, clarifying that the metric may include assignments graded manually: Note:   "Missing" assignments  may include those  submitted outside of the normal process that you may have graded and manually entered and / or " extra credit" assignements that were not required of all students.

Resolution update 9/4/2025:  The Canvas integration process was fixed. Catch-up processes were run in production to populate the Canvas data that was missing in the loads due to the integration failures.   With the release of the new Faculty Student Success dashboard in production at the start of the Fall 2025 term, Canvas data is updating as expected on the dashboard in production. Faculty may use the new Faculty Student Success dashboard to monitor their courses' Canvas data. 

Resolution update 9/4/2025:   Changes were made to the integration processes and code base to accommodate the changes to the Canvas Course naming conventions.  With the release of the new Faculty Student Success dashboard in production at the start of the Fall 2025 term, Canvas data is updating as expected on the dashboard in production. Faculty may use the new Faculty Student Success dashboard to monitor their courses' Canvas data. 

Resolution update 9/4/2025: The CSUMB Data Glossary entry for On Time Assignments was updated to include more information on how the On Time Assignments Assignment Status and % metrics are derived from the Canvas data: The Ontime Assignments % is derived by looking at all graded Canvas assignments and the assignment status (e.g. Late, Missing, OnTime). The "OnTime" status applies when the "Submitted At" date is before the "Due At" date for the assignment in Canvas or the faculty member graded the assignment manually and entered the grade. In addition, on the "Student Detail" page linked from individual student records on the newly redesigned "Current Term Students" and "Canvas Engagement" pages of the Faculty Student Success dashboard, you can see a detailed table that presents the Canvas "Assignment Status," "Due at," and "Submitted at" information for each assignment.

Resolution update 9/4/2025: The My Graded Class List page was retired in the new version of the Faculty Student Success dashboard released at the beginning of Fall 2025, as it provided duplicate information that may be found on the Post-Course Outcomes page of the new Faculty Student Success dashboard at the student level, as well as on the Completed Term Overview and Course Grades pages at the aggregate level.