{"id":3195,"date":"2024-02-15T12:00:33","date_gmt":"2024-02-15T11:00:33","guid":{"rendered":"https:\/\/newdatalabs.com\/en\/?p=3195"},"modified":"2024-04-24T12:35:57","modified_gmt":"2024-04-24T10:35:57","slug":"using-tableau-prep-to-prepare-data-for-visualization-in-tableau-part-3","status":"publish","type":"post","link":"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau-part-3\/","title":{"rendered":"Using Tableau Prep to Prepare Data for Visualization in Tableau \u2013 Part 3"},"content":{"rendered":"\n<p>In the previous posts, we explored the basics of data processing in Tableau Prep. We started with loading the data, then we cleaned it and applied various transformation options: grouping, splitting or filtering. We also learned how to create calculation fields. In this last post of a series, we will present additional methods of data transformation: aggregation, pivoting and blending. Lastly, we will discuss exporting data for further visual analysis in Tableau Desktop. We will also highlight what else is possible using Prep as a tool for the daily work of analysts.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Data Aggregation<\/h2>\n\n\n\n<p>In a situation where your data is shown in more detail than you need it, you can aggregate it in Prep. For example, when you have the purchase order data broken down into individual items (products), you can aggregate them at the purchase order level, to allow their analysis at a later stage. To aggregate data in Prep, use the Aggregate (1) feature. In the editor, select the grouped fields to be used in aggregation (2), and the aggregated fields, which are the measures to be aggregated (3). In this example, we will aggregate the average price by vehicle brands:<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/1-blog-15.02.24.png\"><img decoding=\"async\" width=\"1024\" height=\"528\" data-src=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/1-blog-15.02.24.png\" alt=\"\" class=\"wp-image-3196 lazyload\" data-srcset=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/1-blog-15.02.24.png 1024w, https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/1-blog-15.02.24-300x155.png 300w, https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/1-blog-15.02.24-768x396.png 768w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/528;\" \/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Next, add Clean to view your data. You will get a tailored dataset that contains Macros and Price fields only.<\/p>\n\n\n\n<p>Let\u2019s stop for a moment here. Prep enables not only a linear data flow \u2013 we can create parallel flows, generating various transformation options of one dataset. We will do that in our scenario by adding another field before moving on to Aggregate. This will allow to display the detailed data at the top, and the aggregated data at the bottom of the flow.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/2-blog-15.02.24.png\"><img decoding=\"async\" width=\"1024\" height=\"395\" data-src=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/2-blog-15.02.24.png\" alt=\"\" class=\"wp-image-3197 lazyload\" data-srcset=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/2-blog-15.02.24.png 1024w, https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/2-blog-15.02.24-300x116.png 300w, https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/2-blog-15.02.24-768x296.png 768w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/395;\" \/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Data pivoting<\/h2>\n\n\n\n<p>It is often the case that analysts need to work with the data, which is not in a database format, but in a tabular form. Particularly in finance, where rows represent measures, and columns represent values for various periods. To perform a meaningful analysis of the data structured in this way, you need to pivot the data, in other words, to rearrange it. Prep has a separate Pivot function to help you do that. Let\u2019s assume that you want to include premium rates in the data arranged in a tabular format \u2013 rows represent car brands and columns refer to the car\u2019s age:<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/3-blog-15.02.24.png\"><img decoding=\"async\" width=\"936\" height=\"281\" data-src=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/3-blog-15.02.24.png\" alt=\"\" class=\"wp-image-3198 lazyload\" data-srcset=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/3-blog-15.02.24.png 936w, https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/3-blog-15.02.24-300x90.png 300w, https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/3-blog-15.02.24-768x231.png 768w\" data-sizes=\"(max-width: 936px) 100vw, 936px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 936px; --smush-placeholder-aspect-ratio: 936\/281;\" \/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Load the data into Prep. In the first step, you will see your data in the same format as in Excel:<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/4-blog-15.02.24.png\"><img decoding=\"async\" width=\"1024\" height=\"503\" data-src=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/4-blog-15.02.24.png\" alt=\"\" class=\"wp-image-3199 lazyload\" data-srcset=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/4-blog-15.02.24.png 1024w, https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/4-blog-15.02.24-300x147.png 300w, https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/4-blog-15.02.24-768x377.png 768w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/503;\" \/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Add another step: Pivot. In the editor, add your columns with the values as Pivoted Fields. They will be transformed into fields with headers in a separate column. Next, change the name of the newly created columns to Year and Cost, and the Insurance field to Brand. This way you will get an appealing database format of the original table for further analysis:<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/5-blog-15.02.24.png\"><img decoding=\"async\" width=\"1024\" height=\"330\" data-src=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/5-blog-15.02.24.png\" alt=\"\" class=\"wp-image-3200 lazyload\" data-srcset=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/5-blog-15.02.24.png 1024w, https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/5-blog-15.02.24-300x97.png 300w, https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/5-blog-15.02.24-768x248.png 768w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/330;\" \/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Connecting data from many sources<\/h2>\n\n\n\n<p>One of the basic operations in Excel that is an essential tool for analysts, is the VLOOKUP functionality. It is a very useful function, but it requires high computing performance, especially when working with large databases. Despite this, it allows us to display in our dataset the information from various dictionaries. You can do that in Prep by connecting the data in the Join feature. We will use this functionality to add premium costs to our database. Start by adding a new step \u2013 Join which needs two inputs. We are going to use the database of cars and the cost table (1):<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/6-blog-15.02.24.png\"><img decoding=\"async\" width=\"1024\" height=\"574\" data-src=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/6-blog-15.02.24.png\" alt=\"\" class=\"wp-image-3201 lazyload\" data-srcset=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/6-blog-15.02.24.png 1024w, https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/6-blog-15.02.24-300x168.png 300w, https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/6-blog-15.02.24-768x431.png 768w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/574;\" \/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>The next step is to define Join Clauses in order to determine which fields should be connected. You can see the data in a preview (3). It is worth noting the colours, which are consistent with the colours used in the flow to make it easier to understand what they represent. Next, you need to arrange your Join by selecting one of the following options:<\/p>\n\n\n\n<p>1 \u2013 Left \u2013 it\u2019s the most useful; you add to the source on the left side the information from the source on the right. If any attribution is missing, it will appear in the box (5)<\/p>\n\n\n\n<p>2 \u2013 Right \u2013 just like for the left: you add to the source on the right the information from the source on the left<\/p>\n\n\n\n<p>3 \u2013 Full \u2013 the result will contain all items from the sources on the left and on the right<\/p>\n\n\n\n<p>4 \u2013 Inner \u2013 the common part will be returned, and Not Inner \u2013 everything except for the common part will be returned<\/p>\n\n\n\n<p>5 \u2013 Left\/right only \u2013 the result has an item from one source, which is not included in the other source<\/p>\n\n\n\n<p>In practice, we usually use the left\/right joins. It is worth mentioning that you can also choose the type of Join by graphical interface \u2013 simply select the parts that you want to include. The result of the connected data can be viewed in a window (6), and it\u2019s consistent with the colour design in the flow. Union is another method to connect the data \u2013 it allows you to join the data which has the same layout, by adding it to one another. In this example, you can add the sales data from a different region or a different brand. First, you need to add a separate source and in the next step \u2013 Union \u2013 connect it to the original table. Here you can pin into the flow at an early stage to avoid repeating transformation (1).<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/7-blog-15.02.24.png\"><img decoding=\"async\" width=\"1024\" height=\"509\" data-src=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/7-blog-15.02.24.png\" alt=\"\" class=\"wp-image-3202 lazyload\" data-srcset=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/7-blog-15.02.24.png 1024w, https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/7-blog-15.02.24-300x149.png 300w, https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/7-blog-15.02.24-768x382.png 768w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/509;\" \/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Component tables are listed in the panel (2), and any unmatched fields (that are missing in any table will also be shown in the panel (3). You will see the result of the Union in a window (4), where you can also see a new window that was automatically created by Prep &#8211; Table Names &#8211; which shows the source of your data.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Last update \u2013 data export<\/h2>\n\n\n\n<p>The last step of the data transformation in Prep involves exporting the data for further analysis. You can do that in Output, where you need to choose the Output type (file, published data source, database or CRM). The simplest way is to select the File for which you will specify the Location, the type of file (extract Tableau, Excel or text file), and how the data is going to be refreshed (create a table or Append \u2013 add the data to the existing table).<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/8-blog-15.02.24.png\"><img decoding=\"async\" width=\"1024\" height=\"574\" data-src=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/8-blog-15.02.24.png\" alt=\"\" class=\"wp-image-3203 lazyload\" data-srcset=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/8-blog-15.02.24.png 1024w, https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/8-blog-15.02.24-300x168.png 300w, https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/8-blog-15.02.24-768x431.png 768w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/574;\" \/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>The last thing to do is to click the Run Flow in order to generate the Output, which can be used, for example, for visual analysis. If everything went fine and Prep didn\u2019t detect any errors in the data flow, you will get the following message:<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/9-blog-15.02.24.png\"><img decoding=\"async\" width=\"368\" height=\"256\" data-src=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/9-blog-15.02.24.png\" alt=\"\" class=\"wp-image-3204 lazyload\" data-srcset=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/9-blog-15.02.24.png 368w, https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/9-blog-15.02.24-300x209.png 300w\" data-sizes=\"(max-width: 368px) 100vw, 368px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 368px; --smush-placeholder-aspect-ratio: 368\/256;\" \/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Tableau Prep tool for data analyst<\/h2>\n\n\n\n<p>Prep is a very efficient and visually attractive ETL programme. Despite this, it isn\u2019t overloaded with options, and the graphical interface helps understand what is happening with your data at each stage of the transformation. Prep is a great tool particularly in terms of further analysis in Tableau Desktop, as it allows us to immediately extract the data in a hyperformat. This will simplify working with data in Tableau Desktop and make it more user-friendly.<\/p>\n\n\n\n<p>Mateusz Karmalski, Tableau Author<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In the previous posts, we explored the basics of data processing in Tableau Prep. We started with loading the data, then we cleaned it and applied various transformation options: grouping, splitting or filtering. We also learned how to create calculation fields. In this last post of a series, we will present additional methods of data [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"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-3195","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-blog","7":"category-tableau","8":"entry"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Using Tableau Prep to Prepare Data for Visualization in Tableau \u2013 Part 3 - 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-part-3\/\" \/>\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 \u2013 Part 3 - NewDataLabs\" \/>\n<meta property=\"og:description\" content=\"In the previous posts, we explored the basics of data processing in Tableau Prep. We started with loading the data, then we cleaned it and applied various transformation options: grouping, splitting or filtering. We also learned how to create calculation fields. In this last post of a series, we will present additional methods of data [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau-part-3\/\" \/>\n<meta property=\"og:site_name\" content=\"NewDataLabs\" \/>\n<meta property=\"article:published_time\" content=\"2024-02-15T11:00:33+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-24T10:35:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/1-blog-15.02.24.png\" \/>\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=\"7 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-part-3\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau-part-3\/\"},\"author\":{\"name\":\"Gosia\",\"@id\":\"https:\/\/newdatalabs.com\/en\/#\/schema\/person\/e72471586cc4c4d811ff645bc4ae64f7\"},\"headline\":\"Using Tableau Prep to Prepare Data for Visualization in Tableau \u2013 Part 3\",\"datePublished\":\"2024-02-15T11:00:33+00:00\",\"dateModified\":\"2024-04-24T10:35:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau-part-3\/\"},\"wordCount\":1172,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau-part-3\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/1-blog-15.02.24.png\",\"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-part-3\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau-part-3\/\",\"url\":\"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau-part-3\/\",\"name\":\"Using Tableau Prep to Prepare Data for Visualization in Tableau \u2013 Part 3 - NewDataLabs\",\"isPartOf\":{\"@id\":\"https:\/\/newdatalabs.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau-part-3\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau-part-3\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/1-blog-15.02.24.png\",\"datePublished\":\"2024-02-15T11:00:33+00:00\",\"dateModified\":\"2024-04-24T10:35:57+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-part-3\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau-part-3\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau-part-3\/#primaryimage\",\"url\":\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/1-blog-15.02.24.png\",\"contentUrl\":\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/1-blog-15.02.24.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau-part-3\/#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 \u2013 Part 3\"}]},{\"@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 \u2013 Part 3 - 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-part-3\/","og_locale":"en_US","og_type":"article","og_title":"Using Tableau Prep to Prepare Data for Visualization in Tableau \u2013 Part 3 - NewDataLabs","og_description":"In the previous posts, we explored the basics of data processing in Tableau Prep. We started with loading the data, then we cleaned it and applied various transformation options: grouping, splitting or filtering. We also learned how to create calculation fields. In this last post of a series, we will present additional methods of data [&hellip;]","og_url":"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau-part-3\/","og_site_name":"NewDataLabs","article_published_time":"2024-02-15T11:00:33+00:00","article_modified_time":"2024-04-24T10:35:57+00:00","og_image":[{"url":"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/1-blog-15.02.24.png","type":"","width":"","height":""}],"author":"Gosia","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Gosia","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau-part-3\/#article","isPartOf":{"@id":"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau-part-3\/"},"author":{"name":"Gosia","@id":"https:\/\/newdatalabs.com\/en\/#\/schema\/person\/e72471586cc4c4d811ff645bc4ae64f7"},"headline":"Using Tableau Prep to Prepare Data for Visualization in Tableau \u2013 Part 3","datePublished":"2024-02-15T11:00:33+00:00","dateModified":"2024-04-24T10:35:57+00:00","mainEntityOfPage":{"@id":"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau-part-3\/"},"wordCount":1172,"commentCount":0,"image":{"@id":"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau-part-3\/#primaryimage"},"thumbnailUrl":"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/1-blog-15.02.24.png","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-part-3\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau-part-3\/","url":"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau-part-3\/","name":"Using Tableau Prep to Prepare Data for Visualization in Tableau \u2013 Part 3 - NewDataLabs","isPartOf":{"@id":"https:\/\/newdatalabs.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau-part-3\/#primaryimage"},"image":{"@id":"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau-part-3\/#primaryimage"},"thumbnailUrl":"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/1-blog-15.02.24.png","datePublished":"2024-02-15T11:00:33+00:00","dateModified":"2024-04-24T10:35:57+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-part-3\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau-part-3\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau-part-3\/#primaryimage","url":"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/1-blog-15.02.24.png","contentUrl":"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2024\/02\/1-blog-15.02.24.png"},{"@type":"BreadcrumbList","@id":"https:\/\/newdatalabs.com\/en\/using-tableau-prep-to-prepare-data-for-visualization-in-tableau-part-3\/#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 \u2013 Part 3"}]},{"@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\/3195","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=3195"}],"version-history":[{"count":1,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/posts\/3195\/revisions"}],"predecessor-version":[{"id":3206,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/posts\/3195\/revisions\/3206"}],"wp:attachment":[{"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/media?parent=3195"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/categories?post=3195"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/tags?post=3195"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}