Fun trivia fact about August you probably learned at school: the month was named after the Roman Emperor Augustus by, well, himself! Actually, all of the English language month names are carried over from Roman naming conventions. I'm a sucker for history, and month names...
Last year's Fantasy Football saw some wild rides, with early favorite Christian McCaffrey injured early and Cooper Kupp going absolutely HAM in PPR especially. COVID didn’t impact the season as much as it could have, fortunately and we’re not likely to see any further major...
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...
Snowflake have developed a simple command line tool that can be used to investigate snowflake connectivity issues. This tool's full name is the Snowflake Connectivity Diagnostic Tool, however it is more commonly referred to as SnowCD. If you are seeing connection issues with Snowflake, I would...
Have you wondered how you can venture into the land of data science without being a data scientist? Most of us get intimidated with this idea of writing thousands of lines of code to build a machine learning algorithm. Well, that was true maybe a...
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...
In my last blog, I showed you how to iterate through a variable to bring multiple tables into the raw layer of your data warehouse. Today, I’m going to build on that concept by creating a DIM table and performing an UPSERT. Now, to start,...
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...
Snowpark for Python is the name for the new Python functionality integration that Snowflake has recently developed. At the Snowflake Summit in June 2022, Snowpark for Python was officially released into Public Preview, which means anybody is able to get started using Python in their...
LODs (Level of Detail expressions) are not the easiest topic in Tableau, though they are a glorious one! It took me some time to get the hang of it, but today I don’t want to miss them. What they do – in a nutshell –...
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...
Snowpark for Python is the name for the new Python functionality integration that Snowflake has recently developed. At the Snowflake Summit in June 2022, Snowpark for Python was officially released into Public Preview, which means anybody is able to get started using Python in their...
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...
The Eyeo Festival can probably be best described by the way in which it was named, which you can find in a Medium article from one of the festival's founders: “I came up with the name, Eyeo, which doesn’t mean anything specific, but riffs on the...
Of the many useful functions available in Snowflake, one of my favourites is the GENERATOR function. This function allows you to create rows of data from nothing and can be useful in many ways. Any time you don't have physical data to get you started...
A video replay for this webinar is available at the bottom of the blog. In this webinar, we go over how to think like a consultant to elevate your dashboarding experience into something enjoyable for both devs and users alike. The Three Principles There are three cornerstones of...
I certainly can’t speak for every InterWorker around the globe, but July was a scorching hot month for us in InterWorks' home state of Oklahoma. The highest we saw at our satellite office in Oklahoma City was somewhere around 114 degrees Fahrenheit (or somewhere around...
.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...
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...
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