Use View Data Model to Understand the Data Source

View Data Model lets you see the structure of your data source while in the context of the viz. Rather than switching back and forth between a viz and the data source tab to verify how tables are related, you can open a dialog while on a sheet tab. Like the calculation editor, this dialog allows you to interact with the viz with it open.

Turn on View Data Model

To access the View Data Model dialog, open the Worksheet menu and select View Data Model.

A dialog appears that shows the data model of the active data source as a visual aid while creating visualizations.

The Tableau authoring UI with the View Data Model dialog open

With Hide Unused Tables turned on, adding and removing fields in the viz will automatically update the View Data Model diagram. This can be especially useful for understanding field-level relatedness in data sources with multiple base tables(Link opens in a new window).

Because View Data Model doesn't currently show which fields belong to each table, it may be useful to organize the Data pane by table rather than by folder(Link opens in a new window) while using this feature.

View Data Model is read-only and doesn't allow you to inspect details of the data model (such as relationship clauses or performance option settings for a relationship, or the underlying physical layer of a table). Those details are available only on the Data Source tab.

Work with multiple data sources

View Data Model displays the active data source. Which data source is considered active depends on if there is a field in the viz or not.

  • If the sheet tab has at least one field in use, the dialog will always show that data source regardless of what data source is selected in the Data pane.
    • The data model can't be displayed for cube data sources or worksheets with active data blending.
  • If the sheet tab is empty, the view data model dialog will display whatever data source is selected in the Data pane. You can toggle between the data sources to view each data model in turn.
  • If there are map layers involving multiple data sources, whichever map layer is active determines which data source is active.

Hide Unused Tables

With the Hide Unused Tables toggle, you can change between seeing the entire data source and a pared down version that only shows tables in use in the viz. In this context, in use means the table either:

  • has a field in the viz
  • is a pass-through table that is used to relate fields used in the viz from tables with no direct relationship between them.

the view data model dialog showing three tables when only two fields are in use in the viz

In this case, the viz consists of two fields, one from the Inventory table and one from the Subcategory table. The Products table is present when Hide Unused Tables is on because the Inventory and Subcategory table are both related to Products but not directly to each other. Products is a pass-through table and is required in the data model diagram.

Note: Hide Unused Tables isn't available for blank worksheets.