Relationships

Seeing relationships in data is something that is very difficult to achieve when we view data numerically. The following visualizations are the key to uncovering correlations, outliers, and clusters in the data:

• Goal: Increase product subscriptions
• Question: Are there any differences in the relationship between the revenue and the sales quantity by product sub-group?
• Analysis: Here, we will use a scatter graph to plot product sales that are grouped by product sub-group

Getting ready

We will make use of the same Chapter 2 – Sales.qvf application used in the Composition recipe.

How to do it…

1. In the application overview, click on the button in the top right-hand corner in order to create a new sheet and then click on the Create new sheet button. Name this sheet Relationships.
2. Once inside the newly created sheet, go to the Charts asset pane and double-click on the Scatter plot chart button.
3. Add the following measure (m) and dimension (d) in exactly the same order as shown here:

(m) Sum(Sales...