Skip to content
Lean-Data Lean-Data

Menu

  • Architecture
    Design your foundation
  • Asset
    Build your value
  • Quality
    Improve & optimize
  • Migration
    Realize the value
  • Solutions
    Save time & money
    • LeanData Deviation Discovery
    • LeanData Extraction
  • Contact
    Background & contact

Find the deviations in your data

Improving your data quality starts with first understanding the data. By creating a data profile you quickly get a view of the size of the dataset, the used columns and the variation of the contents.

When you have obtained a first impression of the dataset, you will browse through the values of each column. You’ll quickly notice oddities of missing values or unexpected duplicate values.

You can click on each value and get a view at the complete corresponding records to understand the data itself with the adjacent values.

And this is where you’ll get your followup questions. You notice that there are inactive customers in the dataset. You also notice that there are different values (including typing errors) and you wish to make a sub selection.

Shorten process time

The proces & lead time (and thus cost) required to define the business rules and data quality rules will be greatly reduced. The sooner you can monitor and improve your data quality the faster you will gain the benefits.

Quality

Drilling down quickly and looking at the facts speeds up creating data definitions and finetuning the business rules. Getting these right the first time is essential to building organizational support of data quality monitoring creating a more data driven organization.

Cost

Save the cost of investing in high priced software solutions by first gaining experience and identifying your requirements.

Data visualization

A single intuitive screen enables the business user to understand his data, click through the values & records, find duplicates and create defintions & business rules on the go

Smart solutions make data quality easy

The solutions have been designed with a mindset of being smart, performance and usable. The ultimate goal is to improve data quality by looking at the facts. The functionality is straight forward and intuïtive without being technical.

Results

Immediate improvement of data quality on completeness, correctness and consistency

Data definitions and business rules through interactive discussion

Ready to use data quality rules in generated SQL

Go beyond the MS Access limitation of 2 GB database filesize by linking the datasets instead of importing

Data profile preview

Features

Data value is created by gaining understanding of the data, creating a common definition and improve the data accordingly where deviations are found.

While doing so you can create the data definitions and business rules as you go.

Easy link data sources (txt, csv and even MS SQL Server tables)

Profile datasets and directly get a visual understanding of the dataset

Identify unlikely missing values (completeness)

Identify unexpected values (correctness)

Identify key columns and nearly unique columns (uniqueness)

Fuzzy find duplicate values (phonetic match, fuzzy match, weighted fuzzy match)

Double click columns and its values to see the corresponding records

Dynamic drill down into dataset and create dynamic sub profiles for selections

Dynamic drill down querying without coding

Document definitions & business rules on the go

Fast business value for low cost

Business value is created by the people, not the technology. Technology enables a person to leverage the value. Before you can actually start to use technology big investments are needed:

Understanding the business needs

Definition of requirements

RFI processes

RFP processes

Contract negotiations

Software installation & configuration

User training

This is a lengthy process which delays the identification of the benefits and thus postpones value. LeanData defines this as waste.

Start at the right place, the data itself and enable the business user to get in control.

Data Deviation Discovery Premium

Full profile unlimited dataset

Unlimited dataset profiles

Fast sample profile up to 10.000 records

Fuzzy matching

Create definitions & business rules

Find the detailed data deviations causing the majority of business issues

First year € 999

Data Deviation Discovery Trial

Full profile up to 1000 records

Limited to 3 dataset profiles

Fast sample profile up to 10.000 records

Fuzzy matching

Create definitions & business rules

–
–

Free

To request a license, please provide the Windows user ID. The user ID is also shown in the solution under the ‘license’ button (displayed only if no valid license is found).

Request a license

Pricing for more than 10 licenses or a user domain license can be discussed.

Download LeanData Deviation Discovery

The Data Deviation Discovery solution can be downloaded here. The solution will run in unlicensed mode untill you enter a license. A license can be requested through the contact form.

Download Now!

| © 2023 Lean-Data | KvK 71359338 | BTW NL001912597B29 |

Top