Unison:Profiler

From Melissa Data Wiki
Jump to navigation Jump to search

← Unison by Melissa

Unison by Melissa Navigation
Introduction
Installation Instructions
Software Update Instructions
Address Object Tutorial
Software Rollback Tutorial
LDAP Settings
Platform
Dashboard
Projects
Jobs
Files
Logs
Settings
Services
Address Object
Email Object
Matching
Name Object
Phone Object
Profiler
Result Codes
Result Code Use
Unison by Melissa Result Codes



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


Getting Started

UNProfiler MenuProfiling.png

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

UNProfiler Title.png

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

UNProfiler Input.png

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

Unison 2 PreviewInput.png
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

Unison 2 FileSettings.png
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

UNProfiler ColumnSelection.png

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

UNProfiler ColumnTypes.png

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

UNProfiler ProfilingOptions.png

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.
UNProfiler ProfilingOptions-Advanced.png
UNProfiler ProfilingOptions-CustomPattern.png


Process

UNProfiler Process-ReadytoRun.png

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


UNProfiler Process-StatusRunning.png
UNProfiler ProjectConfiguration.png

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.

UNProfiler Results-Summary.png

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

Profiler Stats

UNProfiler Results-Stats.png
Further down you can get a detailed table of specific profiling stats.

Potential Problems

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

Column Stats

UNProfiler Results-ColumnStats1.png
UNProfiler Results-ColumnStats2.png
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.
UNProfiler Results-Export.png
From here you can click export these results to choose your export file settings and create a file.
UNProfiler Results-ExportSettings.png