Viewing the Imported Dataset

Once a dataset is imported, use any of the options listed below to view the data.

During the initial data import, a data structure is created; the data type of each column is inferred. The results are displayed in the right-hand Details panel.

The Details panel is divided into two panes:
  • Dataset Overview: lists all the available columns under separate Measures and Dimensions headings in the Output tab. You can change a column's inferred type from a measure to a dimension or vice versa. Alternatively, you can view a list of all available columns in the Columns tab.
  • Details: includes information for a given column, such as histograms (rectangles indicating frequency of data items in successive numerical intervals), and the column's inferred Data Type.

    Numerical or textual histograms are displayed under Data Distribution.

    Text histograms are horizontal, and the values are clustered by count. The number of clusters can be adjusted by dragging the slider displayed above the histogram. When a cluster contains more than one value, the displayed count is the average count for the cluster. The count is prefaced by a tilde symbol (~) if there are multiple different occurrences. Expand the cluster for a more detailed view of the values in the cluster along with individual counts. Use the search tool to look up specific column values, and press Enter to initiate the search. When you select a value in the histogram, the column is sorted, and the value is highlighted in the grid.
    Note
    The displayed histogram is determined by the column's data type. A column containing numbers could still be considered as text if Data Type is set to String.

    Numerical histograms are vertical and represent the range of values along the x-axis. Hover over any bar to show the Count, Min, and Max values for the data in the bar. The number of bars can also be adjusted by using the slider above the histogram. Toggling the Show Outliers box includes or removes outlier values from the histogram.

    Note
    Below a numerical histogram, there is a box and whisker plot to visualize the histogram's distribution of values as well as Min, Median, and Max values.