Archives: Service News

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:

1. “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 that are excluded are those with “Unknown Enrollment Status” (i.e. Enroll status = 0)
2. New Filters:
   1. Quarter:
      • In the previous version of the report, the report population advanced to the next quarter during academic breaks.
      • In the new version, the Quarter filter allows users to choose the current quarter, or upcoming quarters.
      • For instance, during Spring 2020, users can select Spring, Summer, or Autumn 2020 . During a break period, you can choose from the current quarter, or the upcoming quarter.
   2. Enrollment Status:
      • In researching this update, we heard disagreement about whether to include or exclude students with enrollment statuses other than Registered (e.g. students that withdrew at some point before or during the quarter).
      • Rather than enforce a rule that people didn’t agree on, we decided to allow users the flexibility to decide if they need to see Withdrawn students.
3. New Columns:
   1. ASUW:
      • By request, we added a field to the report to identify if a student is a member of ASUW and is eligible to vote in student elections.
      • The field displays a Y or N based on the student’s student_1 record.
   2. Minor Dates:
      • We added the Minor Date 1, 2, and 3 fields to the reports. These fields represent the date the student “declared” the Minor. These fields are included in the “Default” selection in the Columns to Display filter.
      • These fields were a part of the the previous Current Students Information by Minor report, but were not available on the new report, so we added them by user request.

A Reminder:

• Consolidation: You no longer have to access two separate reports to get information on current students by major and minor. The report now features a single filter that allows you to filter by the Major or Minor of interest in a single report!
  • In the coming weeks we will archive the existing Current Student by Major and Minor Reports. Please update your bookmarks!

Questions and Feedback:

This report references important institutional concepts like “Current Student”, “URM“, and many others. If you have questions about the meaning of these or any other term, please explore the links or find more detail in the Knowledge Navigator.

As always, if you have any questions, please write help@uw.edu and put “BI Portal Report Question: Current Student Information” in the subject line.

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 tool allows users to explore peer cost data in three different views. You can tab through the story to view the following:

• Total Cost of Attendance
• Tuition and Fees
• Detailed Cost of Attendance

Questions and Feedback:

This dashboard references many IPEDS concepts and definitions like Tuition and In-state Student . To get detailed definitions for these and other terms, please check out Knowledge Navigator!

As always, if you have any questions, please write help@uw.edu and put “UW Profiles: Cost of Attendance Story” in the subject line.

 

 

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 only the students who had grades below 2.0
• The report returns Harry’s 0.9 grade.

Requesting Feedback:

While making this update, we heard two additional requests. Before we make these changes, we want to hear your feedback to understand if they will help or hurt you. Please write us at help@uw.edu with “RPG: Student Grade Report by Major” in the subject line.

• Remove the Filter “Current Student as of”:
  • We heard that this filter is confusing and is often ignored, so we are proposing to remove the filter to reduce confusion.
  • We will not change the “Look up Transcript Year/Qtr” filter, and now it will be the primary “time” filter for the report.

• Add a Filter “See All Grades”:
  • Consider the hypothetical Harry Potter case again. When the adviser applies the Course Grade filter, the report currently only returns the 0.9 grade. But the adviser may want to see the student’s other grades to see if the low grade is part of a pattern.
  • We are proposing to add a filter that would allow you to see all of the student’s grades for the quarter, if any of the student’s grades meet the filter criteria.
  • For instance, since Harry has one grade in the range 0-1.9, the report would return all three grades 3.8, 3.9, 0.9.

Questions and Feedback:

This report references many UW institutional concepts, including Cumulative GPA and Quarterly Grade Point Average. To get detailed definitions for this and other terms, please check out Knowledge Navigator!

As always, if you have any questions or if you would like to provide feedback, please write help@uw.edu and put “RPG: Student Grade Report by Major” in the subject line.

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 in Workday. It is not their title for the quarter that they taught the course.
• A user’s ability to access EDW data is limited by their EDW ASTRA role. As a result, not all users will be able to view the Instructor Title data. Due to the security settings on this HR/P data, users with the Adviser/Academic Staff EDW ASTRA role cannot view Instructor Title, and will see blank values in the report. For more information on EDW Security, please visit IT Connect: https://it.uw.edu/work/data/data-security/

Questions and Feedback:

This report references many UW institutional concepts, including Business Title. To get detailed definitions for this and other terms, please check out Knowledge Navigator!

As always, if you have any questions, please write help@uw.edu and put “RPG: Time Schedule Information Report” in the subject line.

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 is sortable to easily identify students with registration holds (“Y”)
  • Hold Office:
    • This column displays the office that placed the hold.
    • If a student has more than one registration hold, those offices display as a comma separated list.
  • Hold Reason:
    • This column displays the free-text description of the reason for the registration hold.
    • If a student has more than one registration hold, those reasons display as a comma separated list.

Questions and Feedback:

This report references many UW institutional concepts, including Student Hold. To get detailed definitions for this and other terms, please check out Knowledge Navigator!

As always, if you have any questions, please write help@uw.edu and put “RPG: Student Degree Information” in the subject line.

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: You no longer have to access two separate reports to get information on current students by major and minor. The report now features a single filter that allows you to filter by the Major or Minor of interest in a single report!
  • In the coming weeks we will archive the existing Current Student by Major and Minor Reports. Please update your bookmarks!
• Updated Timing: Based on user feedback, we also updated the logic for identifying the “current quarter” during the academic break periods between quarters.
  • In the old reports, during an academic break, the old reports looked at the quarter that had just completed. For instance, during summer break, users complained that there was a period before the start of Autumn quarter where the report was not usable because it displayed only information about the previous (completed) quarter.
  • In the new report, one day after a quarter ends, the report looks forward to the next quarter’s enrollment information. For instance, during Summer break, the report displays Autumn quarter enrollment information. We reviewed this change with many users, and all agreed that this was an improvement over the old reports.

Questions and Feedback:

This report references important institutional concepts like “Current Student”, “URM“, and many others. If you have questions about the meaning of these or any other term, please explore the links or find more detail in the Knowledge Navigator.

As always, if you have any questions, please write help@uw.edu and put “BI Portal Report Question: Current Student Information” in the subject line.