Pervasive allows us to take some of the ‘world’s ugliest data’ and turn it into structured data that can be used in a downstream processes. In New Jersey, we’ve taken legacy data, Excel files, and third-party data and made it useful. New Jersey is now on the leading edge in terms of first aid tracking and analysis."

Dave Herman
President & CEO
PeopleForce

Mike Hoskins on Data Quality

How dirty is your data, and what can you do about it?



Pervasive Data Quality Tools

Unless you're guessing, you can only make good decisions based on good information (i.e. good data). Even educated guesses are educated because there is some supporting data. So how do you define "good data?" That depends on your business processes and what you need the data for.  Once you've decided what you need it for and what you want it to look like, then Pervasive can do the heavy lifting to massage and transform your data to fit your needs.  This is data quality.

Pervasive data quality tools -- Pervasive Data Profiler™, Pervasive Data MatchMerge™ and plug-in Content Libraries along with Pervasive Data Integrator™ -- make data  quality (assessment and data governance) fast and efficient.

How to Find Dirty Data

Pervasive Data Profiler enables you to quickly and easily:

  • Isolate irregularities (improper part numbers, SKUs, incomplete phone/addresses)
  • Quantify business rules violations
  • Identify null sets or values
  • Ensure data compliance with 100% testing of data, not just sampling
  • Automatically generate standard metrics
  • Define your own metrics
  • Assess metrics on multiple columns simultaneously

Parallel execution with automatic scaling across multiple CPUs making it inherently as fast as the system its running on can possibly be pushed! (based on cutting-edge Pervasive DataRush™ technology)

For more information, see Pervasive Data Profiler™

Jon/John/Johnny/Johnnie/Jonathan Smith?

Pervasive Data MatchMerge adds additional advanced and tunable algorithms for identifying potentially duplicate data, and an easy-to-use user interface to make "deduping" a breeze. This powerful combination is a highly accurate and extremely fast solution for identifying and resolving duplicate data problems.

Pervasive Data MatchMerge Offers

  • High-performance response times scales for very large data sets
  • Match on any combination of fields
  • Numerous tunable industry-leading algorithms and coding functions

Parallel execution with automatic scaling across multiple CPUs making it inherently as fast as the system its running on can possibly be pushed! (based on cutting-edge Pervasive DataRush™ technology)

For more information, see Pervasive Data MatchMerge™

Easily Enrich & Complete Your Data

People move, email domains change, phone area codes split, data entry personnel make mistakes, and the data coming in to your essential systems can already be wrong.

Address Verification, powered by recognized address content library experts like Melissa Data and Experian QAS, helps you verify that your customer, vendor, and supplier addresses, phone numbers, and email addresses are valid and correct by checking each one against a huge database of information.

Vast databases of information from institutions like USPS, Canada Post, Dun & Bradstreet, Advo, Experion, Verizon, etc. give the latest up-to-date information allowing address validation clear to the delivery point. Connecting to this validation service is as simple as running an install.

Other content libraries are available for the verification and enrichment of product data. Any content library with a web service interface can be put to work in a Pervasive process.

For more information, see Content Libraries