Tableau offers some "out of the box" forecasting options. And while these will not be as great as advanced machine learning approaches, they still can offer some guidance on how - for example - your sales might develop. Adding a forecast is simple: as long as you have a decently filled timeline (notice: I will... Continue Reading →
Relationships and (Data Source) Filters – Follow up blog post with Kirk Munroe
Following up on my >> previous blog post << I had the pleasure to virtually meet with Kirk Munroe and discuss the issues outlined in my posting. For those of you not yet familiar with Kirk, he is the author of "Data Modelling with Tableau." He is also a frequent guest on renowned Tableau blogs... Continue Reading →
How to do Year-over-Year comparisons in Tableau || Let’s have a (word about) date(s) (2/6)
For today, we will be looking at how to do year-over-year comparisons avoiding one of the most annoying effects when creating such a comparison out of the box. Using sample superstore, assume you want to compare two years and their difference. Your initial build will look like this: Next, you will be adding a quick... Continue Reading →
Changing date granularity based on filter (!) selection
For today I have an interesting one. Let's assume we are faced with a request where the circumstances allow you to show a maximum of twelve bars in your chart. Reason isn't relevant, let's just stick with that as a prerequisite. At the same time, you are tasked to provide the most conclusive yet granular... Continue Reading →
A bit about the order of operations – Part 2
Here is the second and concluding part of the mini series on diving into the order of operations based on workout-wednesday 2022 week 15 challenge by Erica Hughes. In Part 1 we rebuilt the solution that was in the challenge but this time our aim is to avoid using hard-encoding the maximum date or storing... Continue Reading →
