In our last guideline, we’ll revisit another tip on how your dashboard’s layout can impact performance: "Fix dashboard size relative to end-user consumption. Automatic sizing is less efficient than specifying dashboard size." It’s not all about size … though I’ve heard it’s mightily important. Automatic Sizing There is a...
We are onto our last category of the Tableau Performance Checklist, Dashboard Layout. For our next guideline: "Limit the number of worksheets on a dashboard. If you have more than four visualizations on a dashboard, strongly reconsider." Let’s begin! Dashboarding or Dash-boring The allure of putting as much information on...
Here’s the second item under Local Computations: "Table calculations are powerful, but they can be slow. They are dependent on the local computation engine and can require substantial memory." Let’s get started. Table Calculations Table calculations are computations that use the values in the entire table and can restructure...
Here’s the first guideline from the Local Computations category: "Even if a workbook is published to Tableau Server, local computations still impact performance. Leverage the power of Tableau Server whenever possible by limiting local computations such as groups, hierarchies, reference lines, table calculations and blending." Let’s get...
Who doesn’t love efficiency? We are finishing up with the rendering category today by returning to custom shapes. Let’s get started: "If using custom shapes, use transparent background PNGs instead of JPGs. Views will render cleaner, and shape files will take up less space." Didn’t know we’d get...
Let’s take a look at our next guideline from the Rendering category: "Minimize the file size of any images or custom shapes where possible. As a general rule of thumb, keep images under 50kb." Let’s get started, shall we? Images & Custom Shapes In regards to rendering, images and...
Let’s take a look at the next item on our rending category. "Limit the use of detailed text tables with lots of marks." Ah yes, the fabled Text Table. Mark Counts Let’s start this discussion by reviewing mark counts. We covered this in the previous Rendering article in the...
The first item in the Rendering category is: "Avoid high mark counts. More marks = longer rendering time." Let’s jump right in on this one. Mark Counts Marks are the points, plots or symbols on your visualization. They can be the bars in your horizontal bar graph or the...
Here’s the next item on the Performance Checklist: "Avoid row-level calculations involving parameters." Let's first take a look at what row-level calculations are. Row-Level Calculations Row-level calculations, also known as record-level calculations, operate on every record in the underlying data. An example of a row-level calculation is an IF...
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...
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...
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