Table of Contents

Search

  1. Preface
  2. Data Profiling
  3. Profiles
  4. Profile results
  5. Tuning data profiling task performance
  6. Troubleshooting

Data Profiling

Data Profiling

View options

View options

The following table lists the view and sort options:
Option
Description
View
Shows the following options:
  • All Insight Types. View all the insight types in the profile run.
  • Completeness Check. View the insights generated where the data appears incomplete. The column can include one or more null, blank, or empty values or values that contain only zeros.
  • Uniqueness Check. View the insights generated when the majority of the data values in the column are unique.
  • Column Length Deviation. View the insights generated when length of the data values in the column has a high standard deviation.
  • Number Value Distribution. View the insights generated for numeric values found outside the 95% standard deviation range.
  • Date Validity Check. View the insights generated for one or more dates that do not comply with a valid date pattern.
  • Date-Locale Check. View the insights generated for one or more date values that do not match the locale format.
  • Day-Date Distribution. View the insights generated for unusual distribution of day values in a date column.
  • Month-Date Distribution. View the insights generated for unusual distribution of month values in a date column.
  • Year-Date Distribution. View the insights generated for unusual distribution of year values in a date column.
  • Top Pattern Stability. View the insights generated when the topmost pattern of the column decreases by a large amount when compared to the previous profile run.
  • Spelling Analysis. View the insights generated for the data values that are phonetically similar and contain inconsistent spelling.
  • Distribution Shift. View the insights generated for the distribution of the data that might have shifted more than expected based on the mean and standard deviation of the profile that has run over multiple times.
  • Column Token Deviation. View the insights generated for the number of tokens in a column that has a high standard deviation.
  • Special Characters. View the insights generated when columns with special characters are not included in the top 80% of the patterns.
  • Null Date Analysis. View the insights generated when the string data type columns contain values from a default date pattern, such as 00/00/0000 and 99/99/9999.
In
Shows the following options:
  • All Columns. View the insight types for all columns in the profile run.
  • Columns included in the profile run.
Choose a filter in the
In
option after you choose a filter in the
View
option.
Sort
Choose any of the following options to sort the insights in ascending or descending order:
  • Insight Statement
  • Score
  • Insight Type
  • Columns
Find
Enter a keyword to view the relevant search results.
Menu
Choose Comfortable, Cozy, or Compact to adjust the row width on the Insights area.

0 COMMENTS

We’d like to hear from you!