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...
With built-in Tableau integration, using maps couldn't be easier! Occasionally, however, we want to get creative and display more information within the map. Recently, I was asked, "When I have a parameter to choose which measure I want to view, how can I display a different color...
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...
Tableau Reader is a free-to-download tool that allows you to view packaged workbooks with full interactivity. It’s available for both PC and Mac users. Some organizations use Tableau Reader far more than they should while others might benefit by adding it to their options for...
Tableau 9.2 has many great features, but one of my favorite is Mapbox integration. For years, we've been able to build maps in Tableau, but we've been limited to a default set of maps. Now, with Mapbox, you can build beautiful, exciting maps for your audience...
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...
I recently found a data set that was perfect for testing out the new Data Interpreter in Tableau 9.2. While discussions about Syrian refugees were ramping up, I sought out data about the situation, which led me to the UNHCR page dedicated to this crisis....
As technology has evolved in the IT sector, many businesses are transitioning to newer, redundant systems. These include redundancy through a RAID on a server or storage area network (SAN), computing redundancy (RAM/CPU) through virtualization and redundancy due to manufacturers incorporating field-replaceable units (FRUs) to...
For a variety of reasons, businesses do not always tie their fiscal year to the standard calendar year. There are numerous explanations of why this might be beneficial to an organization, and they all seem to lead several of my clients to the exact same...
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...
Today, I ran into a Tableau issue that I couldn't solve through googling. Using SAML and attempting to connect to Tableau Server from Tableau Desktop, I wasn't given the option to enter a username and password. Instead, I received this message containing "errorCode=16:" Here's What Happened I was...
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...
If you embed your Tableau analytics dashboards through either a straight embedded i-frame or with the JavaScript API, upgrading your Tableau Server to 9.1 will cause some unexpected grief. But it’s fixable. After upgrading Tableau Server to 9.1, I was getting this error: Refused to display 'https://path/to/my/tableau/dashboard?:embed=y&:showVizHome=n&:tabs=n&:to...
Tableau does a great job of connecting to a variety of databases, but it sometimes needs help on the database end to get the results we need to make hot visualizations. One such example showed itself when connecting to Google BigQuery. The issue? Count distincts. BigQuery doesn't handle count distincts like one...
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...
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