Data cleansing
Cleanse, normalise, deduplicate and merge. For Swiss company addresses, we can also match against official Swiss sources.
Cleansing
Incorrect and empty entries are deleted or flagged — whichever you prefer.
We agree with you up front what counts as an error. A process tailored to your dataset rather than an off-the-shelf rule.
Normalisation
Different spellings become uniform — for text and numeric attributes alike. It’s the first step towards a dataset on which analytics, databases and customer records actually work. You decide how fine-grained it gets.
| Street — raw | No. | Street — normalised | No. |
|---|---|---|---|
| Musterstr. 7 | — | Musterstrasse | 7 |
| Musterstrase | 7 | Musterstrasse | 7 |
| muster-strasse 7 | 7 | Musterstrasse | 7 |
Deduplication
Duplicate entries disappear. We agree beforehand how strict the detection should be — too strict and real customers get deleted, too loose and dead records remain.
Matching
Matching, also called record linkage, merges data from different systems or files. You get one unified view of your data, with consistent keys identifying the same records if you wish.
For Swiss company addresses, we match your data against official Swiss sources. You receive current, reliable company data.
How we work
It starts with a thorough conversation. We go through the dataset with you and discuss every step before we begin.
More services
Analysis
Customer bases, web analytics and quality analyses. Where are the hidden duplicates, which campaign actually worked.
Generating data
Synthetic test data with deliberate outliers for system testing — and imputation when values are missing.
Automations
Reports, recurring data preparation, transfers between systems. Also robotic process automation for forms and interfaces.
Surveys
Exploratory, descriptive or causal — from the hypothesis through the questions to an analysis that holds up.
Training & workshops
On every service, plus introductions to R, RStudio, R Shiny and Excel. Afterwards, you can do it yourself.
Custom requests
Your problem doesn’t fit any box? Tell us what you need — we’ll do our best to help.