Getting Your Data Ready with Tableau Prep
Updated: Sep 4, 2020
Tableau prep comprises of two products; Tableau builder and Tableau conductor. Tableau prep builder helps you quickly combine, shape and clean data for analysis (building flows) while Tableau prep conductor helps you schedule, monitor and manage flow across your organization.
With Tableau prep, data preparation becomes much simpler and visual. Meaning you can easily track and evaluate the impact of the actions undertaken while preparing data. While being able to reuse the same flows for future data prep tasks.
This brief article explores some of data prep tasks you can perform in Tableau prep.
Out of the box data prep tasks you can perform in Tableau prep
Data joining is the method of combining tables related by a common field. This example shows how to combine two tables (A & B ) using the common field ‘Id’.
Data union is simply appending values (rows) to tables. And results to a virtue table with same columns but extends vertically due to the added data. To union data, subject tables MUST be of the same structure (same columns).
This example demonstrates how you can union data in Tableau prep.
Pivoting data is the process of transposing data from a cross-tab format into a columnar format for quick analysis.
Split fields into multiple fields
Sometimes data can contain multiple information in the same column. To perform analysis based on one of the single item of the multiple information, you can split such fields using the right separator.
This example shows how to split the field ‘Customer Name’ into ‘First name’ and ‘Last name’ respectively for a case where your analysis is based on customer’s first name only.
Change data types
All fields in a data source have a data type. Data type reflects the kind of information stored in that field. And each data type is represented by a unique icon. In Tableau prep, you can change the data type as shown below.
After connecting to data, if Tableau prep detects sub-tables in your data, you’ll be presented with the option to turn on data interpreter. The data interpreter will draw out sub-tables and exclude any extraneous information.
This example shows how to use data interpreter in Tableau prep.
Grouping is helpful when you need to combine related data in a field. It can also be used for data correction (e.g. Combining Africa, Afrika & Afric into one data point).
In this example, grouping is used to combine ‘Africa’, ‘Afrika’ and ‘afric’ into a single data point named ‘Africa’.
Clean data (trimming spaces, removing punctuations, numbers & letters)
Simple data cleaning tasks such as trimming spaces and removing punctuations and numbers can be executed as shown below;
Renaming fields in Tableau prep.
Data is analyzed at many different levels of granularity. Sometimes, your data prep tasks demand that you aggregate data before combining it with another data at a certain level.
This example shows how to aggregate data by SUM(Sales) at State level.
These are some of tasks you can perform in Tableau prep. More features such as filtering data, creating calculated fields, running scripts and various options for exporting data (Tableau data extract or CSV) are available for you.
If this was helpful to you and you would like to receive more of these Tableau prep tips and tricks. Kindly subscribe to our emailing list.
Thank you for reading.