iSchool Capstone

UW Global Impact Tracker for Office of Global Affairs

Project tags:

data curation

data science & visualization

database administration & development

While the UW Office of Global Affairs (OGA) relies on the Global Publications Dashboard to showcase UW faculty’s scholarship and worldwide collaborations, its user retention has decreased since the data source became outdated in 2019. Some users couldn’t find the desired information, such as statistics regarding the department’s global presence and international co-authorship. Additionally, some faculties’ work has not been acknowledged. To address this issue, we retrieved 2 million rows of up-to-date data, improved the name-matching process, added indexing to increase database performance, and developed a networking tool to empower UW faculties to enhance global engagement and facilitate research collaboration.

Project participants:

Vivian Yu

Informatics

Kelly Wang

Informatics

Lucy Zhu

Informatics

Jinwoo Kim

Informatics

Jiali Liu

Informatics