Tableau Conference 2019 – Personalized Playlist Creator

Ok, you had a great time at TC19 and you just can’t stop raving about it with your co-workers and they watch to watch some of that goodness. Looks like, you also missed some sessions because there was too much goodness happening at the same time.

Back home, ready to watch, but not sure where to start?

Continue reading Tableau Conference 2019 – Personalized Playlist Creator

Best Practices for Dashboard Performance – TC19 version

  • Do you have a problem with your tableau dashboards loading slowly?
  • But, not sure where you start?
  • What are the things I should try to optimize first?
Continue reading Best Practices for Dashboard Performance – TC19 version

Tableau Dashboard Performance Series: Tip#44: Creating the right Map

If you are trying to find what zipcodes are the ones with highest volume of sales, would the following image provide you the info

OR, would this one?

Both options show the same amount of marks, which is about 40K data points

It turns out that creating polygons to draw the zipcode boundaries is a bit more intensive than creating circles. I am not exactly sure if this will matter for all of you, but its a point worth noting.

My advise for this one would be to limit “filled maps” for county/zipcode level maps in the cases where you want to highlight density but use “density maps” instead.

However, when you are looking at maps at the State/Region/Country level, this might be a moot point

Tableau Dashboard Performance Series: Tip#41: Utilizing Tableau Native Connectors

Ok, this one seems obvious. However, since I am writing about it, you can guess, that it’s not.

The guidance I would like to give you is to utilize the Tableau provided connectors in cases where it exists. For some of you data-savvy folks, you might have a very good understanding of ODBC connectors and in many cases, you might already have ODBC setup on your machines to connect.

We highly recommend utilizing the option that Tableau provides when you click on the name of the vendor

So, in the example of Oracle, we would want you to use the “Oracle” option and NOT THE “ODBC” option

Tableau Dashboard Performance Series: Tip#11: Number of Filters

The number of filters in a dashboard can have a direct impact on your dashboard performance.

Think of each filter as another query for your dashboard. Let’s take the example of our dashboard

In the above example, every user will easily understand that each sheet may potentially cause a separate query to the data source. However, what’s not so easy to understand is that each filter will also cause an (potentially) additional query as well. So, instead of running 6 queries, we are running 14 in the above example.

At the very least, we should try to reduce the number of queries by reducing the number of filters needed.

Tips

  1. Remove unneeded filters
  2. Remove filters that are already in another sheet and are easily clickable (in the example above, I may not remove country as a filter since its hard to find small countries on the map). However, I might remove Ship Mode and Product Sub categories as filters
  3. You can also reduce queries by creating different types of filter. (Read more in the linked post)