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 ...

Get Mastering Tableau now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.