Values - Example #1 - Teradata Warehouse Miner

Teradata® Warehouse Miner™ User Guide - Volume 1Introduction and Profiling
Product
Teradata Warehouse Miner
Release Number
5.4.6
Published
November 2018
Language
English (United States)
Last Update
2018-12-07
dita:mapPath
rfc1538171534881.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2300
Product Category
Software
  1. Parameterize a Values analysis as follows:
    • Columns to Analyze
      • twm_customer.income
      • twm_customer.age
      • twm_customer.years_with_bank
      • twm_customer.nbr_children
      • twm_customer.gender
      • twm_customer.marital_status
    • Compute the Number of Unique Values for each column — Enabled
  2. Run the analysis.
  3. When it completes, click in the RESULTS tab. For this example, the Values analysis generated the following results. The SQL is not shown for brevity.
    Values Example #1 Data
    xtbl xcol xtype xcnt xnull xunique xblank xzero xpos xneg
    TWM_CUST… income INTEGER 747 0 640 0 102 645 0
    TWM_CUST… age SMALLINT 747 0 77 0 0 747 0
    TWM_CUST… years_with_bank SMALLINT 747 0 10 0 88 659 0
    TWM_CUST… nbr_children SMALLINT 747 0 6 0 466 281 0
    TWM_CUST… gender CHAR(1) 747 0 2 0 0 0 0
    TWM_CUST… marital_status CHAR(1) 747 0 4 0 0 0 0
    Values Example #1 Graph

    Thumbnails for each column in the analyses are shown in Absolute Counts (bar graph) format. As the mouse passes over each thumbnail, the cursor changes to indicate a hyperlink, and the individual graphs can be maximized by clicking on the thumbnail:

    Values Example #1 Graph: Maximize Thumbnail

    The maximized graphic becomes modal and must closed to return to the user interface.

  4. Right click on a graph and select Relative Counts (circle graph) to view that graphic.
    Values Example #1 Graph: Relative Counts