Skip to main content
Data Dare data transformation L2 sticker: the findi360 mascot analysing Multi-File Transformation and Data Quality.

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 40 questions

Get the data

v1.0 · 6 files

Files are for members. A free account takes a minute, and you come straight back here.

Create a free account Sign in
  • Question Book PDF DD-TRF-002_Question_Book.pdf 1.2 MB · v1.0
  • Dataset Documentation / Data Dictionary XLSX DD-TRF-002_Data_Dictionary.xlsx 11.5 KB · v1.0
  • Business Introduction PDF DD-TRF-002_Business_Introduction.pdf 614.3 KB · v1.0
  • Relationship Diagram PDF DD-TRF-002_Relationship_Model.pdf 613.8 KB · v1.0
  • Raw fact data DD-TRF-002_FactRawEvents.csv 2.1 MB · v1.0
  • Dimension / supporting data DD-TRF-002_Dimensions.zip 178.6 KB · v1.0

Questions

Open one to discuss it
  1. Q001 Easy Rows in the export file
  2. Q002 Easy Exact duplicate rows
  3. Q003 Easy Conflicting duplicate IDs
  4. Q004 Easy Blank customer codes
  5. Q005 Easy Amounts stored as text
  6. Q006 Easy Dates not in ISO format
  7. Q007 Easy Codes with stray case or spaces
  8. Q008 Easy Unknown product codes
  9. Q009 Easy Return lines
  10. Q010 Easy Valid rows after cleaning
  11. Q011 Easy Reconciled total amount
  12. Q012 Easy Distinct customers after standardising codes
  13. Q013 Easy Distinct products after standardising codes
  14. Q014 Easy Products missing a unit cost
  15. Q015 Easy Distinct categories after standardising
  16. Q016 Easy Duplicate customers in the master
  17. Q017 Medium Clean amount by month
  18. Q018 Medium Valid rows by month
  19. Q019 Medium Distinct customers by month
  20. Q020 Medium Exact duplicates by month
  21. Q021 Medium Conflicting duplicates by month
  22. Q022 Medium Blank customer codes by month
  23. Q023 Medium Text amounts by month
  24. Q024 Medium Non-ISO dates by month
  25. Q025 Medium Stray-case codes by month
  26. Q026 Medium Unknown products by month
  27. Q027 Medium Return lines by month
  28. Q028 Medium Value of returns by month
  29. Q029 Medium Year-on-year change in clean amount
  30. Q030 Medium Clean amount by category
  31. Q031 Medium Clean amount by region
  32. Q032 Medium Largest monthly shortfall against target
  33. Q033 Medium Rows per batch file
  34. Q034 Medium Drifted columns per batch file
  35. Q035 Medium Batch rows absent from the export
  36. Q036 Medium Export rows absent from each batch
  37. Q037 Hard Regions driving the year-on-year change
  38. Q038 Hard Category standardisation bridge
  39. Q039 Very Hard Checksum of the final table
  40. Q040 Very Hard Conflicting duplicates: amount at stake

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.

Create a free account Sign in