Supporting Compliance: The Bridge DEI Employee Course Completion Dashboard
The University of Washington is committed to creating a welcoming and respectful learning, working, and living environment. In support of this commitment—and in compliance with Washington state law (Senate Bill 5227)—the UW offers Cultivating Community at UW: Anti-Racism and Diversity, Equity, Inclusion, and Belonging (DEI&B). This 2.5-hour online course educates our community on topics such as racism, disability and accessibility, and LGBTQ+ identities; highlighting how these issues affect colleagues and students at the UW. The module-based format allows participants to complete the training at their own pace.
This course is required for new employees hired after June 30, 2022, who have not worked at the UW in the preceding 12 months. It must be completed within 30 days of their hire date. While optional for other employees, participation is strongly encouraged, with a long-term goal of at least 80% of staff, faculty, and other academic personnel completing the training every two years. For more information about this training requirement, refer to Anti-Racism and DEI&B in the Workplace.
To enhance the effectiveness of this program, UW-IT’s Reporting & Analytics team partnered with staff in the Office of Minority Affairs & Diversity (OMA&D) to develop a new dashboard, which is now available in the BI Portal! This dashboard tracks completion records for the anti-racism and DEI&B training (grouped by required and optional employees), identifies areas for additional outreach, and supports compliance with this crucial requirement.
Collaborating to Meet Requirements
Creating this dashboard was a team effort! OMA&D 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 to develop the dashboard.
Understanding the Data Pipeline
BI Portal resources usually rely on data from the Enterprise Data Warehouse (EDW), but this dashboard needed additional data sources. Training completion records from the Bridge Learning Management System (LMS) were combined with employee data from the EDW and Workday in Snowflake, a cloud-based data warehousing platform.
With the data view available, the dashboard was built in Tableau and fine-tuned in partnership with OMA&D to ensure it met user needs. The team thoroughly tested it to confirm everything worked smoothly and accurately before rolling it out.
Exploring the Dashboard
Check out the Bridge DEI Employee Course Completion dashboard in the BI Portal to explore the tool, including the following features.
Filters
The left panel of the dashboard provides a number of filters, which allow users to narrow results by course status, employee details, and/or various levels of the HR Hierarchy. For more information about these filters, refer to the Filters tab for the dashboard in the BI Portal.
Search
The top of the dashboard provides a search field, which allows users to search for a specific employee by UW NetID.
Results
The center of the dashboard displays the results, based on the filter or search specifications. Additionally, each row includes the completion status, indicated with a check mark (✔) or crossmark (X) icon. You can hover over these icons to display a tooltip with additional context, such as course status, HR organization, employee detail, and manager contact information for a specific employee.
Questions/Feedback/Ideas?
Do you have a question about this dashboard and/or a request for a new resource in the BI Portal? Please submit a ticket to help@uw.edu with “BI Portal” in the subject line.