In this chapter, we covered how to prepare our data for effective use in Tableau. We covered Data Interpreter and pivots to clean our data source. We then used the legacy Jet driver to shape the file and schema.ini to resolve data type issues. Next, we covered pivoting the values into a single column. We also used unions to combine different data sets, and joins to combine records from different tables using common fields. Lastly, we used blends for data mashups.
In the next chapter, we will see how calculations can be used in many ways.