Posts

Showing posts from February, 2025

New Dashboard: Enrollment Planning > Admissions Funnel Projections Available

Image
The Campus Data Warehouse team is pleased to share that a new dashboard, Enrollment Planning > Admissions Funnel Projections, is available in production. Users who have completed the Alternate Data Access Request form will have access to the new dashboard.  Navigating to the dashboard:   Folder path:   Shared folders > Dashboards > Enrollment Planning > Admissions Funnel Projections   Navigation and Help dashboard:  Select the "All Dashboards" view and filter for the topic "Enrollment Planning"; follow the link to any of the Admissions Funnel Projections dashboard pages   About the dashboard:   The Admissions Funnel Projections dashboard was created to automate a report previously created manually for Enrollment Management.  The dashboard incorporates interactive dimensionality leveraging the Admissions Funnel data model in the Campus Data Warehouse and enables comparison of daily snapshot data for an upco...

Resolved: Navigation and Help Dashboard Broken Links

Image
Update 2/27/2025:  We have implemented a temporary solution in Campus Data Warehouse production to fix the broken links on the Navigation and Help dashboard.  We continue to work on a more robust solution for navigation across related dashboards. 

Class Enrollment Duplicate Records Due to FSSD Integration Skewing Aggregate Metrics

The Campus Data Warehouse team is aware of a problem in production where some metrics on the Grades dashboards are inflated slightly due to duplicate records in the dataset. We are currently working on a solution.  This issue is being worked on in ITSR# 24073974. 

Campus Data Warehouse Loads Failing

Image
Alert: Campus Data Warehouse daily data loads are currently failing.  This is because the Chancellor's Office removed the ISIR_COMPUTED table from the Data Lake as of Tuesday, 2/18/2025. This is breaking the load plan and causing load failures.  The Campus Data Warehouse team is currently working on a solution and will provide updates as they become available.

Resolved: Linked Term Dates Calendar Missing Some Term Dates

Image
Update 2/18/2025:  The Term Dates Calendar dashboard in Campus Data Warehouse production has been updated and the previously missing date fields are now populating as expected. 

Executive Overview Retention & Graduation KPIs Not Updating

Image
The Campus Data Warehouse team is aware of a problem with the Executive Overview dashboard in production where the KPIs are not updating automatically to reflect the rates for the most recent cohorts available. We are currently working on a solution. In the meantime, you may use the Executive Overview in our legacy data warehouse (Oracle). The Executive Overview remains unavailable in Campus Data Warehouse (QuickSight) as we work to implement solutions for inflated retention rates and rehoming returning students. This issue is being worked on in ITSR# 24055689. Date reported: Tue 2/18/25 10:46 AM Pacific Standard Time   Ticket - 24055689   Service - Report a Problem / Computer Software/Application Problem Update - Changed Status from New to In Process . Reassigned this Incident from ITSS-Help Desk to EDM-Campus Data Warehouse Team. Title - Executive Overview Retention & Graduation KPIs Not Updating The Executive Ov...

Course GPA Equity Gaps > First Generation Groups Display '0' for many metrics

Image
The Campus Data Warehouse team is aware of a problem with the Course GPA Equity Gaps dashboard in production where the 'First Generation' equity gap analysis is displaying incorrect / zero '0' data for several of the metrics on the table visualization. We are currently evaluating a solution.  This issue is being worked on in ITSR# 24038277. Date reported: Thu 2/13/25 2:32 PM Pacific Standard Time   Ticket - 24038277   Service - Report a Problem / Computer Software/Application Problem Update - Changed Status from New to In Process . Reassigned this Incident from ITSS-Help Desk to EDM-Campus Data Warehouse Team. Title - Course GPA Equity Gaps > First Generation Groups Display '0' for many metrics The Course GPA Equity Gaps dashboard in Campus Data Warehouse production is not displaying correct data for the First Generation groups. Several of the columns show all zero '0' values for courses but these s...

Degrees (Census) Dashboards "Degree Description" Filter Problems

Image
The Campus Data Warehouse team is aware of a problem with the Degrees (Census) dashboards in production where the "Degree Description" filters are not displaying the correct values and not filtering Academic Plan filter controls as intended. We are currently evaluating the problem and working on a solution.  This issue is being worked on in ITSR# 24035896. Date reported: Thu 2/13/25 10:35 AM Pacific Standard Time   Ticket - 24035896   Service - Report a Problem / Computer Software/Application Problem Update - Changed Status from New to In Process . Reassigned this Incident from ITSS-Help Desk to EDM-Campus Data Warehouse Team. Title - Degrees (Census) Dashboard Degree Description Filter Problem Across various Degrees (Census) dashboards the "Degree Description" filter that should be associated with the Academic Plan dimension shows Degree Group from CSU Major Concentration rather than Degree Description . This re...

Resolved: Class Schedule > Crosstab Table % of Column metric problem

Image
Updated 2/12/2025:  The Class Schedule dashboard in Campus Data Warehouse production has been updated and now reflects the fix for the "% of Total Enrollment" column on the Multilevel Crosstab Table.  

Resolved: Academic Class Dashboards: Graduate and Non-Graduate Student Enrollment Units Metrics

Image
Update  2/12/2025:  The Courses (Non-Census) Overview and Class Schedule dashboards in production now reflect the fix for "Non-Graduate Student Enrollment Units Total" and "Graduate Student Enrollment Units Total".

Resolved: Enrollment Fast Facts (Census) > Residence Location Not Appearing for Some Codes

Image
Update  2/7/2025 :  The Enrollment Fast Facts (Census) dashboard has migrated to Campus Data Warehouse production and includes a visualization fix for the Region table collapse issue. This migration also includes a fix for the sticky parameter issue we were experiencing with the subtitle block where the term and date parameters did not refresh when users reset the dashboard.

New Feature: IPEDS - Admissions Dashboard Now Includes New Admission Basis Filters

Image
Update 2/7/2025: The Chancellor's Office Reports > IPEDS - Admissions dashboard was updated in production and is now filtered to exclude the Admission Statuses I, M, E.