data quality aat bisnode interact
Post on 28-Nov-2014
583 Views
Preview:
DESCRIPTION
TRANSCRIPT
International Data Quality @Bisnode Interact
A flavour of complexity
How to tackle International Data Quality
How does it work concretely?
How does DQ fit with Bisnode Interact?
Topics covered
Confidential information & property of Bisnode Interact
3
A flavour of complexity
No such thing as the United States of Europe
Confidential information & property of Bisnode Interact
4
A flavour of complexity
Based on:
-Postal system
-- Language and alphabet
-- Available updates
The Netherlands
UK
Germany
Italy
Austria
Switzerland
Portugal
Spain
France
GreeceBelgium
Ireland
Sweden
Norway
DenmarkFinland
VERY STRICT
PRIVACY
COMPLEXITY
LOW
VERY COMPLEX
Based on:
-Opt in and opt out regulations
-Supression files
-Legally allowed enrichment etc
A flavour of complexity: Ireland
5
No post code system (with exception of Dublin)
Rural areas: county, nearest post town and townland
Urban addresses: County, city or town, street name, house number and apartment or flat number where relevant
The 26 county names can be written in English or Irish
The country on the envelope can be “Ireland” or “Éire”*
There is no country called the Republic of Ireland; that name was once used, but was abolished long ago; now it is the name of a football team.
A flavour of complexity: Ireland
6
Most places have Irish names, which often cannot and should not be translated into English
Example of Irish address: And what it would mean in English: Cnoc na Sceiche The Hill of the ThornLeac an Anfa The Flagstone of the StormCathair na Mart The City of the BeevesCo. Mhaigh Eo The County of the Plain of the YewsÉIRE IRELAND
A flavour of complexity: The Netherlands
7
The addressee can be identified thanks to unique post code + street number combination
A flavour of complexity: Spain
8
The Hispanic honorifics Señor, Señora, and
Señorita are truncated as Sr., Sra., Srta.,
respectively.
The word "Don" at the beginning of a
person’s name indicates a title of respect to a
distinguished or older individual
In Spain, most people live in flats so the floor
number (4º) and often also the letter (B) of
the flat are commonly used.
C = calle - street. Spanish does not use the myriad of possibilities as English
does: road, way, mews, lane etc. but there are some other names:
• 3o - third floor
• 3ª - 3rd Door (NOT Floor!)
• s/n - without ("sin") number -- as when a building is on a street, but
doesn't have a building/house number.
• No. - (Usually indicates that a house/building number follows. Occurs in
only some addresses.)
And Privacy, Privacy, Privacy …
A flavour of complexity: Greece
9
In small villages street name and city are not
required; information about the zip code, post
office and last name can be enough for a
mailable address.
Post is often distributed in the post office or if
there isn’t any, in other local places like cafés
A street in Greece can have more than one zip
code. It is therefore often important that the
correct street number is used:
52050 ΙΕΡΟΠΗΓΗ
ΜΕΟΠΟΣΑΜΙΑ
Postal code
Post office
102H ΟΔΟΣ 819005 N. MAKPH
Postal code
Street name and number
102H ΟΔΟΣ 3319013ANABYΣΣΟΣPost office
How to tackle it
Confidential information & property of
Bisnode Interact 10
Data quality is teamwork
Human expertise
Tools
Reference files
11
How to tackle it
Own proprietary DQ solutions:
– Access to the most up-to-date & accurate reference files
– Best of breed software
– Proprietary performant deduplication technology
Permanent acces to European Partners
Movers & Suppressions
Legal
… and we started in one of the most complex countries of the world
How do we tackle it at Bisnode Interact
How does it work concretely?
13
Multi country
input file
Multi country output file
updated with country specific
treatments and in the right
formats
• Robinsons
• Enrichment
• Movers
• Robinsons
• Enrichment
• Movers
• Deceased
• Robinsons
• Enrichment
• Movers
• Deceased
• Robinsons
• Enrichment
• Movers flags
Formating
Validation
Normalisation
Formating
Validation
Normalisation
Formating
Validation
Normalisation
Formating
Validation
Normalisation
Country
specific
- Routines
- Staff
- Tools
- …
Two important rules.1. Start with great respect for local differences!
– All countries are different– Postal Rules are different– Privacy Laws are different– ….
2. You need a close collaboration with local partners– Legal advice– Access to reference files– Access to movers, deceased– Postal regulations– …
How does it work concretely?
Confidential information & property of Bisnode Interact 14
How does Data Quality fitwithin offering ofBisnode Interact?
Confidential information & property of Bisnode
Interact 15
This presentation is solely for the use of <CLIENT>. No part of it may be circulated, quoted, or
reproduced for distribution to any other parties without prior written approval
Bisnode Interact closed loop service offering
Direct ResponseTV ads
Call center
marketing
Custom mademagazines
Phone inbound & outboundwireless applications
• Capture consumer behaviour• Link with identified visitors to thesingle customer view• Derive insights• Enable customization
Social network
Post mailings (directmarketing offer)
Point of sales
Strategic ReportingMulti-channels campaignservices
Pan-European••
Design, build and host the 360° customer viewData hygiene, integration,matching, deduplication,enhancement & scoringAdded value data capturing
•
•
•
•Business Intelligence and analytical servicesROI drivenConsultancy Strategicpartnership
•
••
Business
Intelligence
Campaign
ManagementCustomer
view
International data ServicesCountry Address
hygiene Name
hygienePhoneformat
Email format
Movers Deceased Robinsons
France X X X X X - X
Germany X X X X X X X
Italy X X X X X - X
Belgium X X X X X - X
The Netherlands X X X X X X X
Sweden X X X X X X X
Norway X X X X X X X
Denmark X X X X X X X
United Kingdom X X X X X X X
Ireland X X X X - - X
Switzerland X X X X X - X
Austria X X X X X X X
Finland X X X X X - X
Greece X X X X - - X
Portugal X X X X X - X
Spain X X X X X* - X
17
* Only flag available, not an updated address
Why do clients work with us?
• One-stop-shopping across Europe, supported by the DNA network
• Passion about Data, for more than 30 years
• Own proprietary DQ solutions
• Consistent data quality levels across countries
• Time efficiency
• Local & multi-country expertise
• Flexible offering
• Automated or ad hoc treatments, including web services
• ROI driven
Confidential information & property of Bisnode Interact
18
Thank you
Peter TrapDirector International Business DevelopmentPeter.Trap@Bisnode-Interact.com+32 475 62 90 54
LinkedInhttp://www.linkedin.com/pub/peter-trap/3/879/ab4
WWW.BISNODE-INTERACT.COM
WWW.DNANETWORK.COM
top related