Values

Teradata Warehouse Miner User Guide - Volume 1Introduction and Profiling

brand
Software
prodname
Teradata Warehouse Miner
vrm_release
5.4.4
category
User Guide
featnum
B035-2300-077K

The Data Explorer Values analysis is executed against all columns within the Selected Tables and Columns window. For character data, NULL, Unique and Blank values are plotted. For numeric and date data, NULL, Unique, Zero, Positive and Negative values are plotted. By default, the results of the analysis are plotted in bar charts and displayed as thumbnails. The thumbnails can be scrolled by clicking on the double right (>>) or double left (<<) arrow buttons, or displayed on a full screen by clicking on the Full Page >> button. The Full Page mode has additional double right (>>) or double left (<<) arrow buttons for scrolling though the values data.

Each individual thumbnail can be maximized for viewing details by double clicking on it. A right click on it, or any individual thumbnail produces a dialog with the following options:
  • Maximize, Print and Export — The standard options Maximize, Print and Export are described in RESULTS Tab.
  • Hide Remaining Rows — When Absolute Counts is selected, an option to Hide Remaining Rows may be selected to not display the top (gray) portion of each bar on the graph. (By default, the inverse of the portions of the Values analysis are shown in gray. For example, a table with 1000 rows may have 150 NULL values. The box plot for NULL’s would then show 1000 rows, 850 in gray color and 150 in red). When Hide Remaining Rows is in effect, the option to Show Remaining Rows may be selected to return to the original view.
  • Relative Counts (Circle Graph) — This option changes the values thumbnails and/or graphics to a different display, showing the relative counts within a circular graph. Toggling between these two views is illustrated below.
    Absolute Counts (Circle Graph)

    Relative Counts (Circle Graph)

    Each category (i.e., Zero) sums to 1 with its inverse (i.e., Not Zero). The following colors are used to represent each category:
    • NULL — Red
    • Unique — Green
    • Zero — Orange
    • Positive — Teal
    • Negative — Purple
    • Blank — Blue

    The full page thumbnail view provides an efficient mechanism for quickly identifying data quality problems across many tables.

  • Frequency — The Data Explorer Frequency analysis is executed against columns within the Selected Tables and Columns window that are character data, or numeric data within the specified thresholds. By default, the results of the analysis are plotted in bar charts and displayed as thumbnails. The thumbnails can be scrolled by clicking on the double right (>>) or double left (<<) arrow buttons, or displayed on a full screen by clicking on the Full Page >> button. The Full Page mode has additional double right (>>) or double left (<<) arrow buttons for scrolling though the values data.

    Each individual thumbnail can be maximized for viewing details by double clicking on it.

  • Histogram — The Data Explorer Histogram analysis is executed against columns within the Selected Tables and Columns window that are numeric and/or dates outside the specified thresholds. By default, the results of the analysis are plotted in histograms and displayed as thumbnails. The thumbnails have the same properties and modes as the Frequency graphs.
  • Statistics — The Data Explorer Statistics analysis is executed against columns within the Selected Tables and Columns window that are numeric and/or dates By default, the results of the analysis are plotted in box and whisker plots and displayed as thumbnails. The thumbnails have the same properties and modes as the Frequency and Histogram graphs.

    Note that the Data Explorer Graphics Environment is always modal; it must be exited before use of Teradata Warehouse Miner can continue.