Tutorial - Cluster Scoring - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 3Analytic Functions
Product
Teradata Warehouse Miner
Release Number
5.4.4
Published
July 2017
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
lov1499730320967.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2302
Product Category
Software

In this example, the same table is scored as was used to build the Cluster analysis model.

  1. Parameterize a Cluster Score analysis as follows:
    • Selected Table — twm_customer_analysis
    • Include Cluster Membership — Enabled
    • Column Name — Clusterno
    • Include Cluster Probability Scores — Enabled
    • Column Prefix — p
    • Result Table Name — twm_score_cluster_1
    • Index Columns — cust_id
  2. Run the analysis.
  3. Click Results when it completes.

    For this example, the Cluster Scoring analysis generated the following pages. A single click on each page name populates Results with the item.

    Clustering Progress
    Iteration Log Likelihood Diff Timestamp
    1 -24.3 0 Tue Jun 12 15:41:58 2001
    Data
    cust_id p1 p2 p3 clusterno
    1362509 .457 .266 .276 1
    1362573 1.12E-22 1 0 2
    1362589 6E-03 5.378E-03 .989 3
    1362693 8.724E-03 8.926E-03 .982 3
    1362716 3.184E-03 3.294E-03 .994 3
    1362822 .565 .132 .303 1
    1363017 7.267E-02 .927 1.031E-18 2
    1363078 3.598E-03 3.687E-03 .993 3
    1363438 2.366E-03 2.607E-03 .995 3
    1363465 .115 5.923E-02 .826 3
    … … … … …
    … … … … …
    … … … … …