Let’s go deeper and see what happens when we break the cardinality, or in other words, use it in a way it’s not designed for. Also, it helps to understand everything a bit better. For those looking for more of an introduction to performance, you...
Now, let’s look into the second part of the Performance Options: Referential Integrity. What a daunting phrase! Sounds scary, but it’s actually simpler than the Cardinality. With this option, we tell Tableau whether it should expect values to have a match in the other table or...
It may happen that we work with really big tables that are not just a few rows but millions or even billions of rows. Tableau’s VizQL’s SQL (what a beginning of a sentence!) has to query all these tables, and that takes time. When we...
From here on out (at least for a few posts), we will have a look into the Performance Options of Relationships that are shown when we design a relation between two tables. If you have no idea what I am talking about, chances are that...
The new data model brought us the Logical Layer, from which we can draw specific tables without being forced to load the data from all the related tables. Remember, with traditional joins, all sheets that worked with that join had to load the full data...
There are quite a few tips and tricks out there for Relationships in Tableau; just not nearly as many as for every other topic in Tableau, which is a shame. Nevertheless, this article is supposed to grow over time, and we start with something very...
Until Tableau version 2020.1, whenever we had two or more tables that we wanted to connect with each other, we had to either join them or blend them. If you aren't sure about joins, please take a minute and get yourself up to speed. We...
.mejs-container .mejs-controls { background:#f7f7f7 !important; } Relationships work on what Tableau calls the Logical Layer, while traditional joins work on the Physical Layer. Let’s have a look at what those two layers actually mean and why they have their names. [video width="1920" height="1080" mp4="https://interworks.com/wp-content/uploads/2022/07/Relationships_en_A1-1.mp4"][/video] Tableau's Physical Layer So, the Physical Layer...
Joins—they are happening everywhere. That’s actually a cool tagline! And it’s definitely true. I haven’t encountered a data warehouse, a data lake or a BI tool that didn't include some sort of join somewhere. But I also know there are a lot of explanations about...
Question: How do I use the new map layers feature without having to join, blend or use relationships to connect my data? The answer to this question varies based on which version of Tableau you're using. To work with map layers with 2021.3 or earlier, reference...
Update: In version 2021.4, Tableau allows you to add map layers from multiple spatial data sources with very little hassle. The update means you no longer have to combine disparate data sources as suggested in this post. If you have 2021.4+, see Rowan's post here. If...
Pivoting without pivoting … it’s not a trap or a trick. This blog will take a look at how to use Tableau's relational data model to pivot data without duplicating records. When would you need this? This technique is mostly useful when you need to pivot...
Often, clients want to show a geographic area of their coverage for some services. This might be countries per region or sales rep, or it might be countries where the product can be sold, etc. Now in Tableau, you can imagine that you would have...
With the recent release of Tableau Desktop 2020.2 came the introduction of a brand-new data model. In versions prior to 2020.2, users would define joins and unions between physical tables in which Tableau would create a singular, flat table for analysis. Beginning with Tableau Desktop...
Question: We just upgraded to 2020.2 and when I view the data source screen, I no longer see my joins that were in my data source before. Where’d they go? Do I have to rebuild? With the release of 2020.2, Tableau has unveiled many new features,...
In its new version 2020.2, Tableau is about to release a quite revolutionary feature that will change the way we set up our data sources. Its impact is biggest where database admins have long found their way to solve the issue, and newcomers to data...
The new Tableau release 2020.2 is around the corner, and we are all excited about the new features it’s bringing. In this blog, we will be talking about the New Data Model. This feature can give you much more flexibility and change the way you...
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