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

Complex joins

The terms simple join and complex join mean different things in different contexts. For our purposes, we will consider a simple join to be a single join between two tables. Every other instance of joining will be considered complex.

Let's look at a star schema as an example of a complex join:

Complex joins

A star schema consists of a fact table referencing one or more dimension tables. The fact table typically contains measures, whereas dimension tables, as the name suggests, contain dimensions. Star schemas are an important part of data warehousing, since their structure is optimal for reporting.

The star schema pictured is based on the Adventure ...

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