Accessing the detailed view of the database column analysis

Talend Data Management Platform Studio User Guide

EnrichVersion
6.2
EnrichProdName
Talend Data Management Platform
task
Data Quality and Preparation
Design and Development
EnrichPlatform
Talend Studio

Prerequisite(s): You have selected the Profiling perspective in the studio. A column analysis is defined and executed.

To access a more detailed view of the analysis results of the procedures outlined in Defining the columns to be analyzed and setting indicators and Finalizing and executing the column analysis, do the following:

  1. Click the Analysis Results tab at the bottom of the analysis editor to open the corresponding view.

  2. Click the Analysis Result tab in the view and then the name of the analyzed column for which you want to open the detailed results.

    Note

    The display of the Analysis Results view depends on the parameters you set in the [Preferences] window. For more information, see Setting preferences of analysis editors and analysis results.

    The detailed analysis results view shows the generated graphics for the analyzed columns accompanied with tables that detail the statistic results.

    Below are the tables that accompany the Frequency and Simple Statistics graphics in the Analysis Results view for the analyzed email column.

    In the Simple Statistics table, if an indicator value is displayed in red, this means that a threshold has been set on the indicator in the column analysis editor and that this threshold has been violated. For further information about data thresholds, see How to set options for system or user-defined indicators.

    Below are the tables and the graphics representing the order of magnitude and the Benford's law statistics in the Analysis Results view for the analyzed total_sales column.

    For further information about the Benford's law statistics usually used as an indicator of accounting and expenses fraud in lists or tables, see Fraud Detection.

  3. Right-click any data row in the result tables and select View rows to access a view of the analyzed data.

    For more information, see Viewing and exporting analyzed data.