Skip to main content

Data Quality

Error rows, blanks, orphan keys, schema drift, validation checks and audit counts.

Questions

DD-TRF-001-Q001 — Rows in the export file

DD-TRF-002-Q001 — Rows in the export file

DD-TRF-003-Q001 — Rows in the export file

DD-TRF-004-Q001 — Rows in the export file

DD-TRF-001-Q003 — Conflicting duplicate IDs

DD-TRF-002-Q003 — Conflicting duplicate IDs

DD-TRF-003-Q003 — Conflicting duplicate IDs

DD-TRF-004-Q003 — Conflicting duplicate IDs

DD-TRF-001-Q004 — Blank customer codes

DD-TRF-002-Q004 — Blank customer codes

DD-TRF-003-Q004 — Blank customer codes

DD-TRF-004-Q004 — Blank customer codes

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