Data Engineering Template:

Prepare and Analyze Responses from a Survey Using Survey Data Analysis

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

Analyzing Survey Forms Flow The flow view of this template

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?

If your data is mostly on Google Cloud Platform, please use Dataprep. Otherwise, choose Designer Cloud.

Use in Designer Cloud Use in Dataprep