When you click on a value within a field, the associated data in all other fields are highlighted to give you a sense of the relationship between fields. If the number of fields is too large to fit in the view a summarized distribution is displayed on the right-hand side.įor numerical fields you have the option of using a discrete histogram or alternatively a continuous histogram with bins like the one below. When are dealing with strings or date fields, Tableau Prep will display a discrete histogram. Tableau Prep’s profile pane helps you navigate and understand the overall dataset faster.įor each field in the dataset you can see the number of unique values and their distribution via the use of histograms. When dealing with a broad dataset containing many fields it is hard to maintain a visual reference of what the data looks like. The first step for any analyst should be to understand the nature of the data they’re dealing with, their type, form and characteristics. If you’re happy with the result you can quickly insert an output node and save the now prepared data locally or publish it as a data source.Ģ) Data Distribution Display in the Profile Pane Prep is fully integrated into the Tableau analytical workflow so you can quickly and easily move from data preparation to data exploration.Īt any point in your workflow you can open your the result of your Tableau Prep flow in Tableau, to explore the data straight away. Learn more about Tableau product pricing here. So why should you use Tableau Prep? Well, for one, Tableau Prep is included in the Tableau Creator license and is essentially free. There are many ETL tools out there in the market and the competition is only getting fiercer. Any edits performed on the data in the flow or profile pane are mirrored in the row level data, allowing you to consistently track the format of the data. This is the bottom pane in the view, which illustrates the lowest granularity of the data that is the row level. This is one of the most accommodating pane since it facilitates most of the cleaning operations that you can perform on the data and it visually highlights the relationship between the fields. You can find out the number of unique values contained within each field and how they are distributed. The profile pane is the middle pane in the view and acts as a high-level overview of the data, illustrating each fields’ profile. To learn more about each of the steps please visit the official Tableau documentation. The flow pane allows you to keep track of the sequence of steps. This is the uppermost pane in the view, which acts as a visual guide showing all steps in the ETL process from beginning to end. Let’s consider each of the three views in more detail. You get a complete understanding of what the data looks like and how it’s distributed. At its core, Tableau Prep is built around three different views which allow you to view your data on three different levels of granularity simultaneously. One of the first things that strikes you when working in Tableau Prep is its intuitive, easy-to-navigate and user-friendly interface. Let’s dive into Tableau Prep and take a closer look at some of its features! The Tableau Prep Interface You can now do your data preparation with Tableau’s own ETL solution called Tableau Prep (formerly Project Maestro), allowing a seamless transition between your data preparation and data analysis. With Tableau you often realise than your data is of a greta quality and you end up spending most of your time trying to structure, shape and format data properly before you can explore it.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |