Upgrade to Tableau Prep Builder 2020.1.4

What you need to know when upgrading to Tableau Prep Builder 2020.1.4

Overview

Introduction to Tableau Prep Builder

Tableau Prep Builder is a Tableau product designed to help everyone quickly and confidently combine, shape, and clean their data for analysis.

How to Get Tableau Prep Builder

Tableau Prep Builder is included alongside Tableau Desktop in the Tableau Creator offering. Existing Tableau Desktop customers with maintenance can also get Tableau Prep Builder as part of their maintenance benefits.

Start using Tableau Prep Builder:

What's New in Tableau Prep Builder 2020.1.4

Start by reading this blog post by
Kate Grinevskaja, Product Manager at Tableau

New in Tableau Prep: Persistent server login, easier cleanup for date fields, and new connector support.

Note: Starting in version 2019.1.2, Tableau Prep is now called Tableau Prep Builder. This name change is to distinguish it from the new Tableau Prep Conductor which runs on Tableau Server as an add-on. With the launch of Conductor, the work you do in Prep Builder running on your Tableau Desktop, can be saved to run in a centralized, scalable, and reliable server environment so your data is always up to date and easy to share.




Connect to Data

Connect to data with Cloudera Impala


Just like Tableau Desktop, you can now easily connect to your larger data sets using Cloudera Impala.

For more information about connecting to your data source using Cloudera Impala, see Cloudera Hadoop in the Tableau Desktop help.


Clean and Shape Data

Convert date values in a single click


To help make cleaning your data even easier, Tableau Prep Builder has added another quick cleaning menu option for dates. If you need to convert your date values to show a DATEPART like year, month or day, you can select one of the following menu options from the new Convert Dates menu instead of writing a complex field calculation.

For more information about applying cleaning operations to your dates, see Apply cleaning operations, see Apply cleaning operations.


Save and Share your Work

Stay connected to your server


You no longer need to sign into Tableau Server or Tableau Online every time you open Tableau Prep Builder. Now, Tableau Prep Builder remembers your server name and login information when you close the application so that the next time you open the application you are already logged into your server.

This time saving option will help you seamlessly connect to publish data sources or insert saved flow steps and if you need to know if a certain feature is compatible with your server version, compatibility warnings will show instantly without you having to sign into your server first.

For more information, see Create and publish data extracts and data sources.


Added in Previous Versions of Tableau Prep Builder

You may be interested in knowing what features were added to Prep Builder in previous months' releases. Below is information in summary form with links to Product Help.

Features Added in Tableau Prep Builder 2020.1.3



Install and Deploy Tableau Prep Builder

Support for login-based license management (LBLM)

Login-based license management, helps you manage licensing for users with Creator roles on Tableau Server and Tableau Online. Users with Explorer or Viewer roles cannot use this feature. If you’re using Role Based Subscriptions with Tableau Server or Tableau Online, you can simplify your license management using login-based license management to eliminate separate Tableau Desktop and Tableau Prep Builder product keys. You only need to manage one or more product keys for on-premises Tableau Server, or in the case of Tableau Online, you don’t need to manage any product keys at all.

For more information, see Login-based License Management.

Connect to Data

Pass parameters to your data source using Initial SQL

Now you can pass parameters to your data source using Initial SQL to provide more details about your Tableau Prep application, version and flow name. Tableau Prep Builder supports the following parameters:
TableauApp - Returns the application being used to access your data source - Prep Builder or Prep Conductor.
TableauVersion - Returns the application version number. For Tableau Prep Builder it will return the exact version number, for example 2020.1.1. For Tableau Prep Conductor, it will return the major server version where Tableau Prep Conductor is enabled, for example 2020.1.
FlowName - Returns the name of the .tfl file.

For more information about using parameters when connecting to your data source using Initial SQL, see Include parameters in your Initial SQL statement (version 2020.1.3 and later)

Clean and Shape Data

Use Level of Detail (LOD), Rank and Row Number calculations to clean your data

