The end of the spring semester always brings presentations of final projects, some of which may have been in the works since the fall or even the summer. Tableau, a software application designed specially for visualization, is a great option for projects that would benefit from interactive charts and maps.
Visualizing survey data, however, can be a bit of a pain. If your project uses Qualtrics, for example, you may be having trouble getting the data ready for visualization and analysis. Qualtrics is an extremely powerful survey tool, but the data it creates can be very complicated, and typical data analysis tools aren’t designed to handle that complexity.
Luckily, here at Duke, Tableau users can use Tableau’s Web Data Connector to pull Quatrics data directly into Tableau! It’s so easy, you may never analyze your Qualtrics data another way again.
Process
Here are the basics. There are also instructions from Qualtrics.
In Qualtrics: Copy your survey URL
- Go to your Duke Qualtrics account
- Click on the survey of interest
- Click on the Data & Analysis tab at the top
- Click on the Export & Import button
- Select Export Data
- Click on Tableau
- Copy the URL
In Tableau (Public or Desktop): Paste your survey URL
- Under Connect, click on Web Data Connector (may be under “More…” for Tableau Public or “To a server… More…” for Tableau Desktop)
- Paste the survey URL into the web data connector URL box and hit enter/return
- When a login screen appears, click the tiny “Api Token Login” link, which should be below the green Log in button
In Qualtrics: Create and copy your API token
- Go to your Duke Qualtrics account
- Click on your account icon in the upper-right corner
- Select Account Settings…
- On the Account Settings page, click on the Qualtrics IDs tab
- Under API, check for a token. If you don’t have one yet, click on Generate Token
- Copy your token
In Tableau (Public or Desktop): Paste your API token
- Paste in your API token and click the Login button
- Select the data fields you would like to import
Note: there is an option to “transpose” some of the fields on import. This is useful for many of the types of visualizations you might want to create from survey data. Typically, you want to transpose fields that represent the questions asked in the survey, but you may not want to transpose demographics data or identifiers. See also the Qualtrics tips on transposing data.
Resources
For more tips on how to use Tableau with Qualtrics data, check out the resources below:
This was so helpful!!! I couldn’t figure out why the web connector wasn’t working and even talked to OIT who couldn’t help me. Thank you!
Hello, I don’t see “Tableau” option in the Data Analytics. Does that option come up with any access privileges? Please tell me
If you are in the “Export Data” dialog box and you don’t see Tableau, that might be something to do with your Qualtrics account itself. According to the Qualtrics documentation (https://www.qualtrics.com/support/integrations/tableau-integration/), your license needs to have the “Tableau Integration” and “Access API” permissions enabled. If you’re at Duke this should already be enabled, but if you have a different Qualtrics account, you’ll have to check with your license administrator to see if you have access to this feature.