# Tutorial - Association Analysis - Teradata Warehouse Miner

## Teradata Warehouse Miner User Guide - Volume 3Analytic Functions

Product
Release Number
5.4.5
Published
February 2018
Language
English (United States)
Last Update
2018-05-04
dita:mapPath
yuy1504291362546.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2302
Product Category
Software

In this example, an Association analysis is performed on the fictitious banking data to analyze channel usage.

1. 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
2. Run the analysis.
3. 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
4. Click Graph Options and do the following:
1. Select all data in selector 1 under the “Item 1 of 2” heading.
2. Select all data in selector 2 under the “Item 1 of 2” heading.
3. Click on the large button between selectors 1 and 2.
4. Click the show graph tab.
5. When the tile map displays, perform the following additional steps:
1. Click the bottom most tile. (Hovering over this tile displays the item names K and V).
2. Try selecting different measures at the top right of the tile map. (Zscore is selected initially).
Association Graph: Tutorial