In this example, an Association analysis is performed on the fictitious banking data to analyze channel usage.
-
Parameterize an Association analysis as follows:
- Available Tables — twm_credit_tran
- Group Column — cust_id
- Item Column — channel
-
Association Combinations
- Left — 1
- Right — 1
-
Processing Options
- Perform All Steps — Enabled
- Minimum Support — 0
- Minimum Confidence — 0.1
- Minimum Lift — 1
- Minimum Z-Score — 1
- Where Clause Text — channel <> ‘ ‘ (i.e., channel is not equal to a single blank)
-
Output Tables
- 1 to 1 Table Name — twm_tutorials_assoc
- Run the analysis.
-
Click Results when it completes.
For this example, the Association analysis generated the following pages. The SQL is not shown for brevity.
Tutorial - Association Analysis Data ITEM1OF2 ITEM20F2 LSUPPORT RSUPPORT SUPPORT CONFIDENCE LIFT ZSCORE A E 0.85777 0.91685 0.80744 0.94132 1.02669 1.09511 B K 0.49672 0.35667 0.21007 0.42291 1.18572 1.84235 B V 0.49672 0.36324 0.22538 0.45374 1.24915 2.49894 C K 0.67177 0.35667 0.26477 0.39414 1.10506 1.26059 C V 0.67177 0.36324 0.27133 0.4039 1.11194 1.35961 E A 0.91685 0.85777 0.80744 0.88067 1.0267 1.09511 K B 0.35667 0.49672 0.21007 0.58898 1.18574 1.84235 K C 0.35667 0.67177 0.26477 0.74234 1.10505 1.26059 K V 0.35667 0.36324 0.1663 0.46626 1.28361 2.33902 V B 0.36324 0.49672 0.22538 0.62047 1.24913 2.49894 V C 0.36324 0.67177 0.27133 0.74697 1.11194 1.35961 V K 0.36324 0.35667 0.1663 0.45782 1.2836 2.33902 -
Click Graph Options and do the following:
- Select all data in selector 1 under the “Item 1 of 2” heading.
- Select all data in selector 2 under the “Item 1 of 2” heading.
- Click on the large button between selectors 1 and 2.
- Click the show graph tab.
-
When the tile map displays, perform the following additional steps:
- Click the bottom most tile. (Hovering over this tile displays the item names K and V).
-
Try selecting different measures at the top right of the tile map. (Zscore is selected initially).
Association Graph: Tutorial
