Tableau 9.0 Keeps Focus On End-User Productivity - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

Data Management // Big Data Analytics
02:36 PM
Doug Henschen
Doug Henschen
Connect Directly

Tableau 9.0 Keeps Focus On End-User Productivity

Tableau Software's latest upgrade adds tools for data prep, quick calculations, and making predictions without need of a PhD.

10 Management Books Every CIO Should Read
10 Management Books Every CIO Should Read
(Click image for larger view and slideshow.)

Tableau Software stayed true to its roots with Tableau 9.0, the company's latest major release, announced Tuesday, April 7. The upgrade is predominantly about personal productivity and performance gains for end-users. It adds a few new tools for admins who manage the vendor's server and cloud-based products.

Tableau's strength since its founding in 2003 has been ease of use. The company's core product is a desktop data visualization tool that has had a habit of spreading wherever it shows up. In some cases, particularly in the early days, it was a shadow IT phenomenon. Central IT and BI control freaks didn't always appreciate the requests for data access and non-BI-team-sanctioned data insights.

These days the business-side thirst for hands-on data analysis and insight trumps command-and-control-style IT and BI, and Tableau is often a company standard, complemented by Tableau Server or Tableau Online (cloud-based) deployments for centralized publishing and sharing of analyses. So Tableau's focus on ease of use for the individual has paid off, and the tradition continues with Tableau 9.0

[How much are you enabling end-users? Read Data Analyst: Does Everybody Need To Be One?]

The long list of user-oriented improvements in 9.0 leads with new data-prep and predictive-analytics capabilities, as well as performance enhancements that greatly reduce query times, according to Tableau.

As for those data-prep features, don't think about centralized data sources and enterprise-data cleansing. Tableau 9.0 promises desktop-level, hands-on data-wrangling without having to switch to another tool. Tableau 9.0 introduces a data interpreter that helps users connect related spreadsheets automatically by removing headers, footers, and empty rows. A new pivot feature lets you select and combine columns (such as years or months) without coding. You can also split data, such as VIN numbers or email addresses, into columns for each component, separating IDs from domain names, for example.

Tableau acknowledges that many data problems are about centralized sources, but it leaves those problems to specialized partners such as Alteryx, Informatica, Trifacta, and Paxata.

In another consistency with easy-of-use principles, you won't need a PhD to manage new Tableau 9.0 trending, forecasting, and predictive analytics capabilities. These analyses are triggered by dragging and dropping dimensions of data (such as product sales) onto an analytics pane. As you move from simple trending to more advanced prediction, the software taps into 20 different modeling approaches that run in the background, and it automatically picks what it considers the right approach.

If you're an advanced analytics expert and know what you're doing, you can select the modeling approach you want, or even import an R-language-based algorithm. If you're like most users, you'll leave it to the tool to choose best-fit algorithms and modeling approaches based on the data you choose for the analysis.

Predictive analytics capabilities introduced in Tableau 9.0 yield trend lines (seen here), forecasts, and predictions based on behind-the-scenes algorithmic analysis.

Predictive analytics capabilities introduced in Tableau 9.0 yield trend lines (seen here), forecasts, and predictions based on behind-the-scenes algorithmic analysis.

Tableau 9.0 is speedier, thanks to better use of parallel and vector processing capabilities that are built into chips, and it applies to the vendor's desktop, server, and online software. As a result, queries that were previously handled in a serial way that took, say, 10 seconds, will now be processed in 2 to 3 seconds, according to Tableau. The vendor says a beta customer who had a particularly complex dashboard with many embedded queries saw response time drop from one minute down to 7 seconds, which is certainly more within the realm of consumer-grade performance expectations.

Other user-oriented upgrades in Tableau 9.0 include:

Type-in calculations. Similar to the simple calculations you can do in Excel, this feature lets you add, subtract, and apply other math functions to columns -- so you can reveal profits by subtracting cost from sales, for example.

Level-of-detail expressions. This feature lets you quickly apply queries at different levels of aggregation. For example, you could apply a calculation you set up for one state to a particular region of that state or to multiple states that make up a region of a country.

Improved mapping. Map-based analysis is said to be faster and more responsive in 9.0, but users also get the ability to lasso free-form shapes for precise selection, rather than just zooming in with a circular magnifying glass tool. Users can also just search by geography, entering zip codes or city, county, state, and country names.

Tableau Server and Tableau Online (which is a hosted service based on Tableau Server) have a new look and feel, according to the company, giving those administrators better search capabilities and a much more visual way to manage users and user-access permissions. The visual approach gives admins a clearer, role-based understanding of why certain users have certain permissions.

This is pretty basic stuff where administration is concerned and not the kind of "governance" capabilities big BI incumbents point to, contrasting their data-cleansing, data-integration, and layered data-, report-, and dashboard-access controls against what Tableau has to offer.

Tableau isn't playing an imitation game. Rather, it's sticking to what it does best: making data analysis easy and broadly accessible. Now a few of the giants, including IBM and Microsoft, are following in Tableau's path, introducing "freemium" services (Watson Analytics and Power BI) with a focus on ease-of-use and data visualization. Only time will tell if these fairly recent, cloud-based services will put a crimp in Tableau's steady, double-digit annual growth of recent years.

Attend Interop Las Vegas, the leading independent technology conference and expo series designed to inspire, inform, and connect the world's IT community. In 2015, look for all new programs, networking opportunities, and classes that will help you set your organization’s IT action plan. It happens April 27 to May 1. Register with Discount Code MPOIWK for $200 off Total Access & Conference Passes.

Doug Henschen is Executive Editor of InformationWeek, where he covers the intersection of enterprise applications with information management, business intelligence, big data and analytics. He previously served as editor in chief of Intelligent Enterprise, editor in chief of ... View Full Bio
We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
Comment  | 
Print  | 
More Insights
Newest First  |  Oldest First  |  Threaded View
Charlie Babcock
Charlie Babcock,
User Rank: Author
4/7/2015 | 11:03:28 PM
At last, a look at Tableau
Tableau is one of the few data visualization and analysis tools that I keep hearing about. Good to see it laid out in detail in this 9.0 version.
InformationWeek Is Getting an Upgrade!

Find out more about our plans to improve the look, functionality, and performance of the InformationWeek site in the coming months.

Becoming a Self-Taught Cybersecurity Pro
Jessica Davis, Senior Editor, Enterprise Apps,  6/9/2021
Ancestry's DevOps Strategy to Control Its CI/CD Pipeline
Joao-Pierre S. Ruth, Senior Writer,  6/4/2021
IT Leadership: 10 Ways to Unleash Enterprise Innovation
Lisa Morgan, Freelance Writer,  6/8/2021
White Papers
Register for InformationWeek Newsletters
Current Issue
Planning Your Digital Transformation Roadmap
Download this report to learn about the latest technologies and best practices or ensuring a successful transition from outdated business transformation tactics.
Flash Poll