Melissa - United Kingdom - Global Intelligence +44 (0)20 3051 0140
Side Navigation | DQT

Data Profiling

Data Profiler

Put your data under a microscope and see it in a new light



Let's Start A New Project Together


Data Profiler


Use Melissa's Profiler to discover data issues, and monitor your data quality continuously to ensure it’s always up-to-date and accurate. Profiler analyzes data before it’s merged into your warehouse, then helps ensure consistent data quality once it’s there. With Profiler, you’ll develop informed strategies on how best to manage and employ your data. Don’t just collect data—make it work for you!


  • Enhance data governance and data warehousing efforts to drive better business intelligence and analytics throughout the enterprise
  • Create a metadata repository that aids in building strategic datamarts to resolve ambiguities throughout data entities
  • Enforce business rules on incoming records so you can maintain data standardization, collect data, and format it in a way that is easy to understand and analyze
  • Showcase ongoing Data Quality improvements to stakeholders, and help convince management of the necessity for Data Quality Budget and Governance initiatives with over 100 types of detailed metadata

Ways to Access Profiler



Melissa's Profiler - On-Premise API

On-Premise API

Multiplatform, multifaceted support for the following platforms: Java®, Visual C#®, Windows®, PHP, Oracle®, Linux®, Solaris®, HP UX®.

X

Let's Start A New Project Together


Melissa's Profiler - Integrations and Plugins

Integrations and Plugins

Data quality made easy—plug into Microsoft® SQL Server® SSIS or Pentaho® and go.

X

Let's Start A New Project Together


How Profiler Works



Profiler was designed to tackle two data profiling predicaments:


Identification
Using every available general profiling metric on the market today, Profiler leverages sophisticated parsing technology to identify, extract, and understand your data. It returns numerous string and numeric stats from averages to quartiles to minimum and maximum values, and more. Detecting and fixing these problems before the data is merged into a warehouse is a crucial step in ensuring data quality and will save you time and money—not to mention stress!


Monitoring
The Profiler also provides continuous monitoring functions that help you understand how well your data quality processes are working, and enforce business rules on incoming records to maintain data standardization and reduce the amount of cleansing needed.


Knowledge-Based Analysis


Profiler can analyze a wide variety of data types:


  • Contact Name
  • Title or Department
  • Company
  • Address
  • City
  • State or Province
  • ZIP® or Postal Code
  • Country
  • Phone
  • Email Address

Identification & Discovery


Identify data quality issues for immediate attention and monitor conformance of source data to specified requirements of pre-set limits.



Melissa's Profiler General Formatting is used for names, emails, postal codes, addresses, and more. This level ensures your inputted data is formulated to your exact specifications.

1. General Formatting

Used for names, emails, postal codes, addresses, and more, this level ensures the data you input is formatted to your exact specifications.

2. Content Analysis

This level relies on reference data to determine if what you input is consistent with expected data.

Melissa's Profiler Content Analysis relies on reference data to determine if what you input is consistent with expected data.
Melissa's Profiler Field Analysis determines if the input data is consistently fielded, using the data contained in the record.

3. Field Analysis

Profiler’s third level of analysis determines if the input data is consistently fielded, using the data contained in the entire record to analyze the context of data.

Monitoring

Good data quality means constantly ensuring what you’ve collected is up-to-date. Profiler allows regexes and error thresholds to be set for full-fledged monitoring, 24/7/365.

Melissa's Profiler Monitoring constantly screens what you've collected is up-to-date, ensuring good data quality.

What Our Customers Say


Resources


Free Trial & ROI Guarantee


Request a free trial by filling out the form.


  •   30-day free trial so you can test our tools in your environment.

  •   Free, unlimited technical support.

  •   120-Day ROI Guarantee!

Let's Start A New Project Together