![]() Note: Tableau Prep version 2019.1.2 had changed its name to Tableau Prep Builder and refers to the Desktop application. Use Tableau Prep Builder to combine, shape, and clean your data for analysis in Tableau. In the next post, we’ll demonstrate how you connect to one or more data sources, and we’ll review the different ways you can join and union those data sources.Tableau Prep Builder is a tool in the Tableau product suite designed to make preparing your data easy and intuitive. The interface behaves in a way that makes learning Prep Builder easy for any experienced Tableau Desktop user. I appreciate Tableau’s design consistency between Desktop and Prep Builder. Hovering your mouse over existing flows causes summary information about the flow to display. Connections are accessed using the plus sign ( +) on the left, available workflows are displayed in the center, and the Discover pane on the right supplies the same type of training videos and resources that you’ve become familiar with using Tableau Desktop. The Builder Start page is very similar to the Start Page in Tableau Desktop. In addition, I pasted some summary information from the Start page in Builder: ![]() Tableau Prep also allows you to change the system-assigned names for each step within the flow, which are displayed below each step heading. Notice that I’ve added customized descriptions next to each step in the workflow. I’ve altered some of the colors to my taste and to better reflect common sources (see how the Orders 2015 – Orders 2018 are the same color). Tableau automatically assigns different colors to each step. In typical Tableau fashion, every icon has a specific meaning. The arrow pointing from the Union 1 step to the Settings area displays a flexible screen space that will change depending on what specific step you click on in the workflow. Here’s a Tableau Prep workflow that I created earlier today: It’s very “Tableau-like.” Tableau continues to live their mission of making it fast and easy for you to see and understand your data. ![]() I love the way that Tableau has implemented the transformation features. While I wouldn’t call this an enterprise-class ETL toolset, Tableau brilliance at user interface is evident. I’m excited about the possibilities of Tableau Prep and Conductor. Tableau Prep has now matured to a level where the feature set is equivalent to the Data Interpreter in Tableau Desktop, but it adds the automation and repeatability of a real extract, transform and load tool. Generally, the features added come from a combination of their internal product roadmap and external feedback from the user community. Per usual with Tableau, when a new set of features is good enough, they release something new. Over the past month, I’ve spent a lot of time playing with Prep and publishing workflows to Tableau Server to see exactly what Tableau is offering now. I’ve kept an eye on Tableau Prep ever since its release, but I haven’t bothered to do a deep dive with the tool until this year (though some of consultants have recognized that Tableau Prep is truly a game-changer). If you are already familiar with the Data Interpreter in Tableau Desktop, your learning curve for Tableau Prep will be short. I’ll also discuss the basics of installing and managing workflows using the data management add-on toolset for Tableau Server and will complete this series by providing a comparison of Tableau Prep and Conductor to other ETL tools available in the marketplace. In this blog series, I’ll be covering the Desktop environment of Prep Builder and all of the related data-transformation tools that are currently provided. Tableau Server’s Data Management Add-on released in V2019.1 in February 2019 and enables you to automatically refresh published workflows. Tableau Conductor is the server complement to Builder that provides the framework and tools for publishing Builder workflows and datasets to Tableau Server. Over the past year, Tableau has expanded the Builder feature set substantially. Tableau Prep Builder’s first live release came in April 2018 in Desktop 2018.1, and since then, we’ve had four major releases and eight minor updates. Tableau Prep Builder and Conductor are Tableau’s tools for enabling repeatable, documented and scheduled workflows to transform raw data into user-friendly datasets. In this series, Tableau Zen Master Dan Murray takes a closer look at the Tableau Prep Builder and Conductor tools, their power and scope and how they stack up against other ETL tools.
0 Comments
Leave a Reply. |