Explore relationships in your data

When you create an exploration, you can start from a data source. A starting points page is displayed with suggestions for how to get started.

You can type a column name that appears in your data source. Or, you can click one of the suggested columns that the system identifies as interesting. If you're not sure which column to start with, click Skip - show me anything to see a relationship diagram with some suggested starting point visualizations.

Starting points page showing suggestions for how to get started

In the relationship diagram, the column that you start with is the prime focus and is represented by a dark blue node. Related fields are represented by purple nodes. Lines connect the nodes and represent relationships. The thickness of the line indicates the strength of the relationship.

Example of a default relationship diagram that shows primary relationships

The strongest primary relationships are displayed by default and are the direct relationships between the prime focus and the related fields. Secondary relationships are the relationships between other fields directly or indirectly related to the target.

To view both primary relationships and secondary relationships, select the Secondary relationships check box under Edit diagram.

Example of a relationship diagram that shows both primary and secondary relationships

The relationship diagram plots these fields based on a statistical evaluation of related items. The relationship diagram is not a picture of the data model. However, the model might be an influencing factor in the analysis. To improve performance when there are many rows in the data source, the analysis is based on a representative sample of the entire data.

You can interact with the relationship diagram by selecting a node that you are interested in. As you do, the list of suggested starting point visualizations to the right of the diagram updates to include the nodes you selected. You can also use Ctrl+click to select multiple nodes.

Click Reset to original if you want to reset the scope and view of all the fields in the relationship diagram to the default setting.

Suggested starting points

Suggested starting point visualizations are displayed as thumbnails beside the relationship diagram. Select single nodes or multiple nodes in the relationship diagram to generate these visualizations.

Click a visualization if you want to add it to your exploration and view it at the same time. Click the plus icon Add to exploration icon on the starting point visualization to add it to your exploration and maintain the current view.

Suggested starting points