in Web Intelligence

Charting in Web Intelligence – Prt 5 – Bubble and Polar Bubble Charts

In Web Intelligence 4.0 there are four types of Point Charts which include Scatter Plot, Bubble Chart, Polar Scatter Plot and Polar Bubble Chart. In this session let’s look into Bubble and Polar Bubble Charts which are extensions of Scatter and Polar Charts. Scatter Charts in general allow us to plot a set of measurable pair values to be plotted on X and Y Axes for correlation. This in turn allows us to derive linear regression which can used to derive positive or negative lines and also identify outliers which don’t fall under an expected pattern.

A Bubble Chart is an extension of Scatter chart which allow us to add an additional third measurable value which forms the bubble area viewed by bubble width or height.

Fig: Shows data set with Quantity Sold and Sales generated with Sales % indicating the bubble area with respect Total Sales.

BC2The legend shows us the category dimension City which is analyzed and also shows the bubble size groups under which the Sales % is grouped. The Legend Modes include Color Legend Mode, Size Legend Mode and Color and Size Legend Mode which has been used here.

We can display the bubble data values using data types of Scale, Value, xValue, label and automatic. Here we have used Scale showing Sales %. We can also assign different Color palettes and custom color palettes and apply display effects and lighting and shading effects.

A Polar Bubble Chart is an extension of Polar Chart which uses Radial axis and Angular axis which cover 360° of the circle. A Circle layout is used and we plot a set of pair values such that the data points fall around the circle based on the first measure and inside the circle the second measure is defined into bands and the plotted value falls into these band areas. The third measure represents the size of the bubble in the circle.

Fig: Polar Bubble Chart showing Sales Revenue, Quantity and Sales % representing the Size of the Bubble.

PB3Region Color and Region Shape are optional and in our chart we used City Dimension to display these measures. The Value axis is Sales Revenue on the Top Left Side and Category Axis is Quantity Sold shown around the circle.

In conclusion, Bubble and Polar Bubble Charts are a good option to use when we have three related measures which we want to plot against dimensions for correlation and linear positive and or negative regression charting.


Free Web Intelligence Best Practices Guide

We put together a Best Practices Guide for Web Intelligence Development that includes over 20 pages of tips and techniques for developing business-ready reports. Plus we'll show you the common functions that have a negative impact on performance, how to create interactive reports, the best ways to standardize look-and-feel, and much more!


Powered by ConvertKit

Write a Comment