Normalization

Normalization is the process of standardising extracted data into a consistent structure and format. Normalization removes variations in naming, units and value types, making datasets easier to compare and combine. It is essential for building reliable data pipelines, especially when collecting data from multiple retailers or regions.

Why it matters

• Reduces inconsistencies that affect analysis and reporting
• Improves comparability across sources and markets
• Reduces manual data cleaning and preparation work

How it is used

• Standardising product attributes across multiple retailers
• Aligning price formats and currency outputs
• Preparing data for dashboards, BI tools and machine learning models