2019 Household Survey

Purpose: To automate the data cleaning process, minimize the data quality human errors and save staff time.

code source:

https://github.com/psrc/travel-studies/tree/master/survey_data_cleaning https://github.com/psrc/data-science/tree/master/HHSurvey

Rulesy: A SQL script queries trip logics. The input for the script would be raw online survey data. The output from the script would be cleaned survey trips and error flagged trips. The error flagged trip table will directly feed to toolsie.

Toolsie: A visualization platform developed by Tableau. The input for the dashboard would be error flagged trip table from Rulesy, along with the person and household information. Toolsie dashboard helps the team visualize trip strings on the interactive map, as well as providing trip, person, household information in a more efficient and pleasant vision than excel tables.