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- Q013 Medium Clean amount by month
- Q014 Medium Valid rows by month
- Q015 Medium Distinct customers by month
- Q016 Medium Exact duplicates by month
- Q017 Medium Conflicting duplicates by month
- Q018 Medium Blank customer codes by month
- Q019 Medium Text amounts by month
- Q020 Medium Non-ISO dates by month
- Q021 Medium Stray-case codes by month
- Q022 Medium Unknown products by month
- Q023 Medium Return lines by month
- Q024 Medium Value of returns by month
- Q025 Medium Year-on-year change in clean amount
- Q026 Medium Clean amount by category
- Q027 Medium Clean amount by region
- Q028 Medium Rows per batch file
- Q029 Medium Drifted columns per batch file
- Q030 Medium Batch rows absent from the export
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.