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

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