Using the Data Interpreter to Clean Data - Tableau in Two Minutes

The Tableau data interpreter allows you to clean up your data sources before importing them and using them as the source data for your Tableau workbook. If means you can use an Excel workbook as a Tableau data source, even if you're not able to get everything aligned in a "clean" table format.

The data interpreter will detect tables in a sheet or workbook, even if those tables are offset, misalgined, or there are multiple tables on the same Excel sheet.

We cover:
- Connecting to an Excel workbook.
- What the data looks like before we run the data interpreter.
- How Tableau cleans up the data.
- How to use a "cleaned up" table from the data interpreter as a data source.
- How to view the output of the data interpreter as an Excel workbook so you can see what it identified as tables, what it identified as headers and what it identified as data values.

[raginimandla]

Hey There..


Is there a way we could combine those two ranges(A6:DC37 and N73:DP193) if they dont share the common headers.( If they share common header we can combine with Joins). Kindly help!!

[reviewbyanand]

Hello Sir,

Is it possible to perform data cleaning processes similar to what we can do in Python or SQL? For example, changing data types and modifying null values with mean, median, or mode values.

[jraj]

Nice video, just one doubt., what if we have multiple sheets with same issue, how to union with wildcard.!? If i union with wildcard, its picking non cleansed data. Please suggest. Thank you.

[bhavyadeeppatil]

Hello Sir
Suppose we have data for hospitality and if u have to calculate average daily rate regarding sold out room vs unsold room then how can we calculate using tableau

[parul]

Hi, Can you please tell how can we refresh that file which gets created after using data interpreter. My base file updates daily but I am unable to see that updated information in cleaned file.