How we Reduced 98.9% Load Time for a Tableau Viz that used Multiple OR Conditions?

 If you don’t write efficient calcs, it can slow down your dashboard. 

In this article, we will show you how to speed up OR statements with multiple conditions in Tableau.

You can also look this video to see how we did it!

The Workbook Loaded in 41 Seconds

The dataset had information about flights.

We wrote a simple calculation to compare a value against a list of values:

OR Calc

The workbook took 41 sec to load.

The above calculation has a series of conditions which get evaluated one by one.

The more conditions you have, the more time it takes.

The more rows (data) you have, the more time it takes.

We Modified the Calculation to use ‘IN’ Function

IN statement directly compares a dimension against a list – much simpler & faster.

So, we modified the calc to use IN statement instead of OR statement.

IN Calc

Now, the same workbook took 29 sec to load in Tableau– that is 29% lesser time.

OR statement

To improve further, we switched to an Extract connection.

IN statement

Then, it took just 0.43 sec – 98.9% lesser time!

To Conclude

When you want to compare a value against a list of values, IN function would perform better than OR function.

At Perceptive Analytics, we build data solutions that grow with your business. From visualization to automation, we help transform data into insight and action.
Our services include Tableau consultant, excel consultant, and Power BI development services, tailored to your business needs.

Comments

Post a Comment

Popular posts from this blog

Implementing Parallel Processing in R

Image
If something takes less time if done through parallel processing, why not do it and save time? Modern laptops and PCs today have multi core processors with sufficient amount of memory available and one can use it to generate outputs quickly. Parallelizing your codes has its own numerous advantages. Instead of waiting several minutes or hours while a task completes, one can replace the code, obtain output within seconds or minutes and make it efficient at the same time. Code efficiency is one of the most sought abilities in the industry today and not many people are able to use it. Once you learn, how to parallelize your code, you will only regret that why didn’t you learn it sooner. Parallelizing your codes in R is simple and there are various methods and packages. Let’s look at some of the functions available in R lapply() and sapply() functions lapply() function is used to apply a specified function to the vector or list input. The output of this function is always a list. lapply(1:5...
Read more

Basic Statistics in Tableau: Correlation

Image
Statistics in Tableau Data in the right hands can be extremely powerful and can be a key element in decision making. American statistician, W. Edwards Deming quoted that, “In God we trust. Everyone else, bring data”. We can employ statistical measures to analyze data and make informed decisions. Tableau enables us to calculate multiple types of statistical measures like residuals, correlation, regression, covariance, trend lines and many more. Today let’s discuss how people misunderstand causation and correlation using Tableau. Correlation and Causation Correlation is a statistical measure that describes the magnitude and direction of a relationship between two or more variables. Causation shows that one event is a result of the occurrence of another event, which demonstrates a  causal relationship between the two events. This is also known as cause and effect. Types of correlation: 1 → Positive correlation. -1 → Negative Correlation. 0 → No correlation. Why are correl...
Read more

How to Perform Hierarchical Clustering in R

Image
Over the last couple of articles, We learned different classification and regression algorithms. Now in this article, We are going to learn entirely another type of algorithm. Which falls into the unsupervised learning algorithms . If you were not aware of unsupervised learning algorithms, all the machine learning algorithms mainly classified into two main categories. Supervised learning algorithms Unsupervised learning algorithms All the classification and regression algorithms belong to supervised learning algorithms. The other set of algorithms which fall under unsupervised learning algorithms are clustering algorithms. In fact, the foremost algorithms to study in unsupervised learning algorithms is clustering analysis algorithms. Today we are going to learn an algorithm to perform the cluster analysis. We have a decent number of algorithms to perform cluster analysis; In this article, we will be learning how to perform the clustering with the Hierarchical clustering algorithm. Loo...
Read more