Using the Data Interpreter in Tableau 9.2 to Recognize Sub Tables

Data

Using the Data Interpreter in Tableau 9.2 to Recognize Sub Tables

by Robert Rouse
//

I recently found a data set that was perfect for testing out the new Data Interpreter in Tableau 9.2. While discussions about Syrian refugees were ramping up, I sought out data about the situation, which led me to the UNHCR page dedicated to this crisis. Using the Excel download option at the top results in a file with five different sections on one spreadsheet. This post discusses how to use the new sub table detection feature in Tableau 9.2 to automatically recognize this structure and minimize manual data manipulation. For an overview of some other great new features found in Tableau 9.2, be sure to check out this article from my colleague, Katie Fontenot.

Let’s jump into our example.

Incoming Data Structure

The downloaded sheet has five sections:

  1. Overall Summary
  2. Refugees over time
  3. Demography
  4. Funding Requirements
  5. Who’s Doing What Where?

These sections are highlighted in the screenshots below. As we can see, this is not a data structure that Tableau could automatically recognize in prior versions. Now, the Data Interpreter can automatically recognize each sub table:

Tableau 9.2: Data Interpreter - Sub TableTableau 9.2: Data Interpreter - Sub Table

Using the Data Interpreter

When connecting to an Excel file, Tableau initially shows the sheets in the workbook but does not immediately show sub tables in those sheets. Follow these steps to make them show in the Data window:

  1. Drag the sheet with sub tables into the top pane
  2. Turn on the Data Interpreter
  3. Any sub tables will appear and can be used like normal data tables

Tableau 9.2: Data Interpreter in action

It is a good idea to verify that Tableau correctly interpreted the structure. One way is to preview each one using the data grid to quickly check the fields it found. Another more detailed way, is to use the Review Results button, especially when Tableau warns that it removed some data. This option exports and Excel file that color-codes how the Data Interpreter handled each part.

Tableau 9.2: Data Interpreter - Review results

In the bottom section, I found it useful to pivot the fields to visually analyze the ways different organizations are helping. I was glad to see that Tableau allows users to pivot fields in the sub tables the same as other kinds of data tables.

No Need to Cut and Paste

That’s all there is to it. Before, we would have had to cut and paste each sub table into different sheets. Now, Tableau does the work for us. It does the work of splitting up parts of the spreadsheet so we don’t have to. While I have demonstrated this with refugee data, this structure exists everywhere people use Excel to organize data. If you haven’t already upgraded to Tableau 9.2, download it now to take advantage of this new time saving feature. 

More About the Author

Robert Rouse

Analytics Consultant
Eine neue Art KPIs in Tableau zu visualisieren Key Performance Indicators sind eines der Dinge, die Leute am häufigsten in Tableau darstellen möchten. Das bezieht für gewöhnlich ein, ...
Disney Data & Analytics Conference 2019 in Review At Disney World, every park has a theme. What you may not know is that their annual data and analytics conference has a theme, too. In ...

See more from this author →

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072

×

Love our blog? You should see our emails. Sign up for our newsletter!