If your data is aggregated at a different level than what you need to analyze it or if you need to perform calculations across a set of rows you can now use FIXED Level of Detail (LOD) and RANK and ROW_NUMBER analytic function calculations to create the data that you need in your data set.
For example, add a FIXED LOD calculation to change the granularity of fields in your table. Use the new ROW_NUMBER () analytic function to quickly find duplicate rows, or use one of the new RANK () functions to find the top N or bottom N values for a selection of rows with similar data.

If you want a more guided experience when building these types of expressions, you can use the new visual calculation editor.

For more information about using these calculated fields to clean your data, see Create level of detail and rank calculations.


Features Added in Tableau Prep Builder 2020.1.2


New in Tableau Prep Builder 2020.1.2: Third party library updates: OpenSSL, postgresql, postgres jdbc.


Features Added in Tableau Prep Builder 2020.1.1

Connect to Data

Map Flow inputs back to their original connection

If you used multiple inputs to build your flows, it is not always obvious how to find the individual tables or data sources you used for the different inputs, when you later need to make updates or swap out a connection. To make finding your flow inputs and tables easier, we have added a new feature that highlights the connector and table for a selected input in the Connections pane. Simply select one or more Input steps in the Flow pane and the related connector and tables are highlighted in the Connections pane.

For more information about how to connect to your data to build a flow see Connect to Data.

Clean and Shape Data

Pause data updates to boost performance

Every time you apply cleaning operations to your data, Tableau Prep Builder refreshes your view so you can instantly see the results of your changes. While building new flows, this constant feedback helps you quickly identify which steps to take next, but sometimes applying these changes can take time. To boost performance and make applying changes to your data faster, you can now pause these constant data updates and apply your changes in bulk.

Simply select the Pause data updates button on the top menu and Tableau Prep Builder pauses your data updates and switches the Profile pane view into List view so you can quickly apply your changes. Instead of refreshing your view with every change, only the field metadata is shown. When you finish your changes and want to see the results on your field values, click the Resume data updates button to switch back to the standard data update mode.

For more information about pausing data updates to apply cleaning operations in bulk, see Pause data updates to boost performance.

Keep Flow Data Fresh

Add or embed credentials for cloud connectors when publishing your flow

In previous versions, if you wanted to publish and schedule a flow that included cloud connectors, you would need to configure your credentials in Tableau Server or Tableau Online ahead of time. Otherwise, Tableau Prep Conductor could not detect your credentials and the flow would fail to run. Now you can add and embed your credentials for your cloud connectors directly from the Publish dialog in Tableau Prep Builder in a few simple steps.

Simply sign into your server and select Server > Publish Flow. In the Publish Flow dialog, a new warning text shows, telling you that you have input connections that require authentication. Click the Edit connections link in the message or the Edit link in the Connections section, then in the Authentication drop-down, select Add credentials.

A secondary message confirms your selection. Click Continueto go to your Account Settings page in Tableau Server or Tableau Online, and add your credentials. When you are finished, return to Tableau Prep Builder, click Done and your new credentials are automatically embedded in your flow.

For more information about adding credentials for cloud connectors during publish, see Publish a flow.

Version Compatibility with Tableau Prep

Detect and enable incompatible features

In Tableau Prep Builder version 2019.3.1, we added warning icons and tooltips so that you could more easily see which features were incompatible with your version of Tableau Server as you built your flow to help you make informed decisions about which features you included in your flow if you planned to publish the flow and run it on a schedule.

In this release we have added even more transparency when working with new features that might not be compatible with your server version. Now, after you sign into your server, Tableau Prep Builder can detect which features are not compatible with your version of Tableau Server, and disable those features. This takes the guess work out of which features you can include if you plan to publish your flow and run it on a schedule.

If you still want to use the feature and run your flows manually using Tableau Prep Builder or from the command line, you can enable the feature right from the menu. Just click the Use Features button, and that feature along with all incompatible features will be enabled. The warning options introduced in Tableau Prep Builder version 2019.3.1 will still identify which features are incompatible with your server so that you can easily find and remove them if you want to run the flow using a schedule in Tableau Server.

For more information about working with incompatible features, see Version Compatibility with Tableau Prep.


Features Added in Tableau Prep Builder 2019.4.2

Connect to Data

Connect to more data with new connectors


In this release we have added the following new data connectors:

  • Alibaba AnalyticDB for MySQL
  • Alibaba Data Lake Analytics
  • Databricks
  • Kyvos
  • Qubole Presto

