Data Modeling with Tableau

9

Building Data Models at the Physical Level

Tableau relationships are the preferred way to bring multiple tables together in Tableau Desktop. We learned about relationships in Chapter 8. There are some cases where you, the data modeler, need to be one level deeper. For these use cases, we must go to the physical layer of the data source. We can get to this level by creating a join or using custom SQL.

When we create a join, Tableau creates a new table that results from the joining of the two tables. The structure of the new table depends on the type of join we use. We will be studying the four join options in this chapter. These are left join, right join, inner join, and full or outer join. In addition to joins, we will explore custom SQL statements ...