Homelessness Data Model

Project Overview:

Reporting on homeless investments often takes weeks to manually update spreadsheets, reconcile, and validate before analysis even begins. The University of Washington Information School Capstone Course is working with Seattle Human Services Department, Amazon and Tableau to create a data model solution that will automate a manual process and create a connection between input data and business visualizations.

Project Background:

The current data used by a division of the Human Services Department called the Homelessness Strategies & Investments ("HSI") is managed in several files that are manually updated by one person. This project will improve reporting on homeless investments, budgets, outcomes, and program model information with automated reporting. The outcome will be a functioning data solution that holds multiple complex data models for analysis. This would include a user interface for staff to update real time changes as they happen, the ability to connect any of the modeled data to an outside source, and a business intelligence functionality for data visualization and analysis.

Project Team:

  • University of Washington Information School Capstone Program
  • Amazon
  • Tableau
  • Human Services Department

Contact: Owen Kajfasz, owen.kajfasz@seattle.gov

Mayor Bruce Harrell

Address: 600 4th Ave, Seattle, WA, 7th Floor, Seattle, WA, 98104
Mailing Address: P.O. Box 94749, Seattle, WA, 98124-4749
Phone: (206) 684-4000

Newsletter Updates


Sign up for the latest updates from Mayor Bruce Harrell

Seattle's Mayor is the head of the Executive department. The Mayor directs and controls all City offices and departments except where that authority is granted to another office by the City Charter.