For more information about how to connect to your data using these connectors, see Supported Connectors in the Tableau Desktop and Web Authoring Help. For general information about connecting to data to build a flow see Connect to Data.


Clean and Shape Data

Pivoting columns to rows just got easier


When you need to pivot your data from columns to rows, you can now manually select fields in the profile pane to pivot them or Tableau Prep Builder can recommend the fields to pivot and create the pivot for you. Both options automatically generate your pivot step so you can quickly perform any additional pivot actions like renaming the pivoted fields or pivoting on additional fields.
To manually pivot columns to rows from the Profile pane, simply select the fields you want to pivot, then right-click or Ctrl-click (MacOS) and select Pivot Columns to Rows from the menu to create the new pivot step and pivot your fields.

If Tableau Prep Builder detects fields that can be pivoted, a recommendation option will show in the Profile pane toolbar. Click the
icon light bulb Small lightbulb in the toolbar and select the pivot recommendation. The recommendation shows which fields it will pivot. Simply click Apply to generate the Pivot step and pivot your fields.

For more information about pivoting your data, see Pivot Your Data. For more information about how to use recommendations to clean your data, see Apply cleaning operations using recommendations (version 2018.3.2 and later).


Additional Enhancements

See feedback for long-running operations


To give you more visibility when processing large data sets or flows, we've added a progress indicator at the top of the Flow pane to give you status updates as Tableau Prep Builder processes your data. Now you can have more visibility into what Tableau Prep Builder is doing behind the scenes so you no longer have to wonder whether your data is still being processed or if a problem has occurred.


Features Added in Tableau Prep Builder 2019.4.1

Connect to more data in the cloud

In this release we've added the following cloud connectors:

  • Box
  • DropBox
  • Google Drive
  • OneDrive

Additional configuration may be needed to save your credentials for these connectors if you plan to publish your flows to Tableau Server or Tableau Online. For more information about connecting to cloud data connectors, see Connect to cloud data sources.

Additional Enhancements

Share usage data with Tableau

Tableau collects data that helps us learn how our products are being used so we can improve existing features and develop new ones. All usage data is collected and handled according to the Tableau Privacy Policy. But you can opt out if you do not want to participate.

The opt out option has changed. Usage data collection is enabled by default. If you don't want to participate, select the Don't send product usage data check box from the installer or Customize installer (MacOS) dialog or from the Help menu after installation.

For more information, see Turn off usage reporting in the Tableau Desktop and Tableau Prep Deployment Guide.

Default database drivers no longer automatically installed for MacOS

When installing Tableau Prep Builder on Mac, we only install the PostgreSQL database driver automatically. If you need other drivers to connect to your data, you can install them from the Driver Download page.

Features Added in Tableau Prep Builder 2019.3.2

Performance Improvements

Interactive performance improvements

Good news for users who may have experienced performance issues in their data Prep Builder workflows. We have made improvements with this release:

  • App Startup – The application starting up to 15% faster than in the 3.1 release.
  • Excel and Text Files Load – Loading Excel and text files up to 50% faster than in the 3.1 release.
  • Wildcard Union – Customers using wildcard union should experience performance gains of up to 50% faster for text files and up to 700% faster for Excel files.
  • Node Materialization – Updates to cache union steps in a flow will allow customers to see up to a 95% improvement in performance depending on how many union steps they have in their flow and where they click on the flow.
Conductor Compatibility

The interactive performance improvements are compatible with Conductor and should not affect batch mode in any way.

Build and Organize your Flow

Updated insert steps

Inserting steps in a flow used to be a multi-step process, but with these updates, you will be able to insert any step (except inputs and outputs) without going through the multi-step process. This capability will be available for copy & paste steps and reusable flow components. Open any flow and navigate to a branch. When you hover over the branch, notice that there is a new ‘+’ menu. Click on the icon and select the step you would like to insert.

For more information, see Add or Insert Steps.

Conductor Compatibility

This feature is fully compatible with Conductor. It does not impact how flows are run.

Reusable steps

Many users find themselves applying the same set of cleaning operations to prepare data, they want to be able to reuse some of their work within the same flow for different data and across multiple flows. This new feature helps users easily reuse Steps from a flow to help save time and, whenever possible, leverage the work of others. A user can now select a group of connected steps and save them to a file to reuse in other flows or publish them to Tableau server to reuse later or have others leverage their work.

For more information, see Create reusable flow steps (version 2019.3.2 and later).

Conductor Compatibility

Flow snippets are simply .tfl files that can be published on Tableau Server. They can be scheduled if there is an input and output step.

Examine and Filter Your Data

Fuzzy match custom data roles

With Prep Builder 2019.2.2 users were able to fix invalid values of built-in data roles by replacing them with the closest valid value, a fuzzy match. And, with Prep Builder 2019.3.1 came the ability to create custom data roles. With this release users will be able to automatically fix invalid values by matching and replacing them with the closest valid ones. Now users can leverage custom data roles and automatically fix invalid values!

Select any data set and categorical field and publish as a custom data role. Then apply that data role to data with inaccurate values. The recommendations offer the choice to replace invalid values with the closest one for the data role (it uses the Pronunciation and Spelling algorithm) and you can simply apply it to fix your data quality issues.

For more information about fuzzy match, see Group similar values by data role.

Conductor Compatibility

Fuzzy grouping algorithms do not run in batch mode – when the flow is authored and a user selects a grouping algorithm, the exact groupings are stored in the Changes list and those in turn are run in batch mode making this feature Conductor compatible.

Navigation and Displays

Flow navigation

If you are building large flows in Prep Builder, it can often be a difficult to navigate these flows. With flow navigation customers get a minimized version of their flow that they can use to navigate. From this tool, yo can also zoom in and out of the flow.

  • Open a large flow.
  • The mini map is located in the bottom right hand corner.
  • Use the picker to navigate around the flow.
  • Use the rest the button on the mini map as follows:
  1. The down arrow allows you to minimize the mini map.
  2. The ‘square’ button zooms the flow out enough to fit the whole flow onto your screen.
  3. The ‘+’/ ‘-’ buttons will allow you to zoom into and out of your flow.
  4. Click on the % indication which will automatically zoom the flow back to 100%.

For more information, see Use the flow navigation tool.

Conductor Compatibility

Fully compatible.

List view

Customers love the view in the input step, because they can easily see all their fields and take quick actions like renaming or removing fields and wanted a similar experience for all steps. Sometimes they were frustrated by the fact that they often see no more than 4 or 5 fields in the view and must scroll to see the rest. The new list view allows customers to have a different view of their data focused specifically on their metadata. From this view users will be able to easily remove and rename steps as well as be able to change data types and add calculations.

  • Open any flow.
  • Navigate to any step.
  • From the toolbar above the profile pane select the list view icon:
  1. Hover over any field and hit the ‘X’ button to remove the field.
  2. From the ‘...’ menu you will see all the cleaning options that are available in the profile pane. All operations that impact your values (filtering, for example) will transition you automatically to the profile pane. Actions only impact your metadata (like renaming a field, for example).

For more information, see Select your view.

Conductor Compatibility

Fully compatible as it has no impact on how outputs are run.

Command Line Interface (CLI) Improvements

MacOS keychain credentials no longer needed for each flow run

Many customers are using the command line interface to automate running Tableau Prep flows on their machines. Our latest improvements in this area will eliminate the need for a user to manually enter their MacOS keychain credentials every time the flow runs. Just run any flow using the command line interface that is installed with Tableau Prep Builder.

Conductor Compatibility

N/A


Compatibility

Tableau Prep Builder is a stand-alone product that works seamlessly with Tableau Desktop, Tableau Server and Tableau Online. At any point while working in Tableau Prep Builder, you can create an extract of your data, publish your data source to Tableau Server or Tableau Online, or even open Tableau Desktop directly from Tableau Prep Builder to preview your data.

  • Tableau Prep Builder works on Windows and Mac. It can create Tableau Extracts (.tde and .hyper) and CSV files that can be used in Tableau 10.0 and later versions of Tableau.
  • In Tableau Prep Builder you can connect to many of the same data sources available in Tableau Desktop, Server and Online. For a complete list of Tableau supported data source, click here.
  • With some data sources, you may need to install drivers before connecting to your data. If this is the case, see the Driver Download page.

