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 and demonstrate the impact of using both versus using relationships.
In this chapter, we’re going to cover the following topics:
- Opening relationships to join at the physical layer through database joins
- Geospatial...
