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- Q031 Hard Regions driving the year-on-year change
- Q032 Hard Category standardisation bridge
- Q033 Hard Reconcile batch Batch_2025_07 to the export
- Q034 Hard Reconcile batch Batch_2025_08 to the export
- Q035 Hard Reconcile batch Batch_2025_09 to the export
- Q036 Hard Reconcile batch Batch_2025_10 to the export
- Q037 Hard Reconcile batch Batch_2025_11 to the export
- Q038 Hard Reconcile batch Batch_2025_12 to the export
- Q039 Hard Sales by customer tier as at transaction date
- Q040 Hard Rows breaking the exception rules
- Q041 Hard Monthly rates against a flat rate
- Q042 Hard Top ten products before and after cleaning
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.