347 647 9001+1 714 797 8196Request a Call
Call Me

What is new in Tableau 9.0

April 29, 2015
, , , ,

In this blog, we are going to look at some of the important features of Tableau 9.0, released on April 6, 2015.


There have been lot of changes in terms of usability or user experience in Tableau 9.0.

As shown below the start experience has completely changed. On the left hand side, one can find options to connect to data sources and upgrade software options. On the right hand side, one can find new Discover option. It starts with link to How-to videos, shows the Viz of the day with thumbnail and other resources such as links to blog, sample data sets and live training videos. The middle section has the link to workbooks that one has recently opened. On the top-left corner, there is a button under File menu option, which quickly helps navigate between start page and visualization worksheet one has been working upon.

start page of Tableau 9

Let us say one has Tableau workbook open with multiple sheets in it. The new feature Preview thumbnails reveal a thumbnail of the sheet while hovering over sheet names when creating a dashboard or story.

Preview thumbnail feature in Tableau 9


A new Analytics Pane lets you drag constant line, reference line, box plots and other analytics right onto your view.

Analytics pane in Tableau 9

Tooltips are super responsive populating with new data for whichever mark one is hovering over in real-time in Tableau 9.0. In addition, the tooltip stays live instead of disappearing after predefined time as experienced in earlier versions.

Tooltip feature in Tableau

Tableau 9.0 allows for creating calculations right in the view by typing in field names and functions. One can also use the new Edit in Shelf editor to modify the calculations in the shelf itself, and then preview your changes instantly.

Calculations in Tableau 9

Once the reference lines are plotted, one can select a subset of points and tableau automatically creates the new reference lines using the selected subset of points.

reference line in Tableau

Data Preparation

Tableau 9.0 allows viewing just the metadata of the connections. One can quickly rename fields, hide columns and adjust data types. One can do split, merge and pivoting from the metadata grid itself.

data preparation in Tableau 9

Tableau 9.0 understands the data range and removes the extra titles, text, spaces, and images while reading the data. The pre-processing such as these can be done inside Tableau with the help of click of a button.

Data interpreter feature is supported only for Excel files opened through new Excel connectors.

Let us say we have an Excel file as shown below. One can see that the first row is not required.

data interpret feature in Tableau 9

When the same file is opened in Tableau 9.0, it interprets that there is something wrong with the structure of the data. Once the Data interpreter is turned on, it removes the unwanted first line.

data interpret feature in Tableau 9

Let us say that we want to convert the cross tab data into normalized tabular format. Tableau 9.0 provides Pivot feature to accomplish this task as shown below.

Pivot feature in Tableau 9

One can see that to begin with we had five rows representing data for five years for each of the seven states represented in the column. Once all the states are pivoted, Tableau generates 35 rows 5 for each of the states.

Tableau 9.0 allows split and custom split feature as well. Let us say for some reason you have data shown as below and you want to split the data contained in this one column to multiple columns.

split and custom split feature in Tableau 9

One can use split feature to accomplish the same.

split and custom split feature in Tableau 9

That is it for now but this is not the end of the features that Tableau 9.0 provides. There are lot many more features that are exciting in Tableau 9.0 such as Smart Maps, Statistical File connectors, Cloud and Big Data connections, new Level of details (LOD) expressions. Make sure to explore them own on your own.

Stay tuned for more news and visualizations with Tableau 9.0 going forward.

More Links

One can find the release notes here and more details about the new features here

About Tableau

Tableau (NYSE: DATA) headquartered in Seattle, Washington has a mission to help people see and understand data. It offers a product portfolio for data visualization focused on business intelligence.

One can visit the official Tableau website to find more details about Tableau and its product offering and features.


About the Author

Pranay Vasani from Mumbai is passionate about Data Visualization and Data Science. He works as a Senior Business Analyst in Business Intelligence and Pricing domain. He is a guest faculty for teaching Data Visualization with Tableau and a guest blogger at Edupristine.


Global Association of Risk Professionals, Inc. (GARP®) does not endorse, promote, review or warrant the accuracy of the products or services offered by EduPristine for FRM® related information, nor does it endorse any pass rates claimed by the provider. Further, GARP® is not responsible for any fees or costs paid by the user to EduPristine nor is GARP® responsible for any fees or costs of any person or entity providing any services to EduPristine Study Program. FRM®, GARP® and Global Association of Risk Professionals®, are trademarks owned by the Global Association of Risk Professionals, Inc

CFA Institute does not endorse, promote, or warrant the accuracy or quality of the products or services offered by EduPristine. CFA Institute, CFA®, Claritas® and Chartered Financial Analyst® are trademarks owned by CFA Institute.

Utmost care has been taken to ensure that there is no copyright violation or infringement in any of our content. Still, in case you feel that there is any copyright violation of any kind please send a mail to and we will rectify it.

Popular Blogs: Whatsapp Revenue Model | CFA vs CPA | CMA vs CPA | ACCA vs CPA | CFA vs FRM

Post ID = 74901