5.4.5 - Tutorial - Association Analysis - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 3Analytic Functions

Product
Teradata Warehouse Miner
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

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