Outputting our data models to files
The first option we will look at is data output to a flat file. This is a great option when prototyping and when we are still in development and want to check our progress. The other use case for the file output type is when we are creating a data model for our own analysis and do not have a plan to share the data model more broadly.
The comma-separated values (CSV) and Microsoft Excel (.xlsx) file outputs serve very similar purposes. The CSV values option is the more lightweight option, meaning you can use it if you don’t use Microsoft Excel.
The Tableau Data Extract (.hyper) option will load your data into Tableau’s high-performance analytical data store, Hyper. This is the best option when we are creating a data model for personal analysis. The Hyper file gives us the balance of low maintenance with the fastest query performance.
Before beginning the exercise in this section, please open the Tableau Prep Builder client and...
