Viewing Data Profiling Characteristics

In this section:

Data Profiling provides data characteristics for the columns in a synonym. You can display the characteristics for all the columns in a synonym or segment, or for an individual column.

Note: Data Profiling is not available if your adapter is not configured correctly. For more information about configuring the adapter, see Accessing Data and Creating Synonyms.

For alphanumeric columns, Data Profiling provides the segment, format, count of distinct values, total count, patterns count, maximum, minimum, average length, minimum and maximum values, and number of nulls. Patterns count shows the number of patterns found in each alphanumeric column.

For numeric columns, Data Profiling provides the segment, format, count of distinct values, total count, maximum, minimum, average values, and number of nulls.

Data Profiling for an individual column provides access to Statistics, Patterns, Values, and Outliers reports.


Top of page

x
Data Profiling a Synonym or Segment

How to:

Data Profiling provides information on all the columns in a synonym or segment. You can also drill down to the Values or Patterns reports for an individual column from a synonym or segment Data Profiling report.



x
Procedure: How to View Data Profiling for a Synonym or Segment

To view the Data Profiling information for a synonym or segment:

  1. From the Projects or Data Servers area, open a synonym by double-clicking a Master File from the Master Files folder.

    The Synonym Editor opens to the Field View tab.

  2. Right-click the synonym or segment name and select Data Profiling, and then select either Statistics, Count, Key Analysis, Values, or Duplicate Values, as shown in the following image.

    Data Profiling options

    The Data Profiling information displays in the workspace.

    Data Profiling report

    You may use the Data Profiling Results toolbar to view server messages, print the report, copy data as text, and export the report.

  3. Optionally, you can click a column name or patterns count (for alphanumeric columns) to drill down to the Values or Patterns reports, respectively.

    This is a partial Values report produced by clicking a column name.

    Values report

    The image below is an example of an address column.

    Patterns Report

    For pattern analysis, a 9 represents a digit, an A represents any uppercase letter, and an a represents any lowercase letter. All printable special characters are represented by themselves, and unprintable characters are represented by an X.


Top of page

x
Data Profiling a Single Column

How to:

Data Profiling for an individual column provides access to four reports:

These reports are available by right-clicking a column in the Synonym Editor and selecting Data Profiling, as shown in the following image.

Data Profiling options



x
Procedure: How to View Data Profile Statistics

To view the Statistical Data Profiling information for a single column:

  1. From the Projects or Data Servers area, open a synonym by double-clicking a Master File from the Master Files folder.

    The Synonym Editor opens to the Field View tab.

  2. Right-click a column and select Statistics from the Data Profiling context menu.

    The Statistical Data Profiling information displays in the workspace, as shown in the following image.

    Statistics Report

  3. Optionally, you can click a column name or patterns count (for alphanumeric columns) to drill down to the Values or Patterns reports, respectively.


x
Procedure: How to View Data Profile Patterns

Data Profile Patterns shows patterns of letters, digits, and special characters, as well as counts and their percentages.

To view the Patterns Data Profiling information for a single column:

  1. From the Projects or Data Servers area, open a synonym by double-clicking a Master File from the Master Files folder.

    The Synonym Editor opens to the Field View tab.

  2. Right-click a column and select Patterns from the Data Profiling context menu.

    The Patterns Data Profiling information displays in the workspace.

  3. Optionally, you can click a pattern count to display the actual patterns.

    For pattern analysis, a 9 represents a digit, an A represents any uppercase letter, and an a represents any lowercase letter. All printable special characters are represented by themselves, and unprintable characters are represented by an X.



x
Procedure: How to View Data Profile Values

Data Profile Values shows unique values.

To view the Values Data Profiling information for a single column:

  1. From the Projects or Data Servers area, open a synonym by double-clicking a Master File from the Master Files folder.

    The Synonym Editor opens to the Field View tab.

  2. Right-click a column and select Values from the Data Profiling context menu.

    The Values Data Profiling information displays.



x
Procedure: How to View the Data Profile Values Graph

The Data Profile Values Graph shows

  1. From the Projects or Data Servers area, open a synonym by double-clicking a Master File from the Master Files folder.

    The Synonym Editor opens to the Field View tab.

  2. Right-click a column and select Values Graph from the Data Profiling context menu.

    The Values Graph Data Profiling information displays.



x
Procedure: How to View Data Profile Duplicate Values

Data Profile Duplicate Values shows identical values.

To view the Duplicate Values Data Profiling information for a single column:

  1. From the Projects or Data Servers area, open a synonym by double-clicking a Master File from the Master Files folder.

    The Synonym Editor opens to the Field View tab.

  2. Right-click a column and select Duplicate Values from the Data Profiling submenu.

    The Duplicate Values Data Profiling information displays.



x
Procedure: How to View Data Profile Outliers

Data Profile Outliers shows the 10 highest and 10 lowest distinct values.

To view the Outliers Data Profiling information for a single column:

  1. From the Projects or Data Servers area, open a synonym by double-clicking a Master File from the Master Files folder.

    The Synonym Editor opens to the Field View tab.

  2. Right-click a column and select Outliers from the Data Profiling context menu.

    The Outliers Data Profiling information displays.

    Note: Outliers produce a maximum of 10 highest and 10 lowest distinct values, if they exist.


WebFOCUS