What’s New in Tableau 8.2 – Visual Data Window

Data

What’s New in Tableau 8.2 – Visual Data Window

by Nick Joslyn

With Tableau 8.2 now available, the InterWorks team wants to give you an in-depth look at some of our favorite new features. Our What’s New in Tableau 8.2 blog series covers these in detail. This post is the third post in the series. Check out the full list on our Tableau 8.2 blog channel.

There are several great visual changes in the Tableau 8.2 release, such as more aesthetically pleasing fonts and icons. The most effective use of visualization in this release is the total redesign of the data connection experience. With the data connection process being more visual than before, it makes everything more instinctive – leading the user to make fewer mistakes. 

How Does the New Process Work?

Now that I have hyped up the new data connection process enough, let’s take a look at it in action.  Things do not change until you select the data to which you want to connect. For this example, I will be using the Sample – Superstore Subset (Excel).xlsx file that can be found in the following directory on your computer: My Tableau RepositoryDatasources. After double-clicking the file, you will be presented with the new, beautifully-designed Visual Data Window shown below.

Sample - Superstore

To start the process, drag the primary data source, Orders, to the white space appropriately labeled, Drag sheets here. Then, “boom!” all the data shows up:

Orders  

Not only does the data show up, but the field names and data type are presented. The data type icon is extremely helpful because you can change the data type easily. Let’s say you need to change the City field from a string to the Geographic Role of City. All you need to do is click the icon, and you will be presented with a drop-down menu listing the different data type options.  

Geographic Role -> City” height=”418″ src=”/wp-content/uploads/sites/default/files/blog-content/whats-new-tableau-8-2-visual-data-window/Visual3.png” width=”354″ /></p><h2>Hide or Rename Fields</h2><p>Another feature you can take advantage of in the <strong>Visual Data Window</strong> is renaming or hiding fields. To do this, hover over the field name you would like to change. A blue arrow will appear. Click the arrow, and you will be presented with two options: <strong>Rename</strong> or <strong>Hide</strong>. Choose whichever one is appropriate for your need.</p><p><img alt=

The Join Visualization

Now, let me show you the best part of the redesign: the join visualization. Let’s say that for the analysis you are doing, you also need to view the Returns and Users data. You can achieve this by simply dragging the sheets to the portion of the Visual Data Window where you previously dragged and dropped the Orders sheet. Tableau should then create a join between the data sets. If it doesn’t, just click the two circles. Then, select the join you wish to perform. You can also change or add what fields the join is connecting to from the Join dialog box.

Join

When you drag the Returns sheet, an inner join is created. Let’s say you need a left join because you want to keep all orders in the sheet, but will need to reference which orders were returned.   

Left join

If you are not familiar with how joins work, Tableau has a helpful tooltip to help clarify what each join does. Hover over the square of whatever join you want to know more about and a text box will appear with a brief description. The data is also appended to the end of the data set, so you can see what the join did. You can double check to make sure whether the join you performed was the proper one or not. 

Join results 

One more way you could check this is by looking at the number of rows in the data set. This can be found on the right, directly above the data list. If you need to join a sheet and keep all rows, and the row total subsequently drops, chances are you need to change the join type.   

Change Join Type

To make changes to the data, click the gear icon to select field name options or to rename the data source. To remove the data, hover over the data source and click the red “X.”   

Change Data Type

To add a data filter, look no further than the top-right corner. Click Add… under Filters. This dialog box works the same as in Tableau 8.1.

If you are not sure what data is contained in a particular sheet, you can view it by hovering over the sheet name on the left side of the window and clicking the icon that appears.  

Sheet name hover  

The last feature is the ease of switching between a Live and Extract connection. Simply click the radio button of what connection type you want. 

Switch between Live and Extract   

The last thing to do is to click the Go to Worksheet button in the middle of the window. It will take you to your worksheet.  

Go to Worksheet

What if you forget, and connect live when you need an extract? Or, what if you need to update a join? Click Data in the top menu bar and select your data source. Then, choose Edit Data Source…

Edit Data Source...

That’s all there is to it! The Visual Data Window makes working with your data sources easier than ever. 

Learn More

Want to learn how to utilize the new Tableau 8.2 features in your business? InterWorks is the leading provider of Tableau consulting and training services. Let us know how we can help!

Contact Us

More About the Author

Nick Joslyn

Analytics Consultant
2015 CFP Championship: Calculating Recruiting Distances in Tableau A couple weeks ago, I came across a College Football Playoff blog post that mapped the distance of each team’s campus to each ...
What’s New in Tableau 8.2 – Visual Data Window With Tableau 8.2 now available, the InterWorks team wants to give you an in-depth look at some of our favorite new features. Our What’s ...

See more from this author →

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072