iSchool Capstone

IAC Homelessness Data Model

Project tags:

business & systems analysis

database administration & development

ux & interaction design

Best in Class
Project poster

The City of Seattle Human Services Department (HSD) contracts with community organizations to provide housing & health services to people experiencing homelessness. Previously, HSD staff pieced together program & contract data from many sources. This is a time-consuming and frustrating process, but this information is critical for informing policy and highly visible through media outreach. To meet their needs, we produced a data warehouse and reporting system that captures institutional knowledge, automates data ingest, and makes data analysis more streamlined and trustworthy. We hope to help HSD tell a more complete story about Seattle’s service to its most vulnerable populations.

Project participants:

Amir Ali


Tiffany Ku


Kevin McCraney