Before doing any work in Tableau, we must first connect to the data we'll be working on. In the first recipe in this book, Connecting to data, we learned how to connect to a data source. In this chapter, we'll build on that knowledge to become more skillful at manipulating, joining, unioning, and transforming data sources. In the last recipe of this chapter, Preparing data, we'll also address the topic of data preparation and getting our data ready for visualizing and further analysis.
In this chapter, we'll be using multiple datasets. In the first recipe, Joining data sources, we'll be using two datasets, Public_Schools_1.csv and Public_Schools_2.csv, which contain data on Boston public schools for the school year 2018/2019. The dataset originally comes from Kaggle's official site. In the Adding a secondary data source and Data blending...