Background Image

DATA PREPARATION

Data is often times dirty, and a good amount of it can be unstructured. NNCompass allows you to prepare the data for analysis quickly, seeing changes on the data immediately. Our unstructured enrichment transforms are point-and-click, providing the user with powerful controls to extract the most out of their data.

Watch the Data Preparation Video

Data Transformations

Data Transforms are data wrangling interactions which help you cleanse, normalize and integrate your data. NNCompass has dozens of transform operations designed for users of all kinds.

Data Cleansing

NNCompass runs data inferring algorithms when it's first ingested, but you can also run a range of cleansing operations on the data, in memory, to view the results immediately. Changing data types, find-and-replace, date formatters, and geocoord formatter are examples of cleansing operations.

Data Enrichment

NNCompass was designed to take advantage of all of your data, not just highly structured data. Ingest files like word, PDF, ppt and emails then transform your data by running enrichment & extraction transforms to apply structure -- without having to write a single line of RegEx.

Data Wrangling Transforms

Background Image
Change Column Names

This transform will change an existing column name to a name you specify

Ignore / Hide Columns

Hiding/Ignoring column names will hide them from the data view. It won't delete them from the original data

Merge & Create Column

Select two or more columns to merge (or concatenate) together. Merging two or more columns results in a newly created column

Split Columns

Split multiple key value pairs found inside one column into multiple columns

Find & Replace

Find text within a column, or across all columns, and replaces it with text you specify

Create Based on Formula

This transform lets you create new data columns based on mathematical operations

Outlier Handler

Sometimes mistakes are made when manually inputting numerical data. Here you can specify acceptable ranges on any numerical column

Data Masking

Data masking is the process of hiding original data with random characters or data. Protect data that is classified as personal identifiable

Normalize Dates

Dates are normalized during the ingest process, but you can still select a date column and change the way the date is displayed

Unstructured Text Enrichment

Background Image
"Easy Add" Extractions

Select from a dropdown list of the commonly found things in unstructured text, like key value pairs, phone numbers, dates, emails, URL's, SSN's, Credit Card Numbers and financial data like dollar and euro figures

User Assisted Extraction

A breakthrough in extracting value out of unstructured text this allows you to train NNCompass on key / value pairs specific to your data. A powerful way to allow non-technical users to apply regular expression extractions

Expert Mode Extraction

If you're an expert user you can write in your own RegEx, or start with prebuilt "East Add" extractions and modify them to your needs

Split Columns

Split multiple key value pairs found inside one column into multiple columns

Find & Replace

Find text within a column, or across all columns, and replaces it with text you specify

Create Based on Formula

This transform lets you create new data columns based on mathematical operations

Expert Transforms

Background Image
Filter on Expressions

This transform allows you to filter rows based on an expression. Use it to select what data rows you would like to work with

Create Based on Expression

This transform allows you to create a new column utilizing existing columns' values, or string or numeric literal

ID Value

This transform allows you to set the ID value for an NNData object

Split Columns

Split multiple key value pairs found inside one column into multiple columns

Base 64

The Base64 transform encodes and decodes data using the base64 scheme

Split Row

The split row transform splits a row into two or more rows based on naming patterns found in columns that allow sets of columns to be grouped together