Deduplicate customers into a golden record with a source crosswalk
The same customer exists in several systems under different ids, so customer counts and per-customer revenue are inflated.
- Transformation
- Any domain
Problem area
3 RecipesIdentity and data protection
Recipes for matching and standardising identities and for classifying and masking personal data.
Standardize names and addresses and mint deterministic match keys
The same customer is written differently across CRM, billing and support, so joins on name or address miss.
- Transformation
- Any domain
Tag personal-data columns, mask them by kind for a lower-privilege audience and prove the masked outputs
Analysts need tables that carry names, addresses, emails, phone numbers or ID numbers they must not see.
- Governance and cost
- Any domain