Next up on the list of ways to make your dashboards be the best they can be, we take a closer look at blended calculations: "Limit blended calculations. They require sequentially querying multiple data sources and can be time-consuming. Where possible, create a view on the...
Let’s examine the following item on the checklist: "Use calculated fields carefully. Think about the data type as you code the calculation. Number and Boolean > date > string calculations when it comes to performance." This is another item that can quickly get you into performance trouble...
Today we’re examining the following guideline: "Watch for useless clauses, e.g. ORDER BY. Tableau is going to re-sort the data once loaded anyway." Let’s get started! SQL Overview SQL, or Structured Query Language, is designed for managing data within a relational database. It is essentially composed of two parts: Data...
Currently, we’re going through the best ways to employ custom SQL and what to avoid. Here’s what we’ll cover today: "Avoid parameters in custom SQL in Tableau. Tableau wraps the custom SQL in a subquery that many databases don’t handle well. Consider building a view in the...
The rule that we’ll cover today is: "Limit custom SQL in live connections as they can be inefficient. Where possible, create a view on the database server to implement your custom SQL and connect Tableau to your view." In other environments and in other tools, using your...
The final topic in Filtering addresses when and when not to use user filters and how it can slow down your visualization: "Don’t be lazy with user filters. Security by user filters can impact performance on Tableau Server as the server cannot share connections and query...
I was plugging away at various tasks yesterday when I received a fun notification from Windows: “You have low disk space on C:” This isn’t unusual, as I have an SSD on my C: drive and have to clean it up every now again. I was surprised...
Earlier this week, Tableau Software published a security advisory detailing a security vulnerability affecting Tableau Server. This vulnerability enables a user to impersonate a different user, which could allow them to access sensitive dashboards/data or to perform actions that they normally wouldn't be able to perform. Affected versions of...
We’ll continue on with the next item in the Filtering category: "Replace quick filters showing 'Only Relevant Values' and high count of quick filters with dashboard filter actions. They will cascade as your user interacts, and they perform faster." Cascading filters? Sounds exciting! I Got 99 Problems … As we...
The next guideline in our list of Filtering tips is: "Keep range quick filters simple. The more complex the range, the slower the query." Sound exciting? Let’s go! Quick Filter Overview Quick filters are a quick and easy way to add interactivity to your visualization or your dashboard, either...
The next item in our Filtering checklist is: "Avoid quick filters or actions that drive context filters. These require reloading the context table and should be avoided wherever possible." There’s a lot to digest there, so let’s get started. What Is a Context Filter? The filters that you add...
The next item in our Filtering checklist is: "Avoid high-cardinality quick filters (multi-select or drop-down lists). High-cardinality quick filters are slow to load and render." Let’s jump right in and see how high cardinality in your quick filters can negatively impact performance. What is Cardinality? In SQL, the cardinality...
Speed counts, people! Today’s report consumers expect their dashboards to run as fast as a web page. Now that high speed internet is the standard in business, that’s a lot to compete with. This is why it is essential to optimize each and every dashboard...
Quick! Minimize those quick filters! The Tableau Performance Checklist is a guide to assist you in creating the most efficient and fastest dashboards and visualizations possible. The list is drawn from the collective experience of our award-winning Tableau professional services team. We’ve divided the checklist into...
Next, we'll explore the sixth point under the Data section of the Tableau Performance Checklist: “Use extracts wherever possible to accelerate performance. Hide unused and confidential fields. Roll up data granularity by pre-aggregating or filtering. Break hierarchies to only visible dimensions” There are many reasons to utilize extracts...
So, you’ve finally worked out your ETL process using Alteryx and have it exporting a shiny new TDE file. Now what? Using the Run Command tool in Alteryx Designer you can automate the publishing of that TDE to Tableau Server, and here’s how you do...
So, you’ve finally worked out your ETL process using Syncsort DMExpress and have it exporting a shiny new TDE file. Now what? Using the Custom Task in DMExpress, you can automate the publishing of that TDE to Tableau Server, and here’s how you do it: Step...
Today I'm going to give you a quick run through of the updates and changes you will see in Tableau Server 9.0 from an administrator’s perspective, and what has changed since Tableau Server 8.3 Visual Differences Firstly and most obviously are the visual changes. Tableau has completely...
This post is on how to make use of TDS files to easily share metadata about a data source with others. We will be digging into the fifth point in the data section of the Tableau Performance Checklist: “Create a published TDS file for your business...
Rarely do you have a data connection that has only the data you need. Typically, we end up with data connections that include many columns that are unnecessary for our analysis. In the early phases of your analysis, it can be tough to judge what...
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