Unison:Profiler

← Unison by Melissa

The Unison by Melissa Profiling Project can profile your data and give you insights into your data quality.

Getting Started

The Profiling Project is located under Projects > Profiling.

There are five main steps to a Profiling Project:

1. Title and Description
2. Add Input Source
3. Column Selection
4. Profiling Options
5. Process

Click any of the links above to jump to that section or continue below.

Title and Description

The first step to a Profiling Project with Unison is to give it a name. Enter a Project Title and optionally a Project Description.

When you create these you can also check the Make this a private project box to do so.

Add Input Source

The second step is to add an Input Source.

These can be from a file on your computer or one you have previously uploaded. To upload a new file, drag it to the Drag file here or broswer box or click the browse link to open a system dialog to find the file you want to upload.

Preview Input

Once you select a file, the Preview Input window will open. This will be automatically populated based on the source file.

You can choose which columns to use by toggling them and change their HEADER names by entering a different name.

File Settings

Under File Settings you can modify the settings for your file. This includes specifying if your file has a header row, the type of delimiter, and enclosure.

Column Selection

The third step is Column Selection. Here you choose the data types for your columns.

The profiler will try to match your columns to a corresponding data type, but you may have to edit this and choose a desired data type.

You can also click the x next to a field to exclude it.

Add Another Column

You can choose to add another column by clicking the button at the bottom of the page.

Profiling Options

The fourth step is Profiling Options. Here you specify the profile reporting options you want to include.

Expert Column Settings

You can choose advanced column settings like maximum character length, default values or regular expressions for your columns if you click the Expert Column Settings button.

Process

The fifth and final step is to simply Run this project now.

After you click Run this project now you'll see the Job Status page. This will show you the progress of your profiling project as it runs.

Once it is finished running, you can click Show me the results to view the final results.

Viewing the Profiling Summary will show you easy to read summary about the quality of your data.

Profiler Stats

Further down you can get a detailed table of specific profiling stats.

Potential Problems

Under Potential Problems you'll have a list of potential problems in your data. You can click these and see further details.

Column Stats

Futher stats, sorting information and character length information is also available.

Export Columns

You may want to export specific columns in your data for further processing. To do this you can click on the values in the Column Stats table to show the columns in question.

From here you can click export these results to choose your export file settings and create a file.