Profiling & Normalisation
Produce a normalization rule library and a cleaned Golden Record sample by running AICA profiling workflows, applying UNSPSC/GPC mappings, and validating deduplication on a provided product extract.
How this course differsA short course that joins profiling to normalisation on one product extract.
Designed by Isak Marais, Founder & CEO, AICA Data
- 90 min
- 12 lessons
- intermediate
Free to join. Start straight away.
- Execute a full profiling run in the AICA platform on the provided product extract and export a defect summary report.
- Create a cleaned Golden Record sample by normalizing spelling, abbreviations and units across product attribute fields and applying UNSPSC or GS1 GPC mappings where available.
- Analyze profiling metrics to identify and prioritise the top ten data quality issues, including an estimated business impact for each.
- Evaluate duplicate candidate groups, select surviving records, and document deduplication rules suitable for operational deployment.
- Design a short governance-ready normalization specification that maps attributes to UNSPSC/GS1 standards and sets confidence thresholds for automated workflows.
Part of the Golden Record Architect path
Completing every lesson and passing each module knowledge check at 75% first-attempt accuracy issues a verifiable AICA credential with a unique ID.
- Module 1
- Configured profiling run and defect summary draft
- Module 2
- Normalization rule library and cleaned Golden Record sample
Your credential
Proof designed to travel with you
A verifiable certificate, LinkedIn share card and square badge, issued when you complete the course and pass its assessments.
Sample β yours will carry your name and unique credential ID.
Achievement levels
Pass
75β84%
Distinction
85β94%
High Distinction
95β100%
Result levels use 70% first-attempt mastery + 30% corrected completion. You must also meet the courseβs 75% first-attempt pass requirement; a projected result is not an award.
Who designed this course
Isak Marais
Founder & CEO, AICA Data
Isak Marais is the founder and CEO of AICA Data, and a recognised authority on product, material and spares data. He advises boards and C-suite leaders on AI strategy, enterprise data platforms and digital transformation, and has led AI-driven product data cleansing, enrichment and governance programmes in operational use across 55 countries. He designed and authored the AICA Academy curriculum.
- CEO of the Year Awards 2024 β CEO Monthly
- Founder & CEO, AICA Data
Curriculum designed and authored by Isak Marais, developed with AI assistance and reviewed against Quality Matters and OLC OSCQR standards.
Learner reviews
No published reviews yet.
Foundations: Profiling, AICA Platform & Governance
6 lessons β’ Foundations
40 minutes
Application: Advanced Normalisation, Deduplication & Capstone
5 lessons β’ Implementation
50 minutes
Summative Assessment
Profiling & Normalisation Capstone Project
Free to join. Start straight away.
Help us improve this course
Report an issue or suggest an improvement β every idea is reviewed.
Spotted something? Have an idea?
Your feedback shapes every course. Report an issue, suggest an improvement, or request a new topic β the team reviews every submission.
