Coming Soon in Tableau 8.1 - USEReady
Coming Soon in Tableau 8.1 Tableau 8.1 will provide many new and exciting capabilities to the Tableau products. This release provides new analytical and statistical functionality, user experience improvements, Tableau Server capabilities to integrate with other enterprise systems, data source and connectivity updates and additional functionality for web and mobile authors.
Rank: You can easily calculate the rank order of your data using the new Rank Table Calculation. You can customize the calculation with several options for how items with same values are ordered.
Analytics and Statistics
Tableau 8.1 provides new statistical & analytical capabilities including Percentiles, Ranking, Prediction Bands, box-‐and-‐whisker plots and integration with the R statistical software. Box-‐and-‐whisker plots: A box-‐and-‐whisker plot is a useful way to graphically show the distribution of data and how it groups around quartiles. Statistical outliers represented on a box-‐and-‐whisker plot are easily identified. Box-‐ and-‐whisker plots can be created using Show Me and can be configured using the reference line options.
Percentiles: A new aggregation is available to help you see percentiles and distributions in your data. You can also use Percentiles in the Quick Table Calculations menu or use the new PERCENTILE function in calculated fields. September 2013
Prediction Bands: All forecasts have a level of uncertainty. With Tableau 8.1 you can add predication bands to your forecasts to visually represent the confidence ranges of the forecast. For example, the forecast line shows a shaded region around it to indicate the range for 90%, 95%, or 99% certainty for the prediction.
Two-‐pass Totals: The aggregation level for your totals can be changed to be different than the aggregation of the measure. For example, you can have a cross tab show the sum of values in the body of the table with the totals showing the maximum (or other aggregation).
Tableau Software, Inc.
Page 1 of 5
Coming Soon in Tableau 8.1
Forecasting Improvements: Tableau 8.1 improves forecasting by allowing you to forecast using multiple measures per pane including using “Measure Names” and “Measure Values”. Use the forecasting models with fiscal calendars. In addition, new multiplicative models have been added to give you more precision in your forecasts.
User Experience Improvements
Calendar Control: Quick filters for date fields now have the option to be displayed as a visual calendar to provide a more natural experience in selecting dates.
R Integration: R is a popular open-‐source environment for statistical analysis. R functions and models can now be used by creating new calculated fields that dynamically invoke the R engine and pass values to R with the results returned back to Tableau for use in the visual analysis.
“Start of Week” support: Typical convention in the United States is for Sunday to be considered the first day of the week. Outside of the U.S. it is more typical for Monday to be considered the first day of the week. You can now configure which day of the week (any of the seven) to be used as the start of the week, which affects how date calculations are computed, and the ordering of days on the axis.
Transparency in dashboards: The new transparency option allows you to create more polished looking dashboards. Transparency can be controlled for legends, images, and text objects. Folders in the data window: You can now create folders in the dimensions, measures, sets, and parameters sections of the Data window. Folders allow you to categorize and organize fields by grouping similar items together and helping people find items more efficiently.
September 2013
Copy and Paste sheets between workbooks: You can now copy a sheet or dashboard from one workbook to another. Your data connections, formatting, and settings are copied to the new workbook. This new capability makes it a breeze to assemble new workbooks from collections of sheets and dashboards from other existing workbooks.
Tableau Software, Inc.
Page 2 of 5
Coming Soon in Tableau 8.1
Presentation mode improvements: The presentation mode has been refined to provide a more polished environment. The new presentation mode displays your sheets and dashboards in full screen mode. The standard Tableau interface is no longer visible and you can fully interact with your content like you normally do. Quick Filter Formatting: Enhanced quick filter formatting control has been added to aid in achieving more refined looking dashboards looking. Format quick filter font, size and background color. Quick Filter ‘Apply’ option: Changing values in a multi-‐select quick filter is a much better experience with the new ‘Apply’ button. Rather than having each selection such as a checkbox enable or disable try to immediate update the view, you can now define quick filters to not update the view until all options have been checked/unchecked and the apply button is pressed.
Web and Mobile Enhancements
Tableau 8.0 added the ability to author views and workbooks directly in the browser and mobile device. Tableau 8.1 adds a number of additional capabilities to help you explore your data more easily. This includes:
• • • • • • • • • •
Resizable Data window Turn mark labels on/off Change the size of marks Clear all formatting Pick color palette, stepped, reversed, transparency Rename Sheets Multi-‐select dimensions and measures (web only) View fit options Refresh all data sources Draggable quick-‐filter pop-‐ups (mobile only)
The Tableau Mobile App for iOS and Android also has these improvements: • Ability to change sites • Faster download of workbook lists • Selecting ‘remember me’ will automatically log you into the server • Support for Web Authoring in the Android App
September 2013
Tableau Software, Inc.
Page 3 of 5
Coming Soon in Tableau 8.1
Tableau Server
Tableau Server 8.1 adds new functionality to more effectively support enterprise-‐scale deployments and scale to even larger user communities. 64 bit: The entire Tableau product suite including Tableau Desktop and Tableau Server are available in 64bit and 32bit. This provides you with ample memory headroom for the Tableau application. Enterprise Single Sign-‐On via SAML: Tableau Server can be configured to delegate authentication to a SAML 2.0 identity provider. SAML is a standard protocol for authentication. IPv6: Tableau Server is supported on IPv6 networks. Automatic Login & Guest: When Tableau Server is configured to use automatic login to inherit the local Windows account identity to sign in, the ‘guest’ option is now supported as well. This means the system will try to sign in as the Windows account and if that specific user is not a named Tableau Server user the access will be granted to the individual as the ‘guest’ user. Automatic Gateway Failover: You can now configure Tableau Server to use an external load balancer as the entry point to the system. Prior versions of Tableau Server used only the built-‐in software load balancer that was a single machine entry point. By configuring your own external load balancer you can eliminate the single machine risk and improve the resiliency of your deployment Hostnames: Tableau Server can now be configured using the hostname of a machine rather than requiring static IP addresses. This applies to trusted ticket configuration and multi-‐node deployments.
September 2013
Reduced downtime for backups: Tableau Server 8.1 delivers a new safe backup option that requires significantly less downtime for backups than 8.0 High-‐Resolution Display optimizations: Users with high-‐resolution displays (such as Apple devices with Retina displays) will get much improved quality of display when accessing Tableau Server. Permissions enhancements: Project Leaders can now control default permissions for their projects which will be the default for all workbooks published into the project. The default permissions can still be fine-‐tuned by the publisher, but the starting point set of permissions is now customizable on a project-‐by-‐project basis. In addition, when assigning permissions to groups in Tableau Desktop and Server, groups can be expanded to see their members Extract Refresh Alerts: Users will see notifications if there was a problem refreshing any of their extracts. This ensures that users can easily get information to keep their data up to date.
Tableau Software, Inc.
Page 4 of 5
Coming Soon in Tableau 8.1
Data Source Enhancements
Tableau 8.1 provides a number of new capabilities to the data source options available providing with you more flexibility, performance and functionality.
Join Culling: A new option is available on database connections to control how joined tables are included in queries. When the database does not have referential integrity constraints enforced at the database, Tableau would always include all tables defined in the connection in the join clause. In some scenario’s this could negatively impact performance. The new Tableau 8.1 option allows you to specify that Tableau should assume the database tables have referential integrity and not include all the joined tables unless a column from a table is specifically referenced. Selecting this option can result in improved performance when using inner joins. DATEPARSE function: A new function is available to easily convert a string from one format into a date field. This function is available for data sources that support the DATEPARSE function including Data Extracts, Postgres, Oracle, MySQL, and Excel. Extracts for SAP BW: Tableau Data Extracts can now be created when connecting to SAP BW data sources.
SAP BW Characteristic properties: You can now control how the values of fields with multiple characteristic are displayed. This new option allows the Tableau visualization to show the key value, the text value, or both values combined for a characteristic field.
Google BigQuery improvements: Tableau can query a Google BigQuery data source using the native BigQuery language, BQL. This improvement enables support for BigQuery specific functions including Big Join and Regular Expressions.
Google Analytics Segments: The Google Analytics connector now supports Advanced Segments. Users can use Advanced Segments to pre-‐filter the data before returning it to Tableau.
Stored Procedure support for Sybase ASE, Teradata and SQL Server: You can now access the data produced by calling a Stored Procedure. You can discover Stored Procedures available and pass parameter values dynamically to the Stored Procedure to modify the resultset. Linux version of Data Extract API: The Data Extract API enables developers to directly create a Tableau Data Extract file. The API works with C/C++, Java and Python and can be used from Windows and now Linux. Data Modeling Improvements: Tableau’s automatic data modeling has been improved to make your data easier to use. Field names are converted to mixed case with spaces when possible. Some numeric fields are automatically converted to dimensions. Some abbreviations in field names are automatically expanded.
September 2013
Tableau Software, Inc.
Page 5 of 5
