Reports and Analytics News
May 28, 2020
RPG New Report Release: Undergraduate Transcript Course Search by Major
The Report Prioritization Group just released the newest addition to the BI Portal: Undergraduate Transcript Course Search by Major In this news story we explain the purpose and benefits of the new report. If you have any questions, please don't hesitate to write help@uw.edu and put “BI Portal Report Question: UG Transcript Course Search by Major” in the subject line. What's In a Name? We admit, the report has a long name, Undergraduate Transcript Course Search by Major. But each word explains something about the report's function. Undergraduate: This report is based on the same underlying population and data in...
Read RPG New Report Release: Undergraduate Transcript Course Search by Major
May 27, 2020
RPG Release: Current Student Information – Population and Filter Updates
Based on this user feedback, the Report Prioritization Group released several important and timely updates to the BI Portal report Current Student Information. Change Summary: This release includes 3 important changes to the Current Student Information Report: "Current Student" Population: The report population in the previous version of the report included registered students as well as new confirmed applicants. Based on feedback from users we determined that these new confirmed applicants did not meet the criteria for "Current Students". We updated the report population to only include students with registration records for the user-selected quarter. The only students with registrations...
Read RPG Release: Current Student Information – Population and Filter Updates
May 11, 2020
UW Profiles Release: Cost of Attendance Peer Comparison Dashboard
In collaboration with the Office of Planning and Budgeting (OPB), Enterprise Reporting and Analytics just introduced the newest Peer Comparison Dashboard to the UW Profiles: Cost of Attendance Story Dashboard Summary: The Cost of Attendance Story is the latest Peer Comparison Dashboard. Like the other Peer Dashboards, Cost of Attendance sources data from IPEDS. Also like the other Peer Dashboards, the Cost of Attendance Story allows you to compare UW's Cost of Attendance to a variety of Peers. The Peer Group dropdown gives you the flexibility to choose the peer group you want to see: As a Tableau Story, the...
Read UW Profiles Release: Cost of Attendance Peer Comparison Dashboard
May 7, 2020
UW Profiles Release: Bug Fix in Graduation/Retention Data Model
Based on user feedback, we released an update to the UW Profiles Graduation/Retention Data Model to resolve a bug. The issue and resolution are described in the Change Summary Below. This update affects the following UW Profiles dashboards: Undergraduate Retention and Graduation Rates Change Summary: The issue in the data model was that for the spring cohort, the 1 Qtr Retention rate displayed on the UG Retention and Graduation Rates dashboard was incorrectly showing the rate based on summer quarter enrollment, not fall quarter enrollment. This resulted in incorrect 1 Qtr Retention rates displaying in the dashboard (i.e. a 1...
Read UW Profiles Release: Bug Fix in Graduation/Retention Data Model
April 15, 2020
RPG Release: Student Grade Report by Major (Bug Fix)
In response to user feedback, the Report Prioritization Group just released an update to resolve a bug in the Student Grade Report by Major in the BI Portal. Change Summary: A user reported that the Course Grade Filter was incorrectly filtering out students. We identified and resolved the problem in the report's query. Now when you use the Course Grade Filter, the report filters down to only the grades of students that meet the filter criteria. Consider the following scenario: The student Potter, Harry completed three courses, and received three grades: 3.8, 3.9, 0.9 Harry's adviser runs the report to see...
April 15, 2020
The Newest Addition to the EDW: Time Travel with dimTime
If you work with time data, a new reference table in the EDW makes it easier than ever to manipulate time in your SQL query. What is it? The new dimTime table has a row for each minute of the day for a total of 1,440 records. Each "minute record" has details including: a minute key a cleaned up and normalized minute field the minute record rounded up or down the quarter-hour, half-hour, and hour AM/PM Indicators See for yourself: --Server: edwpub.s.uw.edu DECLARE @startTime time = '11:19' SELECT timekey , StandardTime , RoundDownQtrHour , RoundUpQtrHour , RoundDownHalfHour , RoundUpHalfHour ,...
Read The Newest Addition to the EDW: Time Travel with dimTime
April 3, 2020
RPG Release: Updated Instructor Title on Time Schedule Information
Based on user feedback, the Report Prioritization Group just released an update to the Time Schedule Information report. Run the report to see for yourself! Change Summary: A user requested that we update the “Instructor Title” field on the report. They told us the data was often sparse and didn't allow them to meaningfully group Instructors based on title. We replaced the Workday “Job Title Abbreviation” with the Workday “Business Title” in the report. Here’s an example of the differences: Before the Update: After the update: Please Note: The Title displayed in the report is the Instructor's current Business Title...
Read RPG Release: Updated Instructor Title on Time Schedule Information
March 26, 2020
RPG Release: Registration Hold Information Now on Student Degree Info Report
Based on user feedback, the Report Prioritization Group just released an update to the Student Degree Information report. Run the report to see for yourself! Change Summary: Based on a user request, the report now includes Registration Hold Details. The primary use for this information is to allow advisers and others to look at students who have applied to graduate in a future quarter, but currently have a registration hold. Columns to Display This filter now includes a "Reg Hold" option. When a user selects Reg Hold, the report now displays three new columns. New Columns: Reg Hold: This column...
Read RPG Release: Registration Hold Information Now on Student Degree Info Report
March 10, 2020
RPG Release: Current Student Information – Bug Resolved
Based on this user feedback, the Report Prioritization Group released a bug fix to the BI Portal report Current Student Information. Change Summary: Due to an error in the logic, the report was inadvertently excluding 14 minors from the Major/Minor dropdown. This problem was reported by users via help@uw.edu and resolved in a recent release. The dropdown now includes a complete list of UW Majors and Minors. A Few Reminders: This report displays a population of students that have enrolled in courses during the current quarter based on the selected major or minor. This report has two key features: Consolidation:...
Read RPG Release: Current Student Information – Bug Resolved
March 9, 2020
RPG Release: Study Abroad Students Bug Resolved
Based on this user feedback, the Report Prioritization Group just released a bug fix to the Study Abroad Students by Unit Report. Change Summary: At the start of a quarter, prior to census day, the report was inadvertently excluding some study abroad students from the report. This problem was identified and resolved in a recent release. Previously, the report sourced from an EDW table that was only updated quarterly, after census day. The report now sources data from a UWSDBDataStore table that updates daily with information from SDB. Questions and Feedback: This report references many concepts like Study Abroad Student...