Skip to content

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 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.

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 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.

Managed Workstation COVID-19 updates

UW-IT will be working from home until June. This includes all of the Managed Workstation team. In these uncertain times we’re doing our best to balance our customer needs with being cautious with our own staff.

Computer Imaging

The OSD image installation process is highly dependent on UW network resources, and doesn’t work from a remote location.

We offer instructions on the self-service process to image the machine and the steps to have it joined to the domain under the Managed Workstation Service here: https://it.uw.edu/wares/mws/mgmt/setup-computer/osd/

Our usual high-touch approach has a number of problems during this crisis, including lack of good social distancing protocols, disinfecting practices for computer hardware, and violating direction from the UW and WA state governor.  We’ve thought carefully about balancing customer value with the potential risk and self-service imaging is the best option we have.

If there is a specific need you have, please let us know and we can work together to find alternate solutions.

Maintaining workstation connection to the UW network

We have taken steps to ensure that computers are not dropped off the domain for inactivity during this time.  However, in order to maintain a good working relationship between computers and the UW network the Managed Workstation service suggests that all computers taken off the UW network be logged in and connected to the Managed Workstation VPN service for 2 hours a week.

VPN Server Capacity

Connections to the Managed Workstation VPN have been increasing in volume each day for the past 3 weeks.  With this in mind, we are taking steps to increase capacity.  This process should be completed within the next 2 weeks.

Office Hours

Managed Workstation staff will be available for virtual office hours via Zoom on Thursday, March 26 from 10-11:30. Send an email to help@uw.edu to get a meeting invitation.

 

Kim Frye
Managed Workstation Service Manager
UW Information Technology
University of Washington

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: 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.

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 and Study Abroad Program. 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 “RPG: Study Abroad Students Report” in the subject line.

RPG Release: Time Schedule Enrollment by Day and Time Visualization in BI Portal

The Report Prioritization Group released a new visualization to the BI Portal: Time Schedule Enrollment by Day and Time.

This tool enables planning by displaying a heat map of current enrollment counts broken down by day and time in order to demonstrate times of high and low campus activity. The analysis tool divides the academic day into 30 minute increments. Student enrollments are counted during a 30 minute period if a course is scheduled during any part of a period.

How to Use this Visualization:

There are two primary ways to use this analysis tool:

Planning an Event:

A program coordinator who wants to schedule a speaker or event may have the question, “what are the time periods in between classes when students are on campus and would be more likely to attend a speaker session?”

If you filter down to a specific department, you can view all courses managed by a department. Look for the blank periods between courses:

Capacity Planning:

A planner in Student Services may want to answer the question, “When are students likely to be on campus, so I can staff my office to help students during peak times of activity?”

If you filter at the campus level, you can view the overall enrollment counts for a whole campus to view peak periods of activity:

Important Details:

Please note: This analysis tool should not be used for Learning Spaces Policy compliance. For Learning Spaces Policy work, please use the Learning Spaces Policy report in the BI Portal.

The heat map displays “current enrollment” counts as a table. The X axis displays the academic week, Monday through Saturday. The Y axis displays the academic day broken down into 30 minute increments. The Y axis time range represents the minimum and maximum times for the population of courses in the table. A heat map demonstrates periods of high and low campus activity.

The population of courses excludes those with the following attributes:

  • All Withdrawn courses
  • Courses with invalid days
  • Courses with 0 enrollment
  • Courses with SLNs equal to 0
  • Courses with invalid start or end times (e.g. 00:00, 25:00)

How are the counts calculated? Student enrollments are counted during a 30 minute period if a course is scheduled during any part of a period. For example, if a course is scheduled from 8:30 – 10:20, a single student will get counted in each of the time periods from 8:30 to 10:00, but will not be counted in the 10:30 time period. This means that student enrollments are intentionally duplicated many times throughout the visualization. This is intentional because the goal of the tool is to demonstrate when students are registered and are assumed to be “on campus” for a given time period.

Are these “current enrollment counts” or “census day counts”? The counts and times are based on current enrollment counts in the Time Schedule data that are updated daily. The data are not snapshots of census day counts. This means that if a student drops a course or registers for a course, these changes will be reflected in the visualization. The data are sourced from the EDW, are updated daily, but always reflect the previous day’s changes to Time Schedule. This analysis tool does not display real-time Time Schedule or registration changes.

Questions?

This visualization references important institutional concepts like “Section Type“, “Learning Type” and many others. If you have questions about the meaning of this 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 Visualization Question: Time Schedule Enrollment by Day and Time” in the subject line.

UW Profiles Release: Student Academic Performance Dashboards Updates

