Analyze Data


Often the visualizations you add using the Data in analysis flyout provide enough knowledge of your data, and no further exploration is needed. After you have added the visualizations to your analysis, there is a wide range of possibilities to extend the analytics, no matter which method you used for creating them.

Summarize data

It is important to decide how the data should be represented by the visualization items, that is, which parts the data should be split into, and which summarized values the items should represent. For the summarization, you have a rich selection of methods to choose from, where the most common ones are sum and average.

Interact with the data

Not just the separate visualizations let you analyze your data; the visualizations are by default connected to each other, so your interaction with one visualization will spread to other visualizations. This way you can compare different views of the same data.

Below you find different ways to interact with, and by that, get more insights about the data:

Get started

Get started with summarizing data

To specify how the data in the column you have selected should be summarized, you select an aggregation method on the column selector. In this example, the Sales values are summarized into an average.

Get started with filtering

To filter to certain values in a data column, you hover with the mouse over the column in the Data in analysis flyout, and click Show filter . Then adjust it.

Get started with viewing details

To drill down into details, you mark items of certain interest in one visualization, and corresponding data in the other visualizations based on the same data table will by default be marked automatically. For example, if 'Los Angeles' is marked in the map chart below, 'Los Angeles' items get marked also in the other visualizations. In the pie chart, the 'Los Angeles' sector gets marked, and in the scatter plot, 'Los Angeles' customers.

 To drill down into subsets within subsets of your data, see What is a Details Visualization?.

See also:

Marking in Visualizations

Highlighting in Visualizations

Filtering Data