Saved views allow for quickly building and joining in subqueries. Let's walk through an example.
Start by building a query, in this case we'll build up a table about user facts that consists of
Next, select the 'Model > Save Query as View' in the menu and give the view a name. In this case, we've named it
Once a view is saved, it will appear as a new view in the field picker. It can be joined in to any other tables by right clicking the view name and adding a join path.
This view can be queried just as any other view in the database, see how it gets written as a subquery in the SQL here:
The saved view is now available on any tab within the workbook. It can also be promoted to the Shared Model by selecting the Promote from the workbook changes menu.