In collaboration with the Office of Planning and Budgeting (OPB), we updated the following three dashboards with new features:

Undergraduate Retention and Graduation Rates

Table View:

  • Cohort Retention and Graduation Rates by Cohort Year was improved with the following:
    • Users can select from Primary and Secondary breakdowns. Both breakdowns now include a Military Affiliation dimension.
    • Color highlighting was added to show increasing and decreasing rates from previous cohort years.
    • A “Cohort Year” multi-select filter was added.
  • The “Variation” visualization was removed from the dashboard.

Visualization View – New! 

  • Cohort Graduation Pattern visualization was added
    • Visualization includes the ability to select from Primary and Secondary breakdowns, which now include a Military Affiliation dimension.
    • Added “Cohort Year” multi-select filter (includes cohort years with at least 4 years of data)

Other:

  • The dashboard was reformatted to match UW branding guidelines
  • Deceased students are no longer included in the data for this dashboard.

Undergraduate Graduation Patterns and Time to Degree

Visualization View:

  • A “Cohort Year” filter has been added, so users are now able to see the following data for a specific cohort year and quarter:
    • Cohort size, 4 and 6 year graduation rates, in the new highlighted areas near the top of the dashboard
    • Quarterly graduation patterns
  • The “Quarterly Graduation Pattern” visualization was updated with the ability to select from Primary and Secondary breakdowns, which now include a Military Affiliation dimension.
  • The following have been removed:

Table View:

  • The tables “Quarterly Graduation Pattern” and “Trend in Time to Degree by Academic Year Awarded” have been updated with the ability to select from Primary and Secondary breakdowns, which now include a Military Affiliation dimension.
  • A “Cohort Year” filter was added, so that users can view the quarterly graduation pattern for a specific cohort year and quarter.
  • Time to Degree is now displayed in quarters (previously it was displayed in months)
  • The “Cohort Graduation Pattern” table was removed from the dashboard.

Other:

  • The dashboard was reformatted to match UW branding guidelines
  • Deceased students are no longer included in the data for this dashboard.

Undergraduate Student Persistence and Graduation by Year of Study

Table View:

  • The tables “Trend in Cohort Persistence and Graduation by Year of Study” and the “Cohort Size by Year” have been updated with the ability to select from Primary and Secondary breakdowns.
  • Primary and Secondary Breakdowns now include a Military Affiliation dimension.

Questions and Feedback:

This dashboard references many concepts like Military Affiliation and Student Academic Origin. 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: Student Academic Performance Dashboards Updates” in the subject line.

2020 MWS Customer Meetings

We’ve scheduled the quarterly Managed Workstation Service customer meetings for 2020.  The dates and locations are as follows:

  • Thursday, February 13, 2020  10:00 AM – 11:30 AM – UW Tower, Board Room
  • Thursday, April 23, 2020  10:00 AM – 11:30 AM – UW Tower, Fremont Conference Room
  • Thursday, July 23, 2020  10:00 AM – 11:30 AM – UW Tower, Visitors’ Dining Room
  • Thursday, October 22, 2020  10:00 AM  – 11:30 AM – UW Tower, Visitors’ Dining Room

We look forward to seeing you!

Kim Frye
Managed Workstation Service Manager
UW Information Technology
University of Washington

EDW Payroll data will include NWH and UWP employees

As part of the Enterprise Data Warehouse’s support for the Northwest Hospital Integration effort, beginning with the next payroll, pay period Jan 1-15, the EDW payroll data will include the Northwest Hospital (NWH) and UW Physicians (UWP) employees who are all now UW employees as of the beginning of 2020. If you have any questions or concerns, please email help@uw.edu with the subject line “EDW question regarding NWH cutover” so we can promptly assist you.

RPG Release: New Current Student Information Report in BI Portal

The Report Prioritization Group released a new report to the BI Portal, Current Student Information. This report consolidates two previous reports: Current Student Information by Major and Current Student Information by Minor. Remember to update your bookmarks to point to the new report location.

Report Summary:

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 a couple of 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!
  • 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 report 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.

What About the Old Reports?

We will continue to host the Current Student Information by Major and Current Student Information by Minor reports in the BI Portal for the time being while we migrate users over to the new report. However, in the coming weeks we will archive the old reports and will only support the new consolidated Current Student Information report.

Please remember to update your bookmarks and BI Portal favorites to point to the new report location!

Questions?

This report references important institutional concepts like “Current Student”, “URM“, and many others. If you have questions about the meaning of this 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 “New BI Portal Report Question: Current Student Information” in the subject line.