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.
| Options | Description |
|---|---|
| Rows to Profile | Specify how many rows of data to profile. More rows will give more relevant results, but will take longer to analyse. |
| Columns to Profile | Specify 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
A histogram, analysing the frequency of distinct values in the data, is displayed at the top of each profiled field.
Chart
| Grouped Values or Text | Numeric, Date, or Time Values |
|---|---|
 |  |
Values
| Statistic | Description |
|---|---|
| Sample Size | Displays a count of the records within the field. |
| Distinct Values | Displays a count of the distinct values within the field. |
| Empty/NULL Values | Displays a count of the number of empty values within the field. |
| Numeric Fields | |
| Median | Displays the number separating the higher half of the sample from the lower half. |
| Average | Displays the mean value. |
| Standard Deviation | Displays the measure of the dispersion of a set of values. |
| Minimum | Displays the lowest value. |
| Maximum | Displays the highest value. |
| Date/Time Fields | |
| Minimum | Displays the earliest date. |
| Maximum | Displays the latest date. |
Usage
| Section | Description |
|---|---|
| Reports | Displays a list of reports that make use of the selected field. |
| Last Modified | Displays the last modified date of each listed report. |
| Usage | Displays the usage rate of each listed report. |
Suggestions
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.
| Suggestion | Description |
|---|---|
| Reference Code Check | The 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 Check | The values in the field will be analysed and it may be suggested that null values be replaced or filtered out. |
| Number Uniqueness | The values in the field will be analysed and it may be suggested that the fields be grouped. |
| Date Uniqueness | The values in the field will be analysed and it may be suggested that the field be used as part of a date hierarchy. |
| Geography Check | The values in the field will be analysed and it may be suggested that the field be linked to a GeoPack. |
| Date Hierarchy | The values in the field will be analysed and it may be suggested that the field be linked in a drill down date hierarchy. |