Analytics anyone can use.
Analytics for organizations.
Cloud analytics for organizations
When you can ask questions faster, without waiting for a long running query or a page to load, you are able to stay in the flow of analysis. This lets you focus on your data and creatively explore the insights it has to offer, uninterrupted. That’s why in Tableau Version 9.0 we’ve invested in making performance enhancements across the product to help you get results faster and ask deeper questions.
Here are a few examples of the many improvements that we’ve made in Tableau 9.0. Each example illustrates how the improvement is impacting performance, using a standard 4-core commodity laptop. Of course, your mileage may vary based on the amount of data, the type of queries, and the underlying database that you are using. Bear in mind these are examples and not a statement of performance gains you should expect on every data set.
Data Engine Improvements
Tableau has a strong history of groundbreaking innovations in performance, most notably is Tableau’s Data Engine that first launched with Tableau 6.0. The Data Engine is an in-memory analytic database, designed for much faster queries.
Data Engine improvements in Tableau 9.0 now make the fast analytic data engine even faster, with features that are designed to make the most of your underlying hardware. This example shows a 10X performance improvement on 173M rows of data:
Tableau 9.0 also takes better advantage of the capabilities of source databases to execute more queries at the same time. This new “Parallel Queries" feature will improve Dashboard performance, on Desktop and Server. This example shows a 9X improvement on 157M rows of data:
What’s better than faster queries? Fewer queries. Tableau 9.0 has a new technology for database connections called Query Fusion that will look at all of the queries in your dashboard and find ways to simplify them into fewer queries. That will result in less work for the database and faster response times for the user. This example shows a 2x improvement on an Amazon Redshift database:
External Query Caching
Finally, imagine that no queries need to run at all, and tools simply step out of the way when starting analysis. When loading a workbook for the first time, Tableau queries the data source to get the values to create the visualizations. However, what happens the second time? If the data hasn’t changed, like with extract-based workbooks, why even query the data source?
Tableau 9.0 will save the query cache as part of the workbook on both Desktop and Server, offering near-instant load times for applicable workbooks. There is no need to re-query for answers since the results are already there, and users can simply refresh to replace the cache.
Imagine simply re-opening a workbook that has been opened locally before, or that has already been viewed on Server, and seeing a virtually instant load time. In v9.0, sometimes the best query performance features are when no queries need to run at all. This example shows a 50X improvement on 157M rows of data:
These are just a few of the exciting new performance features that will be introduced in Tableau 9.0. These features build on top of each other to provide unprecedented performance for users. Queries run faster on extracts, queries run in parallel for faster load times, fewer queries run, and in some scenarios, all the queries in a view will be eliminated with caching. Tableau 9.0 is faster, and we’ve got more in the pipeline that will let you have a more immersive experience with your data.
Want to Learn More?
Check out the rest of our Tableau 9.0 blog series