Summary
In this chapter, we learned about extending the data in the data model through unions and joins. Unions are a method of adding additional rows to our data model when two or more data sources have the same fields. Joins are a method of adding additional fields to our data model by linking one or more fields between data sources.
Additionally, we learned about pivoting columns to rows. Data sources are often in the format of crosstabs, which don’t work well with Tableau data models. Tableau likes the data to be in a table format. Pivoting the rows of a crosstab format neatly into columns allows Tableau to map the columns into fields for data model creation for easy analysis.
In the final section of the chapter, we learned about the level of detail of data sources and how we can aggregate the data source to join with other data sources at the same level of detail.
In the next chapter, we will add to the foundational knowledge we learned in this chapter by exploring...
