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:
You can filter to data values you are particularly interested in, and the visualizations will be based on these only.
You can get more details of the data in various ways:
- Hover with the mouse over visualization items to see details in tooltips.
- Mark items in one visualization, and items associated with the ones you have marked will get marked in other visualizations as well.
- Use details visualizations, that is, mark items of interest in a visualization to form a subset of the data, and create a visualization that represent this subset only. This can be iterated in the new visualization, which enables you to drill down into subsets within subsets of your data.
You have different methods to create your own groups of data. This is convenient when you want to analyze the data differently from using the ordinary way of grouping data by selecting columns on the different axes such as the X-axis, or the color axis. Examples of methods are Binning data, creating Subsets of data, assigning tags to data, or creating lists of data you want to track.
You can mark data and explore if there are relationships to other variables in the data.
You have several options to make calculations on the data to retrieve more information.
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?.