Trifacta wins the Best Data-Driven SaaS Product award at the 2021 Annual Cloud & SaaS Awards

Start Free

Speed up your data preparation with Trifacta

Free Sign Up
Summer of SQL

A Q&A Series with Joe Hellerstein

See why SQL is Back
All Templates

Prepare and Analyze Responses from a Survey Using Survey Data Analysis

Analyzing Survey Forms Flow The flow view of this template

Get insights from survey responses in CSV, Excel, or Google Sheets

array parsing (flatten, unnest), extractlist, unpivot, replacepatterns

This template flow shows you how to prepare and analyze survey data collected from a survey form. The survey form contains many different types of questions – such as single response, multiple choice checkbox and other combinations.

This template comes with an example survey (that’s built using Google Forms) where responses are collected in a CSV, but you can replace it with your own survey and response results collected in either CSV, Excel or Google spreadsheet (if using Google Cloud Dataprep).

The flow starts by doing some basic cleaning and renaming of survey question attributes in the Clean Headers recipe. It then forks into 4 separate recipes where each recipe processes one specific type of survey question. The recipes make extensive use of extractlist transform to collect responses into an array, and then various array parsing functions such as flatten to convert them into individual response rows. You can use this technique to work with many types of survey question responses.

Each of the recipes is annotated with detailed instructions, so feel free to step through them one at a time and customize it to your specific survey.

Fore more information, please check out this blog and detailed technical guide.

On Google Cloud Dataprep, this flow template is also available as part of a broader Smart analytics reference pattern.


New user?

Use the buttons above and start your 30-day free trial. If your data is mostly on Google Cloud Platform, please use Dataprep. Otherwise, choose Trifacta.

Learn more about Dataprep