The City of Seattle provides effective information to Seattleites through their website – www.seattle.gov. Seattle IT struggles to understand user behavior and effectiveness of their website. They spend a lot of time creating content. However, they are unclear if this content is surfaced in ways that are comprehensible for users. Our project is an effort to develop a KPI-based framework that content creators can use to understand users and enhance the discoverability of content. Through our holistic and comprehensive framework, Seattle IT can regularly track performance and drive continuous improvement of the online experience that users and potential users have.

This application directly promotes the integrity of incident reporting metrics within the Department of Technology Services at Seattle Public Schools. Departmental resources such as providing professional training, supporting district-wide projects, balancing IT worker’s assignments, and more, rely heavily on these metrics to strategically and effectively execute within the organization. By providing an application separate from the currently misused incident system, these metrics will no longer be skewed. This ultimately affects classroom technology and its influence on student learning, where our project makes a positive impact for the teachers today as well as the students in current and future generations.

SEMANTIC ANALYSIS: The Smartsheet platform has large amounts of unstructured user feedback comments. So, the product owners at Smartsheet take a lot of time and effort to come up with actionable feedback. Our solution is a machine learning model which enables text classification of the comments by categorizing them into the following categories- Bugs/Performance, Formula, UX Integration, and UX Enhancement. The solution makes it easier to prioritize issues, delegate the requests to the concerned Product Owners, reduces the response time to user queries, and enhances the product features. Organization - Smartsheet Team Members - Ishita Shah Prithvi Shetty Vineet Kulkarni

Smartsheet is a cloud-based work management platform. To continuously innovate and improve its product and services, it constantly gauges customer sentiment and feedback via Net Promoter Score surveys. However, due to large inflow of raw comments from these surveys, and no existing mechanism to aggregate the comments other than manual intervention, the useful data is underutilized. Our solution is to apply machine learning techniques to automatically categorize the comments into useful categories. This categorized data is then presented as a dashboard to internal stakeholders to gain deeper insights into Smartsheet features and services.

Companies are being called to change their policies around harassment response and the enforcement of these policies to better support reporters and to create positive cultures. Despite this pressure, only 20% of companies have made systemic change to end harassment (EEOC June 2016 Report). Currently, there is no clear, direct way to report harassment or communicate resolutions. Our solution is an enterprise system that allows for both first person and bystander reports. By digitally tracking reports, trends of behavior can be visualized within our system and targeted policy changes can be made to improve company culture in regards to harassment.

The Virginia Beach Public Library compiles its key data into a single spreadsheet that is then used to create strategic planning documents. This spreadsheet contains a compilation of data from the various branches and is subdivided into strategic planning categories. The Virginia Beach Public Library staff recently acquired a new business intelligence tool and requested that I try to make their data live rather than static. This would reduce time and effort in creating their periodic reports to the city of Virginia Beach. My efforts with led to the creation of a dashboard accessible via the web and mobile devices.

Guiding by the philosophy of “putting people first,” BECU cares deeply about their members. Thus, resolving high-impact incidents as quickly as possible to ensure a seamless member experience is crucial. BECU IT Incident Management Portal is a one-stop online portal that provides end-to-end management of High and Critical technology incidents. It collects important information from multiple incident management and troubleshooting tools and displays the right information to help IT and non-IT employees triage, action, communicate and collaborate. Our solution empowers employees at BECU to handle critical incidents promptly and painlessly, increasing productivity and business competitiveness, and ultimately improving member satisfaction.

Disparities in Internet access among residents of the whole nation have been a serious problem in the States for decades. Unfortunately, even though there is public broadband data available, it’s hard to make sense of it. This project focuses on utilizing millions of records of broadband and census data to better serve communities across the United State. We created two new measurements for broadband deployment performance and built interactive dashboards and infographics to visualize the huge volume of data. Want to explore the broadband data in your area? Find out at https://fayechu.github.io/NTIA_Data_Visualization/frontend/index.html

UW's Institute for Health Metrics and Evaluation (IHME) publishes papers about disease research to improve population health. They gather feedback from a network of collaborators around the world, and each paper receives up to 5000 comments. We've built a streamlined system for managing comments. Our platform consolidates multiple applications into a central location that utilizes automation and intelligent triaging to process large sets of comment data quickly. IHME staff no longer need to look through thousands of comments and categorize every cell. We have built a magic button that, with just a click, reduces weeks of work into 30 seconds!