{"id":2878,"date":"2024-01-25T12:00:00","date_gmt":"2024-01-25T11:00:00","guid":{"rendered":"https:\/\/newdatalabs.com\/en\/?p=2878"},"modified":"2024-01-25T10:00:13","modified_gmt":"2024-01-25T09:00:13","slug":"using-tableau-prep-to-prepare-data-for-visualization-in-tableau","status":"publish","type":"post","link":"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau\/","title":{"rendered":"Using Tableau Prep to Prepare Data for Visualization in Tableau"},"content":{"rendered":"\n

Tableau Prep, from its launch as the component of the Tableau package, has been supporting data transformation and modelling. It can be described as the ETL (Extract Transform Load) programme and has the advantage of being not too complex. It\u2019s not an analytical powerhouse, but a smart tool designed for data modelling. Tableau defines Prep as \u201cself-service data preparation\u201d \u2013 a tool that offers the advanced approach to data modelling. It allows simple and fast combining, transforming and cleaning data for easier analysis in Tableau at a later stage. In addition, it uses a very practical presentation of data flows. Prep is consistent with the Tableau philosophy, which in addition to the visual aspect of presenting the data itself also focuses on the data transformation. In this series, I am going to discuss how to use Prep as the alternative to Excel in terms of basic but time-consuming data cleaning and transformation processes. We will start with the essentials in Prep, including description of the basics of data cleaning, then we will move to transforming and combining the data from various sources, and finally, we will export data for further analysis.<\/p>\n\n\n\n

Connecting data source and first steps<\/h2>\n\n\n\n

The first step in Prep is to connect the data source. Similarly, as in Tableau, there are many options here: through Excel files, PDFs, or text files, servers like SQL, or cloud solutions such as Snowflake or Azure:<\/p>\n\n\n\n

<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

<\/p>\n\n\n\n

Let\u2019s start with connecting a sample Excel file as the source. After selecting the relevant file, you will see the following view. Prep interface consists of:<\/p>\n\n\n\n

1 \u2013 Data connection pane (Connections)<\/p>\n\n\n\n

2 \u2013 Data flow visualization pane (Flows)<\/p>\n\n\n\n

3 \u2013 Details pane of the transformation step \u2013 different for specific options (steps)<\/p>\n\n\n\n

<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

<\/p>\n\n\n\n

Once the data is connected to our data flow, the first step appears: Input. It provides the details of the connection, its settings, data sample (in case of large datasets you work with data snips). You will also find here a list of fields from your source, including the type identified by Prep with a preview of values. There is also a list of changes that can be made in this step \u2013 for example, changing the type of data (from text to a figure) or removing unnecessary fields:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n\n\n\n

<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

<\/p>\n\n\n\n

To start the actual data transformation, add a step with the icon (+), by selecting one of the available options in the Clean Step (other types of steps will be used at a later stage):<\/p>\n\n\n\n

<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

<\/p>\n\n\n\n

Cleaning data \u2013 deriving numbers from text<\/h2>\n\n\n\n

Adding the Clean Step will allow you to view the data and transform it at a later stage. Let\u2019s start with what you can see in the window:<\/p>\n\n\n\n

1 \u2013 A present step displayed in the flow (currently Clean 1 \u2013 you can edit the step name and colour)<\/p>\n\n\n\n

2 \u2013 Changes pane, in which all subsequent data modifications will appear<\/p>\n\n\n\n

3 \u2013 Data summary pane \u2013 depending on the type of data, you will see the values available in your database with mini-charts depicting the distribution of data<\/p>\n\n\n\n

4 \u2013 Data preview pane \u2013 you can view the data from your source<\/p>\n\n\n\n

5 \u2013 Tab with option: filtering, changing names, creating a calculated field, and a list of recommendations and viewing options<\/p>\n\n\n\n

6 \u2013 Map of your flow, which is useful when you navigate through large data flows<\/p>\n\n\n\n

<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

<\/p>\n\n\n\n

Looking at this data you can clearly see that it needs to be refined. The dataset contains details of the cars for sale. Note that such fields as Mileage or Price\u00a0 should contain numerical values instead of text. Let\u2019s start with the Mileage field. Click on the field options to get several available commands for data transformation. From the Clean field select Remove Letters and then Remove Punctuation. As a result, you should get the numbers and change the type of field from String (Abc) to Number (#Whole). The last step is to sort the null values for new cars out. All you need to do is click the null value, select edit value and enter 0. As a result, you will get a numeral field instead of a text field. In addition, on the list of changes there are four steps of the data transformation performed \u2013 you can edit or remove them, or change their order at a later stage:<\/p>\n\n\n\n

<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

<\/p>\n\n\n\n

A similar transformation should be performed for Price – start with removing punctuation characters. \u201c$\u201d is a problem, since it\u2019s not a letter, but a symbol. You need to remove it from the field \u2013 by using the Split function you will be able to keep the second element (the number). Next, remove the source field (Price) and change the name of the newly separated field to Price:<\/p>\n\n\n\n

<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

<\/p>\n\n\n\n

Once these transformations are performed, your database will contain ready-to-use numerical fields with the car mileage and prices for analysis.<\/p>\n\n\n\n

Prep for data cleaning<\/h2>\n\n\n\n

Tableau Prep is an excellent tool for data cleaning \u2013 it has a range of options available in the menu, so there is no need to create the calculation field. The steps created here will be automatically reproduced when the data is being refreshed. Once the data is cleaned, you can move to the next step, which involves transforming the data, followed by exporting it to Tableau. These steps will be presented in the future posts of this series.<\/p>\n\n\n\n

Mateusz Karmalski Tableau Author<\/p>\n","protected":false},"excerpt":{"rendered":"

Tableau Prep, from its launch as the component of the Tableau package, has been supporting data transformation and modelling. It can be described as the ETL (Extract Transform Load) programme and has the advantage of being not too complex. It\u2019s not an analytical powerhouse, but a smart tool designed for data modelling. Tableau defines Prep […]<\/p>\n","protected":false},"author":5,"featured_media":2886,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"content-sidebar","footnotes":""},"categories":[9,5],"tags":[],"class_list":{"0":"post-2878","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-blog","8":"category-tableau","9":"entry"},"yoast_head":"\nUsing Tableau Prep to Prepare Data for Visualization in Tableau - NewDataLabs<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using Tableau Prep to Prepare Data for Visualization in Tableau - NewDataLabs\" \/>\n<meta property=\"og:description\" content=\"Tableau Prep, from its launch as the component of the Tableau package, has been supporting data transformation and modelling. It can be described as the ETL (Extract Transform Load) programme and has the advantage of being not too complex. It\u2019s not an analytical powerhouse, but a smart tool designed for data modelling. Tableau defines Prep […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau\/\" \/>\n<meta property=\"og:site_name\" content=\"NewDataLabs\" \/>\n<meta property=\"article:published_time\" content=\"2024-01-25T11:00:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/01\/Blog-25.01.24.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"360\" \/>\n\t<meta property=\"og:image:height\" content=\"216\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Gosia\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Gosia\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau\/\"},\"author\":{\"name\":\"Gosia\",\"@id\":\"https:\/\/newdatalabs.com\/en\/#\/schema\/person\/e72471586cc4c4d811ff645bc4ae64f7\"},\"headline\":\"Using Tableau Prep to Prepare Data for Visualization in Tableau\",\"datePublished\":\"2024-01-25T11:00:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau\/\"},\"wordCount\":878,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/01\/Blog-25.01.24.jpg\",\"articleSection\":[\"Blog\",\"Tableau\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau\/\",\"url\":\"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau\/\",\"name\":\"Using Tableau Prep to Prepare Data for Visualization in Tableau - NewDataLabs\",\"isPartOf\":{\"@id\":\"https:\/\/newdatalabs.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/01\/Blog-25.01.24.jpg\",\"datePublished\":\"2024-01-25T11:00:00+00:00\",\"author\":{\"@id\":\"https:\/\/newdatalabs.com\/en\/#\/schema\/person\/e72471586cc4c4d811ff645bc4ae64f7\"},\"breadcrumb\":{\"@id\":\"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau\/#primaryimage\",\"url\":\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/01\/Blog-25.01.24.jpg\",\"contentUrl\":\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/01\/Blog-25.01.24.jpg\",\"width\":360,\"height\":216},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Strona g\u0142\u00f3wna\",\"item\":\"https:\/\/newdatalabs.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using Tableau Prep to Prepare Data for Visualization in Tableau\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/newdatalabs.com\/en\/#website\",\"url\":\"https:\/\/newdatalabs.com\/en\/\",\"name\":\"NewDataLabs\",\"description\":\"Tableau - Business Intelligence Tools\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/newdatalabs.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/newdatalabs.com\/en\/#\/schema\/person\/e72471586cc4c4d811ff645bc4ae64f7\",\"name\":\"Gosia\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/newdatalabs.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/445673971de6d34fc47aeb482636a72b51e216f3e84ffb2d993c8f129d0ffd79?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/445673971de6d34fc47aeb482636a72b51e216f3e84ffb2d993c8f129d0ffd79?s=96&d=mm&r=g\",\"caption\":\"Gosia\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Using Tableau Prep to Prepare Data for Visualization in Tableau - NewDataLabs","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau\/","og_locale":"en_US","og_type":"article","og_title":"Using Tableau Prep to Prepare Data for Visualization in Tableau - NewDataLabs","og_description":"Tableau Prep, from its launch as the component of the Tableau package, has been supporting data transformation and modelling. It can be described as the ETL (Extract Transform Load) programme and has the advantage of being not too complex. It\u2019s not an analytical powerhouse, but a smart tool designed for data modelling. Tableau defines Prep […]","og_url":"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau\/","og_site_name":"NewDataLabs","article_published_time":"2024-01-25T11:00:00+00:00","og_image":[{"width":360,"height":216,"url":"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/01\/Blog-25.01.24.jpg","type":"image\/jpeg"}],"author":"Gosia","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Gosia","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau\/#article","isPartOf":{"@id":"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau\/"},"author":{"name":"Gosia","@id":"https:\/\/newdatalabs.com\/en\/#\/schema\/person\/e72471586cc4c4d811ff645bc4ae64f7"},"headline":"Using Tableau Prep to Prepare Data for Visualization in Tableau","datePublished":"2024-01-25T11:00:00+00:00","mainEntityOfPage":{"@id":"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau\/"},"wordCount":878,"commentCount":0,"image":{"@id":"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau\/#primaryimage"},"thumbnailUrl":"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/01\/Blog-25.01.24.jpg","articleSection":["Blog","Tableau"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau\/","url":"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau\/","name":"Using Tableau Prep to Prepare Data for Visualization in Tableau - NewDataLabs","isPartOf":{"@id":"https:\/\/newdatalabs.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau\/#primaryimage"},"image":{"@id":"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau\/#primaryimage"},"thumbnailUrl":"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/01\/Blog-25.01.24.jpg","datePublished":"2024-01-25T11:00:00+00:00","author":{"@id":"https:\/\/newdatalabs.com\/en\/#\/schema\/person\/e72471586cc4c4d811ff645bc4ae64f7"},"breadcrumb":{"@id":"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau\/#primaryimage","url":"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/01\/Blog-25.01.24.jpg","contentUrl":"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/01\/Blog-25.01.24.jpg","width":360,"height":216},{"@type":"BreadcrumbList","@id":"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Strona g\u0142\u00f3wna","item":"https:\/\/newdatalabs.com\/en\/"},{"@type":"ListItem","position":2,"name":"Using Tableau Prep to Prepare Data for Visualization in Tableau"}]},{"@type":"WebSite","@id":"https:\/\/newdatalabs.com\/en\/#website","url":"https:\/\/newdatalabs.com\/en\/","name":"NewDataLabs","description":"Tableau - Business Intelligence Tools","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/newdatalabs.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/newdatalabs.com\/en\/#\/schema\/person\/e72471586cc4c4d811ff645bc4ae64f7","name":"Gosia","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/newdatalabs.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/445673971de6d34fc47aeb482636a72b51e216f3e84ffb2d993c8f129d0ffd79?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/445673971de6d34fc47aeb482636a72b51e216f3e84ffb2d993c8f129d0ffd79?s=96&d=mm&r=g","caption":"Gosia"}}]}},"_links":{"self":[{"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/posts\/2878","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/comments?post=2878"}],"version-history":[{"count":1,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/posts\/2878\/revisions"}],"predecessor-version":[{"id":2887,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/posts\/2878\/revisions\/2887"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/media\/2886"}],"wp:attachment":[{"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/media?parent=2878"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/categories?post=2878"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/tags?post=2878"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}