DD-TRF-003
Complex Joins, Exceptions and Transformation Logic
Decide which customer tier a sale belonged to on the day it happened, which rows break the exception rules, and what survives duplicate resolution.
- Data Transformation
- L3 · PARQUET
- ~514,953 rows
- 12 tables
- 50 questions
Get the data
v1.0 · 6 filesFiles are for members. A free account takes a minute, and you come straight back here.
- Question Book PDF DD-TRF-003_Question_Book.pdf
- Dataset Documentation / Data Dictionary XLSX DD-TRF-003_Data_Dictionary.xlsx
- Business Introduction PDF DD-TRF-003_Business_Introduction.pdf
- Relationship Diagram PDF DD-TRF-003_Relationship_Model.pdf
- Raw fact data DD-TRF-003_FactTransformationEvents.parquet
- Dimension / supporting data DD-TRF-003_Dimensions.zip
Questions
Open one to discuss it- Q001 Easy Rows in the export file
- Q002 Easy Exact duplicate rows
- Q003 Easy Conflicting duplicate IDs
- Q004 Easy Blank customer codes
- Q005 Easy Amounts stored as text
- Q006 Easy Dates not in ISO format
- Q007 Easy Codes with stray case or spaces
- Q008 Easy Unknown product codes
- Q009 Easy Return lines
- Q010 Easy Valid rows after cleaning
- Q011 Easy Reconciled total amount
- Q012 Easy Distinct customers after standardising codes
General discussion
Anything about this dataset that is not one question — loading the files, which tool, how you set it up.
A free account takes a minute. Your draft is kept while you sign in.