The following tutorial will walk you through taking the SPSS (.sav) files currently being used and converting them into a format where analysis and visualization can be preformed within Tableau through the use of Tableau Prep.

You will need the following programs: PSPP, Tableau Prep, and Tableau Desktop. Instructions to download are included in the wiki page "Software Installation Guides." The tutorial is broken down by the program used.

Step-by-step guide

PSPP

The following will be done for each dataset (.sav file):

1. Convert .sav to .csv

 SAVE TRANSLATE
        /OUTFILE="[file location]\[file_name].csv"  
        /TYPE=CSV
        /FIELDNAMES
        /CELLS=LABELS.

Tableau Prep

Steps 1-3 will be done for each dataset (.csv file):

1. Connect to datasets

2. Extract data into Tableau Prep

3. Cleaning the Datasets

4. Joining the Datasets

Step 4 will be done every time you wish to join a dataset to another, or when you want to join additional datasets to an existing join. You will join all datasets that you wish to analyze together. It is recommended you only join the data you will be reviewing.

An explanation of Joins can be found in the wiki page "Joins Explained."

4. Outputting and Viewing Flow

 

 

You may also want to use visual panels to communicate related information, tips or things users need to be aware of.

Related articles

Related articles appear here based on the labels you select. Click to edit the macro and add or change labels.

Related issues