New Workspace for Faster Speed to Insight

Tableau Prep Builder uses Tableau’s data connectors, calculation language, and governance structure, making it possible to get you up to speed quickly and ready to collaborate at any point in the analytical process.

The Tableau Prep Builder workspace consists of the connections pane, the changes pane, and three coordinated areas designed to help you interact with and explore your data:

  1. Connections pane: The Connections pane shows the databases and files you are connected to. Add connections to one or more databases and then drag the tables you want to work with into the flow pane. 
  2. Flow pane: As you connect to, clean, shape, and combine your data, steps appear in the flow pane. You can hover over the icons at the top of each step to see what changes were made. 
  3. Profile pane: The profile pane in the center of the workspace shows a summary of each field in your data sample. This is where users can see the shape of the data and quickly find outliers and nulls.
  4. Changes pane: Tableau Prep Builder keeps track of any changes you make, in the order you make them, so you can always go back and review or edit those changes if needed.
  5. Data grid: The data grid shows the row level detail for your data. The values displayed reflect the operations defined in the profile pane. You can filter, keep only, and exclude individual field values in this grid plus drag and drop fields to change the display order.

For complete descriptions, including a video, see Workspace in Product Help.

Saving and Sharing Outputs

Defining Output

Tableau Prep Builder can save three types of files:

  1. .tfl files containing a flow
  2. .tflx files containing a flow and local file-based data sources, such as Excel and text files
  3. Output files containing the results of running a flow

Output files can be saved in .hyper, .tde and .csv formats, and are defined in the Output Step. The output files can be opened in Tableau Desktop, and published to Tableau Server or Tableau Online.

Tableau Desktop

Running the flow on Tableau Desktop results in a Tableau Data Extract file, either a .tde or .hyper depending your version of Tableau, either one saved in your Tableau Repository in the Datasources folder. It can also be output to .csv files, if you need to use your prepared data for other tools or processes.

Note! Once an extract has been created, whether .tde or .hyper, and a workbook based on it, the same compatibility rules for use with different versions of Tableau applies as in other usage situations. For more information, see Make Workbooks Compatible Between Versions.

Tableau Server

To publish your output to Tableau Server, use the Publish menu in Tableau Prep Builder. The Tableau Server REST API must be enabled in order to receive publish requests from Tableau Prep Builder. For more information see REST API Requirements.

Tableau Online

You can also use Tableau Prep Builder's Publish menu to publish your output to Tableau Online as a .hyper extract, .tde extract, or .csv file, and provide centralized access to the data you have cleaned, formatted, and combined.

Faster Updates to Tableau Prep Builder

We’re moving fast and will be launching new features frequently for Tableau Prep Builder, independent of the Tableau Desktop, Tableau Server or Tableau Online release cycles. Customers will need to upgrade to the latest version of Tableau Prep Builder to take advantage of new features and product fixes.

With regular intervals, this site will post new links to community user scenarios, product information, and not least tricks of the trade for the latest fast, fun and efficient data prep.

Additional Resources

How can I get Tableau Prep Builder?

Tableau Prep Builder is a subscription only product included in the Tableau Creator offering. Existing Tableau Desktop users with maintenance will be able to download and use Tableau Prep Builder as part of their maintenance agreement. If you haven't downloaded Tableau Prep Builder already, you may do so by visiting this page or simply clicking the download button at the top of this upgrade page, which always points to the latest version of Prep Builder.

Unsure of your license situation? Start by reading Maintain Licenses for Tableau Desktop and Tableau Prep Builder.

Try Tableau Prep Builder first for free!

You can download a free 14-day trial of Tableau Prep Builder here.

Review Tech Specs

Technical requirements for Tableau Prep Builder can be viewed here.

Tableau Prep Builder Release Notes

Get Help

Self-Service Resources


Technical Support
To get the best results out of your encounter with Support, please provide the following:
  • Screenshots of the issue and any error messages (expanded)
  • Best times to call


Professional Services

Our consultants can teach you how to get the most out of the new Tableau Prep Builder feature and unlock the value in your data.