Like what you see? Have a play with our trial version.

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Anchor
top
top

Table of Contents
classcontents


 

Overview


Styleclass
ClasstopLink

top

 

 Data Profiling analyzes the data in your View, and determines what actions are available to optimize the efficiency of your View.

Note

Ensure that you have the Data Profiling configuration setting enabled to use this functionality. Navigate to Administration > Admin Console > Data Source > Connection > Usage Parameters > Data Profiling.



Run Analysis

1.  Click on the Data Profiling button

2.  If you want to profile all the fields in the view, click Start Profiling, otherwise click the Advanced link.

3.  Configure the advanced options and click Start Profiling to begin.

OptionsDescription
Rows to ProfileSpecify how many rows of data to profile. More rows will give more relevant results, but will take longer to analyse.
Columns to ProfileSpecify if you wish to run data profiling on all the fields in the view, or just select a single field from the list.
Analysis Types

Select which data analysis you wish to run on the selected field(s) for suggestions to be tested and included.

Selecting none will still run the standard data profiling.


 

 

Histogram


Styleclass
ClasstopLink

top

A histogram, analysing the frequency of distinct values in the data, is displayed at the top of each profiled field.


 


Chart


Styleclass
ClasstopLink

top


Grouped Values or TextNumeric, Date, or Time Values

 

Values


Styleclass
ClasstopLink

top

Image Modified


StatisticDescription
Sample SizeDisplays a count of the records within the field.
Distinct ValuesDisplays a count of the distinct values within the field.
Empty/NULL ValuesDisplays a count of the number of empty values within the field.
Numeric Fields
MedianDisplays the number separating the higher half of the sample from the lower half.
AverageDisplays the mean value.
Standard DeviationDisplays the measure of the dispersion of a set of values.
MinimumDisplays the lowest value.
MaximumDisplays the highest value.
Date/Time Fields
MinimumDisplays the earliest date.
MaximumDisplays the latest date.

 

Usage


Styleclass
ClasstopLink

top

Image Modified


SectionDescription
ReportsDisplays a list of reports that make use of the selected field.
Last ModifiedDisplays the last modified date of each listed report.
UsageDisplays the usage rate of each listed report.

 

Suggestions


Styleclass
ClasstopLink

top

Depending on the type of field being profiled, Yellowfin may make suggestions as to functions that could be applied to it based on the outcomes of the analysis.


SuggestionDescription
Reference Code CheckThe values in the field will be analysed and compared to existing ref codes. It may then be suggested that a ref code be applied, updated, or created.
Null CheckThe values in the field will be analysed and it may be suggested that null values be replaced or filtered out.
Number UniquenessThe values in the field will be analysed and it may be suggested that the fields be grouped.
Date UniquenessThe values in the field will be analysed and it may be suggested that the field be used as part of a date hierarchy.
Geography CheckThe values in the field will be analysed and it may be suggested that the field be linked to a GeoPack.
Date HierarchyThe values in the field will be analysed and it may be suggested that the field be linked in a drill down date hierarchy.

 

 

horizontalrule

Styleclass
ClasstopLink

top