Back to catalog
Data Engineering

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.

What you will be able to do
  • 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

What this course proves

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 preview

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.

Explore all credential levels

Who designed this course

IM

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.

Product data cleansing
Data enrichment
Data governance
UNSPSC classification
Enterprise data platforms
AI strategy
  • CEO of the Year Awards 2024 β€” CEO Monthly
  • Founder & CEO, AICA Data
View LinkedIn profile

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.

Course Curriculum
1

Foundations: Profiling, AICA Platform & Governance

6 lessons β€’ Foundations

40 minutes

2

Application: Advanced Normalisation, Deduplication & Capstone

5 lessons β€’ Implementation

50 minutes

Summative Assessment

Profiling & Normalisation Capstone Project

Final Assessmentβ€’60 min

Free to join. Start straight away.

Duration90 min
Lessons12
Levelintermediate
Shape the Academy

Help us improve this course

Report an issue or suggest an improvement β€” every idea is reviewed.

Shape the Academy

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.

Β© AICA β€” licensed for enrolled learner use only; redistribution prohibited.