Data Profiling

Back Next

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.