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

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
Advance with Assist: Parameter Performance Optimization Question: “I added a calculation that uses a parameter input and my dashboard is a lot slower now. How can I make it ...
A Problem-Free Philosophy of Analytics Hakuna MaDATA, what a wonderful phrase! It adorned the t-shirts of one of our best partners, Snowflake, at the 2018 Disney Data and ...

See more from this author →

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

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