Supporting Training Compliance: Two New Hazing Prevention Dashboards

The University of Washington is committed to fostering a safe and respectful environment for all students and employees. As part of this mission, the Office of Community Standards & Student Conduct (CSSC) offers an essential online training program on the dangers of hazing. Underscoring its critical importance, this training is mandatory for all incoming students and employees.

To enhance the effectiveness of this program, UW-IT’s Reporting & Analytics team partnered with CSSC to develop two new dashboards, which are now available in the BI Portal! These dashboards track completion records for hazing prevention training, identify areas for additional outreach, and support compliance with this crucial requirement.

For more information about these courses, refer to:

• Hazing Prevention Student Course
• Hazing Prevention Employee Course

Collaborating to Meet Requirements

Creating these dashboards was a team effort! CSSC staff provided the requirements and feedback, while folks in the Reporting & Analytics Web Applications and Business Intelligence (BI) teams pulled the data from various sources and developed and tested the dashboards.

Understanding the Data Pipeline

Typically, BI Portal resources utilize data from the Enterprise Data Warehouse (EDW); however, these dashboards required an additional data source. Because the training is managed by a third-party vendor (AliveTek), completion records had to come from them, while student and employee data had to come from the EDW. This integration is what made the data meaningful and actionable for users.

To combine these data sources, Indra Narayan, a Data Engineer from the Web Applications team pulled data from AliveTek via an API and loaded it into Snowflake, a cloud-based data warehousing platform. In Snowflake, Indra integrated key student and employee data from the EDW and Workday, creating a comprehensive view for Tableau Dashboards.

With the data ready, Grzegorz (Greg) Grabowski, a Sr. BI Developer from the BI team built the dashboard in Tableau and collaborated with CSSC to ensure it included all necessary elements to meet user needs. Finally, Tracy Fisher, a Software Tester also from the BI team, verified the functionality, accuracy, and stability of the dashboards before they were deployed to production.

About the New Dashboards

Hazing Prevention Employee Course Completion

The Hazing Prevention Employee Course Completion dashboard offers a comprehensive summary of employee participation in the course, highlighting the total number of employees. You can drill down into specific data using filters like completion status, completed date, HR Org status, and employee status. There’s even a search function for specific NetIDs. You can also hover over the checkmark (✔) or crossmark (X) icons in the results to display a tooltip with additional context, such as manager information and HR organization.

Hazing Prevention Student Course Completion

The Hazing Prevention Student Course Completion dashboard offers a comprehensive summary of student participation in the course, highlighting the total number of students and those involved in UW athletic programs. You can drill down into specific data using filters like completion status, enrollment information, college, department, sport, and more. There’s even a search function for specific NetIDs or student numbers. You can also hover over the checkmark (✔) or crossmark (X) icons in the results to display a tooltip with additional context, such as manager information and student academic organizations.

The dashboard also identifies which students are also employees, providing key information to support follow-ups and identify trends.

Access Information

As each dashboard reports on different populations, the users who have access to the completion data are also different between dashboards.

Requesting Access to the Dashboards

Access to these dashboards is secured by a UW group, which is managed by the Office of Community Standards & Student Conduct.

To request access, email nohazing@uw.edu with one of the following subject lines (whichever is applicable):

• “Access Request: Hazing Prevention Employee Course Completion”
• “Access Request: Hazing Prevention Student Course Completion”

Questions?

Please submit questions as follows to ensure they reach the appropriate team and get a quicker response.