Data Cleaning
Fixing types, trimming and casing codes, standardising labels, removing duplicates.
Questions
DD-TRF-001-Q002 — Exact duplicate rows
DD-TRF-002-Q002 — Exact duplicate rows
DD-TRF-003-Q002 — Exact duplicate rows
DD-TRF-004-Q002 — Exact duplicate rows
DD-TRF-001-Q005 — Amounts stored as text
DD-TRF-002-Q005 — Amounts stored as text
DD-TRF-003-Q005 — Amounts stored as text
DD-TRF-004-Q005 — Amounts stored as text
DD-TRF-001-Q006 — Dates not in ISO format
DD-TRF-002-Q006 — Dates not in ISO format
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