Tableau Dashboard Performance Series: Tip#30: Database Type

This one is hardly in your control. In fact, far from it. Choosing a DB type or a database vendor is a pretty big decision and organizations typically don’t change the DB vendor at least for 5-10 years. (longer in the past)

But, with newer technologies hitting this space every year, I expect that this can possible change < 5 yrs on average.

Keep abreast of newer technologies and become involved in these decisions, if possible.

Tableau Dashboard Performance Series: Tip#29: Encryption Layers

Encryption is an interesting topic. Every time, I say “Encryption” in a meeting, 9 out of 10 people tune out and the one remaining person gets a little too excited. Yup.

Anyway, for that 1 person still reading this, I would just say that encryption matters and most of the time when any encryption is put on top, there is an overhead. Having said that, there used to be a concept where many applications would terminate SSL (a way of encrypting data) at their firewall level since anyone inside the corporate network would be considered safe.

That particular thought process is evolving very quickly. There is now concepts of “Zero Trust Model” which in simple terms means, trust no one and keep checking if the right levels of security/governance is implemented every chance you get.

Which basically means that you can’t do much about turning the encryption on/off at your server and/or machine level (not that I was advising you do that anyway)

But, knowing why such things are there is a useful thing. Because the more informed you are, the better decisions you will make (elsewhere, in this case)

Tableau Dashboard Performance Series: Tip#28: Data Gravity

Again, one of those topics that you can’t do much about. But, you knew that already. You are still here because you like to learn more and be more informed.

So, on the topics of Data Gravity, the concept simply means that closer you (consumer of analytics) and your application (your analytics server in this case) are to your data (your Data Warehouse), the less of a performance issue you will experience. Think of your request from your browser traveling to your server and then your server basically making a call to the data sources. The less the “# of calls”, the better it is. Also, the less the amount of data your calls are retrieving, the better as well.

If your organization is moving to the cloud (or in the process of doing so), it is important that sometimes these data sources are also moved to the cloud at the same time. You would think its obvious, but unfortunately, that doesn’t always happen. I know, beats me !!

Tableau Dashboard Performance Series: Tip#27: Network Latency

No too different from the “Data Gravity” topic we discussed here in the sense that we want the amount of time spent in retrieving the data to be minimal. From a network perspective, we don’t our network to be the reason why we are getting performance issues.

This doesn’t happen a lot in my opinion, but it does in certain cases.

Think about your server location. What if you have a central server location in Seattle but then your users are all over the world. Maybe, that works if 90% of your user population is in US but if you are truly serving your customers all over the world. You may need to look into having multiple servers over different geo-locations. You also may want to test how your servers work over VPN? Same applies to when you move to cloud.. so on and so forth.

This really may not be anything your are directly concerned about but if you are bit more informed now than you were before reading the blog, my work here is done 🙂 (at least partially)

Tableau Dashboard Performance Series: Tip#26: Hardware for the server

This happens to fall in the last category where there are certain items that are completely out of control for business teams.

However, having additional information hasn’t even hurt anyone. So, if time and again, you just need to ask your IT counterparts if the servers has enough hardware to run what you need, it is never a bad idea.