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.