DD-TRF-002
Multi-File Transformation and Data Quality
Decide which branch files drift from the standard layout, how many rows fail to match the central export, and what the combined, validated total is.
- Data Transformation
- L2 · CSV
- ~30,864 rows
- 8 tables
- 40 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-002_Question_Book.pdf
- Dataset Documentation / Data Dictionary XLSX DD-TRF-002_Data_Dictionary.xlsx
- Business Introduction PDF DD-TRF-002_Business_Introduction.pdf
- Relationship Diagram PDF DD-TRF-002_Relationship_Model.pdf
- Raw fact data DD-TRF-002_FactRawEvents.csv
- Dimension / supporting data DD-TRF-002_Dimensions.zip
Questions
Open one to discuss it- Q017 Medium Clean amount by month
- Q018 Medium Valid rows by month
- Q019 Medium Distinct customers by month
- Q020 Medium Exact duplicates by month
- Q021 Medium Conflicting duplicates by month
- Q022 Medium Blank customer codes by month
- Q023 Medium Text amounts by month
- Q024 Medium Non-ISO dates by month
- Q025 Medium Stray-case codes by month
- Q026 Medium Unknown products by month
- Q027 Medium Return lines by month
- Q028 Medium Value of returns by month
- Q029 Medium Year-on-year change in clean amount
- Q030 Medium Clean amount by category
- Q031 Medium Clean amount by region
- Q032 Medium Largest monthly shortfall against target
- Q033 Medium Rows per batch file
- Q034 Medium Drifted columns per batch file
- Q035 Medium Batch rows absent from the export
- Q036 Medium Export rows absent from each batch
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.