Data Modeling Functions with Tableau Prep Builder
In the previous chapter, we were introduced to Tableau Prep Builder, Tableau’s product for preparing data and creating data models. We explored connections, filtering, cleaning, grouping, and several functions Tableau Prep Builder uses to make our modeling jobs easier.
Beyond extracting, filtering, and cleaning data, Prep Builder has functions for combining different data sources and reshaping data to optimize in the table format preferred by Tableau. This chapter focuses on extending the width of data by adding new columns through joins and extending the length of data by adding rows through unions. The chapter also covers consolidating fields from columns and adding new fields from data in rows. Additionally, we cover the strategy and technique for aggregating data to the proper level for analysis.
In this chapter, we’re going to cover the following main topics:
- Adding additional data through unions –...
