Pseudonymisation: Lookup Keys, Salted IDs & Masking
This lesson is part of the course
In this lesson
You replace the direct identifiers of ten customers with a pseudonym from a key table, build an illustrative salted ID, mask the email address and see why the key holder can still re-identify everyone.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Direct Identifiers, Quasi-Identifiers & Sensitive Attributes Locked
- Pseudonymisation: Lookup Keys, Salted IDs & Masking Locked
- Generalisation: Age Bands & ZIP Prefixes Locked
- k-Anonymity: Equivalence Classes with COUNTIFS Locked
- Suppression of Small Classes & Information Loss Locked
- l-Diversity: When Everyone in a Class Shares the Secret Locked
- Re-identification Risk: 1/k, Average & Maximum Risk Locked
- Data Minimisation & Retention: Which Rows Must Go? Locked