Reading a Data Quality Profile

After you have run a profiling plan or created a one-time profile (see Creating a Data Quality Profile), a file with a .profile extension will appear in the File Explorer (it will be immediately opened in the later case). Double-clicking such a file will open the Profile Viewer.

The Profile Viewer

The Profile Viewer contains several tabs and windows, which are described in further sections. The data can be exported to XML or HTML format by using the  button in the top right part of the Viewer.

Profile Reader

Inputs and Roll Ups

The Profiling Step may take any number of inputs, which are shown in this panel (if there is more than one input). Additionally, each input may have any number of "roll ups" assigned to it - ways of grouping the data by specific parameters. For example, roll ups could be used to view data profiles by gender, department or country.

See Input Category and Roll Ups Tab for information on adding multiple inputs and configuring roll ups.

For information on how to create a profile, see Creating a Data Quality Profile.

Understanding The Profile Statistics

Depending on the configuration upon its creation, the profile will contain a set of statistics, which can be divided into two categories:

  • Column Analyses - learn how to read Basic, Frequency, Domain, Mask, Quantiles, and Group Frequency analyses
  • Advanced Analyses - learn how to read Primary Keys, Foreign Keys, Business Rules, and Dependency analyses