Table and Column Details in Profiling Result

The Data Profiling Results page can be divided into three parts.

A header showing the profile details
The left pane that displays the profile name and all the tables and column included in it
The report pane that give a pictorial view of the analyzed data

The report displayed in the right pane is based on what you select in the left pane (profile, table, or column). Details, such as Standard deviation (Stdev), Maximum (Max), Minimum (Min), and Average value are displayed at the column level for numerical data, while length frequency and text pattern frequency is displayed for string columns. Besides, based on the rules selected for profiling, additional tabs are displayed in the report, such as Semantic Type for columns having semantic type values if Semantic Analysis rule is selected. For more information, see Profiling Rules.

Profile details

The header of the report displays these details of the analyzed profile.

Profile name: Name of the profile
Description: A brief description of the profile
Started: The date (yyyy/mm/dd), time (hh:mm:ss), and period (AM or PM) when the profile analysis was initialized
Data Source: The source of the data in the profile being analyzed. It can be a physical or logical model or a direct data source connection.
User: The user who created the profile
Tables: Number of tables in the selected model
Data source type: Whether the data source for the profile is a model a database.
Records: Total number of records analyzed

Model and table details

The left navigation pane of the Data Profiling Results page displays the profile analyzed and the tables and columns included in it. The pictorial report displayed on the right pane corresponds to the selection made in the left pane. For example, if you click the profile name, the report displays:

Summary for the profile showing the percentage of complete and incomplete rows in the profile data.
An overview of the tables in the profile data in the Tables Summary tab.

You can use the type-ahead Search text box above the Summary grid to find the relevant table or column.

Note: For the date data type, results display time zone of the client machine.

The Data Profiling Results

Based on what you select in the left pane of this page, these reports are displayed in the right pane.

Profile analysis report: Click the data source name in the left pane to display these details:
- Completeness: The percentage completeness of rows in the profile data
- Tables Summary: Displays these details for every table in the profile
  - Table Name: Names of all the tables in the profile
  - Number of Columns: Number of columns in the table
  - Number of Records: Number of records in the table
  - Completeness (%): Completeness of records in the table
Table report:Click any of the table names in the left pane to display these details:
- Completeness: The percentage completeness of rows in the table
- Column Summary: Displays these details for every column in the table
  - Column Name: Names of all the columns in the table
  - Column Type: The data type in the column
  - Completeness (%): Completeness of records in the column
  - Uniqueness (%): Uniqueness of the data contained in the column
  - Detected Type: Displays the semantic types, such as email, phone, city, first name, and last name detected in the string in this column.
- Null Count Frequency: Displays the number of null values in every row of the table
Column report: Click any of the columns in the left pane to display these details:
- Completeness: The percentage completeness of data in the column
- Unique: How unique is the data in the column (%)
- Min Length and Max Length of characters in case the column data is a string
- Standard deviation (Stdev), Maximum (Max), Minimum (Min), and Average value in case the column has numerical data.
- Frequency of data in the column
- Length Frequency in case the column data type is string
- Text Pattern Frequency in case the column data type is string