Versions Compared

Version Old Version 64 New Version Current
Changes made by

Mohammed

Mohammed

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Technical Details

Current Release Version: 20232024.1.1b0

Release Date

Report Location: PowerBI / Apps / SPS Leadership

...

Requested Features

Current Cycle

Release

...

2024.1.

...

1 [

...

December 2024]

Features to Complete

  • Add the "Sponsered Program" filter to the enrollment-only report in PBI
  • Replace the 'Target Defined' with 'Sponsored Program' in the 'Enrollment and Tuition' and ''Enrollment Only' pages.
  •  Trends
    • Include selector for the targets to use for the trend analysis instead of defaulting to the latest available for the term
      • This can get complicated when the targets are not aligned across the years (e.g., the latest for 2022 was Q1, but for 2023 it was Q2)
    • BUG: Spring forecast charts are off, likely caused by the offset date method to keep numbers from spanning over two years.
    • Include headcount, average credits, and tuition as alternate data points
    • Filtering
      • Allow switching view between daily, weekly and monthly
  • Data Extracts
    • Include other tables in the extract page
      • UI to switch between data to be extracted
      • Engage EBIS to see if we can enable PBI Automate to save files to Google Drive

...

  • Change top level slicers to multi-select by click (not CTRL)
  • SQL Only:  Add @_output = ''tuition_only' output for the tuition data without the target
  • SQL Only:  added REGI code exclusions for Summer 24
  • SQL Only: added TRY_CAST to CTD_Offset, CTD, CTD_MonthNum, CTD_Week fields

Previous Cycles

Release 2024.1.0 [October 2024]

  • Tuition Melt
    •  Changed the Target Term from 20241 to 20243.
    • Note: Click on the Target Term visual, open the Filters page, and under the 'Filter on this visual,' change the Term_Identifier from 20241 to 20243. 
    • To change the Bookmarks, click View and select the 'Target Term' visual; then under the Bookmarks pane click 'Add' to add a report Bookmark. Delete the old 'Projected Melt' and name the new report bookmark 'Projected Melt'.
    • SQL Only: Change the Version_Name from 'Q3 Projection' to 'Q1 Projection' in the a2_evt_tuition_projection stored procedure

Release 2023.1.1b [August 2023]

...