Tableau Hacks: The Forklift
In the past, Tableau used to have a maximum number of 16 dimensions on the Rows shelf. Whilst it is generally not recommended to create tables that exceed that number anyway (there are other tools for that), Tableau has upped the limit to 50 and one would hope that this would be enough for anyone. […]
Exploring Football Transfer Window Spending with Tableau in 2023
Last year, I took a look at the Summer 2022 transfer window for the top five leagues in Europe. The main takeaway was that Premier League clubs are pulling away from the rest of Europe when it comes to their spending power. But has this trend continued a year on? I’ve once again used Tableau […]
Which Snowflake Table Type Should You Use?
As Snowflake has developed over the years, we have seen the introduction of more and more table types, and it isn’t always immediately clear what the differences are and when they should be used. Today, I hope to shed some light on this by outlining the following table types and their nature: Permanent tables Temporary […]
Tableau Hacks: Advanced Apply, Reset and De-Highlight
In the previous Tableau Hacks blog, we discussed adding Apply and Reset buttons to our dashboard filters, as well as the trick to de-highlight these buttons for a better user experience. In today’s blog, we will look into some more advanced options, such as customising our buttons by using different mark types without multiplying the […]
Tableau Cloud (SCIM): Unifying the Dimensions
Get ready to embark on an epic quest as we unravel the complexities of user provisioning and management across multiple systems and domains. Brace yourself for the introduction of Tableau Cloud System for Cross-Domain Identity Management (SCIM). Prepare to experience the thrill of simplified user onboarding, consistent access controls and attribute synchronization. SCIM will become […]
Tableau Hacks: Basic Apply, Reset and De-Highlight
If you build any dashboard with more than a handful of filters, and your dataset is fairly large, changing and applying multiple filters can be painfully slow since you are waiting after every filter change for the data to load. In these cases, you might wonder why Tableau doesn’t provide an easy way of applying […]
Snowflake Dynamic Tables: Automatic Declarative Data Transformation Pipelines
Imperative vs. Declarative Programming There are essentially two primary approaches to coding: imperative and declarative. To put it simply, these approaches determine whether you instruct the compute engine on how to perform the program’s tasks (imperative) or what outcome you want to achieve (declarative). My colleague, Mike Oldroyd, recently shared the article A Better Alternative […]
Optimizing Tableau Relational Models With Row-Level Security: Performance
In a previous installment, we kicked off this blog series by materializing our policy and entitlement table and removing all physical joins in our data source. We are now left with a large volume of records due to combining users with what they’re entitled to. To address this growth, we need to profile our materialized […]
Tableau Hacks: The “Cloth Hanger” Method
Sometimes, we want to calculate summaries of our data that cannot be calculated at row level, but need to be calculated at the level of aggregation in our view. We can use Level of Detail calculations for some of these calculations. For example, if we want to calculate Averages of Sums. Other times, we need […]
Learn ThoughtSpot With Me: The Basics
This post is going to be my first of a 3-part series called “Learn ThoughtSpot With Me.” As an Enablement Consultant, I teach technical things. What I’m most passionate about are data analysis, trends, and visual analytics. I hope you enjoy the series and look forward to hearing your comments. Let’s get started. Sharpen Your […]