Instead of merging datasets in the Prepare workspace, we can instead blend the data from two or more datasets in the Visualize workspace, as long as they share at least one dimension. In this example, we’ll blend data from the main Yoga West dataset with data from our California Income dataset. We’ll start by creating a bubble chart that shows revenue from our main dataset. Next, we’ll add the second dataset. We’re prompted to specify the shared dimension that we’ll use to blend the data. In the Calfornia Income dataset, we previously created groups that map the counties in it to the point of sale areas in the main dataset. The shared dimension is automatically added to the bubble chart. By default, the datasets are linked by a left outer join, but we have the option to change the join type, if required. In this example, we’ll keep the default join. In this example, we’ll add a filter to limit the results to the four main point of sale areas, so that anything not relevant will be excluded. Finally, we can add measures from the second dataset to the chart. In this example, we’ll add per capita income and population. The chart now includes blended data from both datasets, revealing that while the Huntington Beach has the same population as San Francisco and the second highest per capita income, it is responsible for the lowest amount of revenue. Visit the SAP Store to download SAP Lumira free today.