Data pane

The Data pane is the central pane that shows your data in the Prepare room.

Use the Data pane to view, organize, edit, and prepare datasets for visualizations.
Table 1: Options on the Data pane

Option

Description

Data source selection

Lists the data sources connected in the current session. You can use the list to toggle between datasets and to add datasets.

Data filters

Lists the filters that are applied to column data. You can edit or remove the filters in the list.

Grid

Select to display data in columns and rows. All rows are displayed.

Facets

Select to display only unique values in data, in columns. (Repeated values in columns are not shown.) Using facets can be helpful when a dataset includes many repeated values.

Show/Hide columns

Select to show or hide columns in a dataset.

Calculation

Select to add calculated dimensions or measures.

Combine

Select to merge or append data to a dataset. You can merge data from multiple datasets into the current dataset, but the data must be compatible. You can append another dataset to the current one. Data in common columns is appended to the current dataset, and data in unique columns is added in new columns.

Refresh the document data

Select to refresh the dataset(s) used in the document.

Undo

Select to reverse the last action.

Redo

Select to repeat the last action.