From here, we can add steps to our flow to further clean and prepare our data to make the analysis as simple as possible once we export it to Tableau.

I'll start by grouping common response types (e.g. Likert scale, yes/no, etc.). In this example, the question key from the original data already helps me do this since parts of a question share the same question number.

Using the Group by Pronunciation feature in Tableau Prep, we can correct open-text responses where respondents made spelling mistakes and group answers that were provided in slightly different formats, such as mixed cases or trailing spaces.

Attachments

  • Original document
  • Permalink

Disclaimer

Tableau Software Inc. published this content on 20 June 2018 and is solely responsible for the information contained herein. Distributed by Public, unedited and unaltered, on 20 June 2018 17:17:01 UTC