O'Reilly logo

Mastering Tableau by David Baldwin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Working efficiently with data sources

This section will cover some basics of database tuning and ways to work efficiently with large data sources. Since the topic is more focused on data sources than on Tableau, no exercises are included.

Tuning data sources

If you are connecting to large data sources and are experiencing performance problems, a conversation with a Database Administrator (DBA) may be beneficial. Clear communication coupled with a small amount of database work could dramatically improve performance. The conversation should include database tuning points such as explicitly defining primary and foreign keys, defining columns as NOT NULL, and indexing. Each point will be discussed here.

Primary and foreign keys

Primary and foreign keys ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required