The Prosecuting Attorney’s Office prosecutes all felonies in King County. Their decisions are based on experience but minimal statistics. With increased complexity in crimes and rising need to analyze data from multiple law enforcement agencies, we collaborated with their Firearms Violence department and developed an infrastructure to analyze criminal data. The prosecutors got a better understanding of the trends across key metrics. Now, they can analyze bullet casings to link different incidents, extract an individual’s historical criminal involvement and work with law enforcement agencies to increase referral rate, thereby, improving the sponsor's overall data literacy.

This project aims at helping organizations find the best talent with minimal effort. The idea is to utilize data analytics and machine learning methodologies to identify the common characteristics of the top-performing employees in a company. The project is targeting two main research questions: 1. Finding a good fit employee within the top 5 technology companies 2. Identifying what makes a successful Individual Contributor vs Manager The project concludes that certain features such as title and tenure are strong predictors of top-performing employees in an organization. Good hiring is an essential factor for the growth and success of any company.

Portland Pedal Power (PPP), is a delivery and catering delivery service, based out of Portland that differentiates itself from the competition with the usage of bicycles. Business Intelligence is the process of equipping organizations to make better decisions with the usage of data. A data warehouse architecture coupled with reporting capabilities will allow the leadership of PPP to better understand their customers. This project warranted the capstone team to upgrade the existing data infrastructure, define and automate ETL (Extract Transform, Load) processes to combine disparate sources of data and build interactive data visualizations and report to make everyday decisions easier.

Libraries must mitigate chronic funding issues through fundraising. At the same time support from stakeholders has become more important, requiring more-effective friendraising. These needs led the Association of Research Libraries to award an ARL SPEC Kit on Library Development to document support (personnel, funding and other resources) for library development, and the work methods, efforts and assessment types for development at major libraries. The national data collection and analysis will culminate in an ARL-published Open Access monograph, and an ARL-hosted webinar. The unique data set and findings support leaders in benchmarking fundraising and friendraising capacity, and in assessing library development.

Encore Capital Group, a leading global provider of debt management and recovery solutions for consumers in 15 countries, recently forayed into the digital world and launched several digital marketing campaigns across all platforms such as Google, Bing, Yahoo, Facebook etc. However, they were reliant on the reporting portal of the individual platforms to make investment decisions. Team Insight Squad performed extensive data research and analysis and built an end-to-end BI tool that integrated these data sources, transformed it and built a customized dashboard that provides key insights to track campaign performance, optimize the ad dollar spend, and enable budget pacing.

Currently the only way to estimate your lawn size is by physically measuring it. Lawn Vision breaks the norm to be the first service that uses computer vision on satellite images to calculate your lawn area. Homeowners can use Lawn Vision to communicate more effectively with lawn care professionals and receive accurate quotes. Whereas lawn care professionals can access the right information to prepare for the job and sign onto projects faster, now with greater transparency. This service provides Porch with new data that will be utilized to restructure their current pricing model.

Mito, derived from Latin for “giving with ease”, provides a social platform that lets users purchase products online to send to each other without exchanging physical addresses. Our solution offers a seamless process for buying goods for recipients while protecting users’ address information at all cost. A transaction on Mito no longer requires users to share their private address with one another.

The goal of this project was the creation of a beverage and flavor taxonomy and ontology to allow the Starbucks Business Intelligence Team to successfully complete analytics and pick up trends. Terms, definitions, and structures were developed through a combination of current-state domain research, stakeholder interviews, and use case scenarios. Our ontology will enable Starbucks to better understand the relationships between their products and the metadata around them. The taxonomy and controlled vocabulary we have established will aid the analytics team by demonstrating hierarchies and relationships so that their is data more organized so it can be effectively used.

The nonprofit King County Dispute Resolution Center (KCDRC) provides affordable mediation and conflict resolution services to individuals, businesses, and families in pursuit of justice and peace. Recent loss of major funding has placed heavy pressure on KCDRC’s people, processes, and information systems, which must now function more competitively despite loss of resources. Our team spent five months researching the organization’s needs, current practices, and nonprofit best practices, then delivered two workshops, a comprehensive strategic report with recommendations, and several information system interventions to support better document, data, and project management in service of crucial fundraising activities.