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...
The last post in this series showed you how to use the Wildcard union and the Manual union to join four years of sales data that was stored in four different worksheets. In this post, you’ll see how the cleaning step can be used to...
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...
With the release of Tableau Prep in April 2018, analysts have been given an incredibly valuable tool for their analytical kit. Considering both performance and ease of use, prepping your data before it enters Tableau Desktop has many benefits. I’ve created the following walkthrough to...
If you are not already familiar with cross joins, you may want to read through my first post in this series for another use case. In this article, I will further define and expand on cross joins. What's a Cross Join? Sometimes we are stuck working with...
A common question that often comes up in trainings is: “How do I utilize the Pivot feature in Tableau to make building charts easier?” What does it mean to pivot data? A pivot is a transformation of data structure from a wide view (many columns) to a...
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
