New Feature: 25th and 75th Percentile Scores added to Common Data Set C - FTF Admissions

The Common DAta Set C - FTF Admissions dashboard has been updated in Campus Data Warehouse to display 25th and 75th percentile scores needed for Common Data Set reporting. Previously these had to be calculated with other tools due to limitations in the calculations in our legacy data warehouse system. 

New features: 

  • C - FTF Admissions: 
    • New metrics were added for each of the Redesigned SAT and ACT scores to display 25th percentile and 75th percentile scores in addition to the median scores (50th percentile) that were already available. 
    • Uploaded Image

 

Ticket - 23494627 
Service - Software & Applications / Campus Data Warehouse Model & Report Enhancement

Update - Changed Status from In Process to Completed.

The C - FTF Admissions dashboard was successfully migrated to PRD and now includes 25th and 75th percentile metrics in the FTF SAT/ACT scores table.

Title - Add 25/75th percentile test scores to CDS dashboard

We are supposed to report the 25th, 50th, and 75th percentile for the various SAT/ACT test scores. OBIEE was not able to do 25/75 so only the 50th (median) was created in Quicksight. 

Uploaded Image
in the new toolset, we seem to have the functionality to address this now (percentileIf)


expect this will be Quicksight (dataset & visual) only
 

Requested by - Sathyan Sundaram
Created by - Sathyan Sundaram on Fri 10/18/24 11:45 AM Pacific Daylight Time