Visualize Data in a Pyramid Chart

4.5.4 Visualize Data in a Pyramid Chart

Pyramid charts present your data in a distinctive triangular configuration, horizontally segmented into partitions. Each segment in the pyramid charts represents points or steps in ascending or descending order.

When to use this chart: Use this chart to depict hierarchical structures and the relative proportions of different values. They are typically used for displaying demographic data, market segmentation, or organizational structures. In any case, the data must have a progressive order.

Dataset: CUSTOMER_INSURANCE_LTV. In this example, we will use the example template notebook OML-Run-me-first.

To visualize data in a pyramid chart:

In the OML-Run-Me-First notebook, go to the paragraph where you viewed the CUSTOMER_INSURANCE_LTV.
Click on the pyramid chart icon.

Figure 4-23 Pyramid icon on the toolbar
Click the Settings icon . Under Setup:
- Aggregate Duplicates: Select Average.
- Series to Show: Select INCOME and MORTGAGE_AMOUNT.
- Group By: Select MARITAL_STATUS.
Figure 4-24 Pyramid Chart showing two series

The Pyramid chart is now shows the average for the two series INCOME and MORTGAGE_AMOUNT, grouped by MARITAL_STATUS.
On the Settings dialog, click Customization:
- Click Customization expand Visualization.
- Click 3D under Dimension
Figure 4-25 Pyramid Chart rendered in three dimension
Click the Setup tab again, and change Group By to GENDER.

Figure 4-26 Pyramid Chart - Depicting the two series grouped by Gender

This completes the task of visualizing your data in a pyramid chart. The pyramid chart shows a clear correlation between the two genders, and their income level and mortgage amount. For both the categories, the average income and mortgage amount taken is higher for Females.

Parent topic: Visualize your Data in Oracle Machine Learning Notebooks