To best use ThoughtSpot, we need to have a good understanding of the data structure being used. The best way to work with that data is in ThoughtSpot’s data pane. In the data pane, we need to connect to a data source (in our case...
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...
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...
Relationships in Tableau have grown older – it's been almost two years now when they started seeing the light of day. And still, even after all that time, there are many questions around this data model, be it within the Tableau Community, be it in...
Data in the real world is a lot messier than we’d imagine it to be. More often than not, working with data will involve multiple sources. For example, you might want to combine two tables, like sales from subsequent quarters. In Tableau Desktop, this is made...
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...
Recently, one of my colleagues had an interesting issue with a client’s request. The client they were working with was getting a file in a specific structure from their source system. This file was, of course, only available as an Excel export. For simplicity’s sake,...
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...
It’s no secret that Tableau Prep is a game changer for those looking to clean, explore and connect their data sources together. There are myriad join options, from your traditional left, right and inner joins to more advanced options such as Left Unmatched Only, which...
Note: A big thank you to Carl Allchin and Jonathan Allenby for initiating the Preppin’ Data project for our community. Hunker down, folks. It’s time to prep some data. Welcome to my submission for the first week of the Preppin’ Data project. For beginners, the idea...
I rarely ever receive pristine data, and I’d wager that’s true for most of us working in data analysis or business intelligence. Data can come to us from dozens—if not hundreds—of sources, and it certainly requires some preparation to make it useful. One of the...
This is a question that came up in a class I taught to a commercial airline who were looking at their web analytics data, I also taught it in a colleague’s class dealing with car parking at airports: “How can I compare a metric against the same...
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