In this blog post I will explain what a view is and how to create one, then I will discuss materialized views and secure views. While views and materialized...
When I study, I like to create tree diagrams, colourful mind maps and really anything that will help the information sink deeper into my memory and understanding. While studying...
Snowflake offers five default roles. It is important to understand the default Snowflake roles as they can help you managing access control to data within your organisation. These default...
This week, a customer asked for advice on how to convert seconds into HH:MM:SS in Tableau. They had created their seconds field by using a datediff calculation (that is,...
Working with filters and FIXED Level of Details Calculations (LODs) in the same view can be challenging. This is due to Tableau's order of operations. In general, if something...
This week, I learned how to create a pattern bar chart (also known as textured bar chart or pattern-filled bar chart). My colleague Emma and I were looking into...
Would you like to get rid of the space between title and sheet on your Tableau dashboard? Follow this blog to achieve your goal. Here is the situation: while...
Being able to distribute sheets evenly in your dashboard is a handy skill. For instance, it can be useful whenever you want to show a set of KPIs at...
I want to find the distance between a restaurant and all the customer locations. I have two datasets: Dataset A contains just one row with the address, latitude and...