iSchool Capstone

2025

Project Logo

AI Powered Data Quality Checker

Our project, sponsored by Included AI and Info Edge, focuses on enhancing data reliability through an AI-powered data quality checker. The solution identifies anomalies, standardizes inconsistent entries, and visualizes data integrity metrics, ensuring clean and trustworthy datasets for business insights. We developed automated pipelines that detect and correct real-world data issues, such as inconsistent location naming and missing fields. An intuitive dashboard allows stakeholders to monitor data quality over time. By integrating AI with usability, our tool reduces manual cleaning effort, increases trust in analytics, and empowers data-driven decision-making across enterprise teams.
Project Logo

MatchMind – Intelligent hiring tool powered by LLMs, RAG and GraphDB

We leveraged the nascent AI native RAG and Graph Database to develop a resume screening and shortlisting tool. Traditional ATS systems often present challenges for hiring managers and recruiters. Strict text-matching methods may screen out capable, qualified candidates who word their resumes differently from the job description. To address this issue, we employed a GraphDB to uncover latent relationships among entities, enabling a more semantic understanding of candidate profiles. Additionally, we packaged these capabilities into a chatbot interface, allowing hiring managers to interact with resumes and job descriptions using natural language.

2024

Project Logo

Pixel Pioneers: Expanding a nonprofit’s AI medical screening abilities to Tuberculosis

Low income populations often lack access to health insurance that enables them to test for illnesses. Tuberculosis alone carries an estimated price tag of $287 per test in the United States. In an effort to counter this out-of-pocket expense, we constructed an advanced machine learning model that predicts the likelihood an individual has Tuberculosis with high accuracy. The prediction is based on symptoms, demographics, and a self recorded cough recording, and the process is quick and easy with the help of a chatbot. By using our application, individuals can make an informed decision about whether medical intervention is necessary.
Project Logo

AI Potential with Service Requests and Incidents

Within the City of Seattle, the IT Department resolves service requests and incidents through service/help desk or the Service Hub system. Given the complexity of the data generated from the system, it's challenging for IT staff to extract actionable insights to expedite the resolution of stalled requests. This project aims to transform organizational management embedded with AI techniques. By implementing Llama 2 with the LangChain framework and running open-source large language models locally, we developed a chatbot (EVAN9000) to optimize operational efficiency while ensuring data security. Extensive experiments and evaluations have validated its effectiveness for promising enterprise-level use cases.
Project Logo

Arena Sports: Data Pipeline Modernization

Team Cherry Balls worked alongside Arena Sports to modernize and migrate their data pipeline to a new system. Previously, their data services utilized a less-efficient platform that led to inaccurate reports and laborious report building. The new system utilizes Fivetran, a cloud based data movement service, and connects to Microsoft’s Power BI, allowing for more consistent synchronizations and easier access to data. With our new workflow, we can now provide easier and more accurate dashboards to help various stakeholders of the firm gauge their operational health.
Project Logo

Chīmu: Improving Team Dynamics to Make Projects Efficient, Collaborative, and Fun

Students who work in team projects often experience issues such as poor communication and a lack of accountability. Chīmu aims to reduce negative team experiences by emphasizing communication, responsibility, and feedback. The goal is to start a conversation by providing awareness that issues are occurring. Chīmu does this through critical features that allow teams to understand each other and build trust, set clear expectations, and encourage reflection for building continuous improvements. Chīmu strives to facilitate teamwork that creates a safe environment for students and promotes working through issues in a constructive manner.
Project Logo

DataSmart DEI Dashboard

GEN (Gender Equity Now) has developed a unique DEI certification recognized as the industry gold standard for gender equity. This comprehensive certification process includes insights from different processes such as organizational surveys, internal audits and leadership interviews. Traditionally, these processes were managed manually through sporadic emails, potentially diminishing the client experience. To enhance efficiency and client interaction, Team Dataverse Explorers undertook industry research and user interviews to develop a multifaceted solution which includes a client-facing dashboard that facilitates tracking of certification status and results. Additionally, they automated the survey scoring process, streamlining operations and improving overall service quality for GEN.
Project Logo

DEI Goal Calculator: A Custom Analytics Tool for DEI Professionals

DEI professionals face challenges in goal-setting due to organizational barriers, limited data, and technical resources, often leading to inadequate leadership buy-in and resulting in failed DEI initiatives. In collaboration with people analytics firm Included.ai, we leveraged industry best practices to iteratively complete discovery, design, and development phases of an application to enable DEI professionals in planning, evaluating, and strategizing organizational DEI goals. The DEI Goal Calculator is a specialized and custom built analytics tool which presents an intuitive user-experience and low technical or data requirements. 
Project Logo

dewy: an innovative approach to accessing tailored skincare ingredients

In today's digital age, the internet and social media have transformed into essential tools for skincare beginners. Yet, alongside this accessibility, the prevalence of misinformation within the skincare industry has surged. Dewy tackles this challenge by offering immediate access to personalized skincare insights. Leveraging computer vision technology, our website swiftly analyzes images or skin segments and provides tailored recommendations for addressing specific skin concerns. Our results not only identify potential skin concerns but also offer an ingredient-focused approach, empowering users with knowledge to make informed decisions about skincare purchases.
Project Logo

EarthLab Network Snapshot

EarthLab wants to capture where and how they and their member organizations have been engaged in transdisciplinary research, community engagement and capacity building. Our team participated in its development of a network snapshot utilizing a variety of geographic, program and other related data. The result is an non-western and community-informed data visualization. We make a difference by honoring tribal and indigenous sovereignty, data accessibility and the notion that data is more than information but represents real people, experiences and places. This project facilitates EarthLab strategic priority to activate, leverage and sustain a web of cross-boundary networks, relationships and resources.