Pentaho/Contact Zone:Basics: Difference between revisions

From Melissa Data Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
 
Line 6: Line 6:


Use the table of contents above to view more information on these topics.
Use the table of contents above to view more information on these topics.
==Business Coder Component==
*Search for businesses using the phone number, stock ticker, and web address.
*Discover business SIC codes, sales volumes, employee sizes, phone numbers, etc.
==Cleanser Component==
*Standardize and cleanse data.


==Contact Verify Component==
==Contact Verify Component==
Line 37: Line 44:
*Detect bad mailbox names (spam, noreply…)
*Detect bad mailbox names (spam, noreply…)
*Correct common misspellings and syntax errors
*Correct common misspellings and syntax errors
==Global Verify Component==
*Validate and Correct International Addresses
*Supports 240 countries in the world


==IP Locator Component==
==IP Locator Component==
*Returns geographic data for a given IP address
*Returns geographic data for a given IP address
*Latitude, Longitude, City, State, Zip Code, County, and ISP Information are all returned
*Latitude, Longitude, City, State, Zip Code, County, and ISP Information are all returned
==Global Address Component==
*Validate and Correct International Addresses
*Supports 240 countries in the world


==MatchUp Component==
==MatchUp Component==
Line 50: Line 57:
*Enhance the efficiency and effectiveness of your database
*Enhance the efficiency and effectiveness of your database
*Create custom Matchcodes tailored for your data
*Create custom Matchcodes tailored for your data
==SmartMover Component==
*Replace old addresses with move addresses
*Identify undeliverable and incomplete addresses
*Cut your mailing costs with postal discounts
*Increase Postal processing and delivery


==Personator Component==
==Personator Component==
Line 64: Line 65:
*Verify individual identity
*Verify individual identity
*Flexible, Cloud-based Service
*Flexible, Cloud-based Service
==Profiler Component==
*Discovers existing weaknesses in your database (duplicates, badly fielded data, bad data, etc.)
*Enforces business rules on incoming records at point-of-entry
*Allows the building of metadata repository that aids in data governance and building strategic datamarts
*Maintains data quality by continuously monitoring data after its merged into a data warehouse
*Enforces business rules on incoming records, so you can maintain data standardization
==Property Component==
*Returns information about a given parcel of property, including: assessed value; last sale price; current mortgage; physical dimensions of land; and square footage.
*The level of detail may vary according to location.
==SmartMover Component==
*Replace old addresses with move addresses
*Identify undeliverable and incomplete addresses
*Cut your mailing costs with postal discounts
*Increase Postal processing and delivery




[[Category:Pentaho]]
[[Category:Pentaho]]
[[Category:Contact Zone]]
[[Category:Contact Zone]]

Latest revision as of 23:46, 17 January 2017

← Contact Zone

← Data Quality Components for Pentaho

Pentaho/Contact Zone Basics Navigation
Overview
Tutorial
MD Components
Business Coder
Cleanser
Contact Verify
Global Verify
IP Locator
MatchUp
Personator
Profiler
Property
SmartMover
Custom Output Filter



A basic Pentaho/Contact Zone Data Transform consists of an Input, a Data Transform (the MD Components), and an Output.

Use the table of contents above to view more information on these topics.

Business Coder Component

  • Search for businesses using the phone number, stock ticker, and web address.
  • Discover business SIC codes, sales volumes, employee sizes, phone numbers, etc.

Cleanser Component

  • Standardize and cleanse data.

Contact Verify Component

Address Verification

  • Validate and Correct US and Canadian addresses
  • Append missing suites with SuiteLink® and exclusive AddressPlus technology
  • Determine delivery type (business vs. residential)
  • Validate and Correct non-USPS addresses

Geocoding (Spatial Processing)

  • Assign Latitude and Longitude to the Rooftop
  • Census Tract and Block
  • CBSA Information
  • County Names and FIPS
  • Place Names and Place Code

Name Processing

  • Parse and genderize names and multiple names
  • Detect vulgarities and suspicious words in name fields
  • Detect and standardize companies in the name field

Phone Processing

  • Verify telephone numbers to 7 - 10 digit level
  • Determine Telco Switch location
  • Detect landlines vs. cellular or VOIP
  • Detect Residential, business, small office/home office phones

Email Processing

  • Validate and correct email domains
  • Detect mobile domains (restricted from email by FCC)
  • Detect bad mailbox names (spam, noreply…)
  • Correct common misspellings and syntax errors

Global Verify Component

  • Validate and Correct International Addresses
  • Supports 240 countries in the world

IP Locator Component

  • Returns geographic data for a given IP address
  • Latitude, Longitude, City, State, Zip Code, County, and ISP Information are all returned

MatchUp Component

  • Find and eliminate duplicate records
  • Enhance the efficiency and effectiveness of your database
  • Create custom Matchcodes tailored for your data

Personator Component

  • Empower E-commerce
  • Multi-sourced data sets
  • Check contact records
  • Advanced Address Correction
  • Verify individual identity
  • Flexible, Cloud-based Service

Profiler Component

  • Discovers existing weaknesses in your database (duplicates, badly fielded data, bad data, etc.)
  • Enforces business rules on incoming records at point-of-entry
  • Allows the building of metadata repository that aids in data governance and building strategic datamarts
  • Maintains data quality by continuously monitoring data after its merged into a data warehouse
  • Enforces business rules on incoming records, so you can maintain data standardization

Property Component

  • Returns information about a given parcel of property, including: assessed value; last sale price; current mortgage; physical dimensions of land; and square footage.
  • The level of detail may vary according to location.

SmartMover Component

  • Replace old addresses with move addresses
  • Identify undeliverable and incomplete addresses
  • Cut your mailing costs with postal discounts
  • Increase Postal processing and delivery