Tableau 2020.2 has recently been released, and the feature I'm most excited about is Relationships. If you've ever have to work with a data source that contains a many-to-many relationship, or multiple one-to-many relationships, you would have encountered the problem of data duplication, and having to resort to LOD or COUNTD calculations to report measures … Continue reading Tableau – Understanding Relationships in the New Data Model – Part 1
An Use Case in Data Validation – COVID-19 Belgium
Download Tableau Workbook (2019.4) In the wake of the COVID-19 outbreak, many organizations, and the data community in general have spent a lot of effort to make relevant data available to a wider audience. From the beginning, I have mainly relied on the John Hopkins dashboard and the Worldometer website to stay up-to-date with the … Continue reading An Use Case in Data Validation – COVID-19 Belgium
Snowflake: Querying JSON
There's a lot of things to like about Snowflake, such as its ease of use, scalability and performance. What I also like are the many functionalities packed into its SQL dialect. One of my favourites I've encountered so far is the ability to easily query semi-structured data (e.g. JSON, XML). For this tutorial, we will … Continue reading Snowflake: Querying JSON
NBA Shot Charts Part 2: Building the viz in Tableau
Part 2 of this article describes how to create hexagonal shot charts in Tableau. If you're interested in retrieving the data yourself, you can go back to Part 1 to read how. You can also download the dataset from data.world using this link:Download dataset In Part 1 of the article, we left things off after … Continue reading NBA Shot Charts Part 2: Building the viz in Tableau
NBA Shot Charts Part 1: Getting the Data (Python)
Part 1 of this article describes how to retrieve the data to create NBA shot charts. If you're not interested in that, you can download the dataset I used from data.world and skip ahead to Part 2.Download dataset If you're a fan of the NBA and of data analysis & visualization, chances are you've come … Continue reading NBA Shot Charts Part 1: Getting the Data (Python)
Exasol – Dataviz Public Data Sets
Throughout this blog, I will be using several public data sets to build out some examples. I particularly like the ones hosted by Exasol, which you can find here: Dataviz - Exasol. Simply sign-up for it, and you will receive an username and password via e-mail, which you can then use to connect with in … Continue reading Exasol – Dataviz Public Data Sets
Tableau: Keep Sorting and Formatting when replacing fields
To ease myself into this whole blogging thing, we'll start off with a simple tip, one that I only found out a few months ago: replacing fields in a viz by double-clicking in an existing field. This will make Tableau remember any of the sorting or colour settings. What do we mean by this? Let's … Continue reading Tableau: Keep Sorting and Formatting when replacing fields
2020 – New Decade, New Blog
Starting a blog has been on and off my mind ever since I started using Tableau 5 or 6 years ago and when I was reading through all the great content written by some very smart people within the Tableau community. I believe in sharing knowledge, something which I always try to advocate at work … Continue reading 2020 – New Decade, New Blog