Tutorial - Cluster 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
dita:id
B035-2302
Product Category
Software
In this example, Gaussian Mixture Model cluster analysis is performed on 3 variables giving the average credit, checking and savings balances of customers, yielding a requested 3 clusters.
Since Clustering in Teradata Warehouse Miner is non-deterministic, the results may vary from these, or from execution to execution.
  1. Parameterize a Cluster analysis as follows:
    • Selected Tables and Columns
      • twm_customer_analysis.avg_cc_bal
      • twm_customer_analysis.avg_ck_bal
      • twm_customer_analysis.avg_sv_bal
    • Number of Clusters — 3
    • Algorithm — Gaussian Mixture Model
    • Convergence Criterion — 0.1
    • Use Listwise deletion to eliminate null values — Enabled
  2. Run the analysis.
  3. Click Results when it completes.

    For this example, the Clustering analysis generated the following pages. Since Clustering is non-deterministic, results may vary. A single click on each page name populates the page with the item.

    Progress
    Iteration Log Likelihood Diff Timestamp
    1 -25.63 0 3:05 PM
    2 -25.17 .46 3:05 PM
    3 -24.89 .27 3:05 PM
    4 -24.67 .21 3:05 PM
    5 -24.42 .24 3:05 PM
    6 -24.33 .09 3:06 PM
    Solution
    Col Table_Name Column_Name Cluster_Id Weight Mean Variance
    1 twm_customer_analysis avg_cc_bal 1 .175 -1935.576 3535133.504
    2 twm_customer_analysis avg_ck_bal 1 .175 2196.395 9698027.496
    3 twm_customer_analysis avg_sv_bal 1 .175 674.72 825983.51
    1 twm_customer_analysis avg_cc_bal 2 .125 -746.095 770621.296
    2 twm_customer_analysis avg_ck_bal 2 .125 948.943 1984536.299
    3 twm_customer_analysis avg_sv_bal 2 .125 2793.892 11219857.457
    1 twm_customer_analysis avg_cc_bal 3 .699 -323.418 175890.376
    2 twm_customer_analysis avg_ck_bal 3 .699 570.259 661100.56
    3 twm_customer_analysis avg_sv_bal 3 .699 187.507 63863.503