Tableau Dashboard Performance Series: Tip#13: Indexing

Indexing, my old friend.

Yes, I used to do all sort of DB stuff and I had my fun with Indexing. BITMAP, clustering, and all that other techie stuff. I haven’t needed to do that for the last 7 years, which has been great.

HOWEVER, that doesn’t mean that we should have Indexes in the back-end. Now, with the newer key-pair concepts that are now available in Databases (some databases are completely based on this approach), the requirement for your analytical data to be indexed in a organized manner reduces.

You should still know what indexing is. It is having the ability to be able to look up anything easily (yes, just like those index cards in the library) and if we can allow for our Database to have index cards, wouldn’t that make things easier?

EASIER SAID THAN DONE.

This type of task is NEVER going to be something that an analyst will have the option to do. But, being aware of such things makes you more informed. And that means, you can have more informed discussions with your band-end folks. HELP THEM HELP YOU 🙂

Published by

Lovekesh Babbar

Speaker on topics related to data, analytics and digital transformation

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s