Teradata Warehouse Miner User Guide - Volume 1Introduction and Profiling

Teradata Warehouse Miner
User Guide
The analysis user interfaces are grouped according to functionality. Each component contains multiple controls, one for each algorithm. Each control uses smaller controls and dialog boxes to display all of the parameters for the algorithm that it represents. The actual components available depend on the particular Teradata Warehouse Miner product installed and whether you are connected to Aster or Teradata. All possible components are listed below.
  • ADS*
    1. Build ADS*
    2. Variable Creation*
    3. Variable Transformation*
    4. Refresh*
  • Analytics
    1. Association Rules
    2. Clustering
    3. Decision Tree
    4. Factor Analysis
    5. Linear Regression
    6. Logistic Regression
  • Descriptive Statistics*
    1. Adaptive Histogram
    2. Correlation Matrix
    3. Data Explorer*
    4. Frequency*
    5. Histogram*
    6. Overlap*
    7. Scatter Plot*
    8. Statistics*
    9. Text Field Analyzer*
    10. Values*
  • Matrix Functions
    1. Export Matrix
    2. Matrix
  • Miscellaneous*
    1. Free-Form SQL*
  • Publishing
    1. Publish Models
  • Reorganization*
    1. Denorm*
    2. Join*
    3. Merge*
    4. Partition
    5. Sample*
  • Scoring
    1. Cluster Scoring
    2. Decision Tree Scoring
    3. Factor Analysis Scoring
    4. Linear Regression Scoring
    5. Logistic Regression Scoring
    6. PMML Scoring
  • Statistical Tests
    1. Parametric Tests
      1. T-Test
      2. F-Test N-Way
      3. F-Test / Analysis of Variance
    2. Binomial Tests
      1. Binomial Test
      2. Binomial Sign Test
    3. Kolmogorov-Smirnov Tests
      1. Kolmogorov-Smirnov Test
      2. Lilliefors Test
      3. Shapiro-Wilk Test
      4. D'Agostino and Pearson Test
      5. Smirnov Test
    4. Tests Based on Contingency Tables
      1. Chi Square Tests
      2. Median Test
    5. Rank Tests
      1. Mann-Whitney/Kruskal Wallis Test
      2. Wilcoxon Signed Ranks Test
      3. Friedman Test
Those analyses supported on both Aster and Teradata are noted with an asterisk (*).
Each analysis creates results when it completes. These results are comprised of four different visualizations: text, tables, data, and graphics. Once an analysis is complete, results are retrieved and displayed within the results tab of the analysis. When you select a page of the report by clicking on a hyperlink, the contents of that page are loaded into the form on the right side of the control. Available graphs (again, depending on the Teradata Warehouse Miner product installed) include:
  • Descriptive Statistics*
    1. Values Circular and Bar Graphs*
    2. Statistical Box and Whisker Plots*
    3. 2 and 3-D Histograms*
    4. 2 and 3-D Frequency Graphs*
    5. 2 and 3-D Scatter Plots*
    6. Data Explorer Thumbnails and Graphs*
  • Analytics
    1. Association Rules Tile Map
    2. Cluster Analysis Size and Distances Plot and Similarity Chart
    3. Decision Tree interactive Tree Browser, Rule Text and Lift Chart
    4. Factor Analysis Factor Patterns and Scree Plot
    5. Linear Regression Bar chart for coefficients and T-statistics
    6. Logistic Regression Lift Chart
    7. Logistic Regression Bar chart for estimated standard coefficients, T-statistics, Partial R, Log Odds Ratios and Wald statistics
  • Scoring
    1. Decision Tree Lift Chart
    2. Logistic Regression Lift Chart
Those analyses supported on both Aster and Teradata are noted with an asterisk (*).