Skip to main content

Data Integration

Combining files, mapping and alias lookups, joins on standardised keys, reconciliation.

Questions

DD-TRF-001-Q008 — Unknown product codes

DD-TRF-002-Q008 — Unknown product codes

DD-TRF-003-Q008 — Unknown product codes

DD-TRF-001-Q012 — Top region after mapping

DD-TRF-004-Q016 — Unknown products by month

DD-TRF-004-Q020 — Clean amount by category

DD-TRF-004-Q021 — Clean amount by region

DD-TRF-003-Q022 — Unknown products by month

DD-TRF-004-Q024 — Reconcile batch Partition_2025_01 to the export

DD-TRF-004-Q025 — Reconcile batch Partition_2025_02 to the export

DD-TRF-002-Q026 — Unknown products by month

DD-TRF-003-Q026 — Clean amount by category

Datasets

DD-TRF-001 — Basic Data Cleaning and Shaping

DD-TRF-002 — Multi-File Transformation and Data Quality

DD-TRF-003 — Complex Joins, Exceptions and Transformation Logic

DD-TRF-004 — Enterprise Data Transformation and Performance Lab

Compatible tools

Power BI

Python

Excel

SQL