Skip to main content
Data Dare data transformation L1 sticker: the findi360 mascot analysing Basic Data Cleaning and Shaping.

DD-TRF-001

Basic Data Cleaning and Shaping

Decide how many rows survive a clean-up, what the reconciled total is once duplicates and bad types are gone, and which region the mapped data points to.

  • Data Transformation
  • L1 · XLSX
  • ~10,274 rows
  • 5 tables
  • 30 questions
Get the data 30 questions

Get the data

v1.0 · 4 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-001_Question_Book.pdf 1.2 MB · v1.0
  • Dataset Documentation / Data Dictionary XLSX DD-TRF-001_Data_Dictionary.xlsx 10.6 KB · v1.0
  • Business Introduction PDF DD-TRF-001_Business_Introduction.pdf 614.2 KB · v1.0
  • Raw fact data DD-TRF-001_Transformation.xlsx 580.1 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 Top region after mapping
  13. Q013 Easy Distinct customers after standardising codes
  14. Q014 Easy Distinct products after standardising codes
  15. Q015 Easy Products missing a unit cost
  16. Q016 Easy Distinct categories after standardising
  17. Q017 Easy Duplicate customers in the master
  18. Q018 Easy Unpivoted target rows
  19. Q019 Medium Clean amount by month
  20. Q020 Medium Valid rows by month
  21. Q021 Medium Distinct customers by month
  22. Q022 Medium Exact duplicates by month
  23. Q023 Medium Conflicting duplicates by month
  24. Q024 Medium Blank customer codes by month
  25. Q025 Medium Text amounts by month
  26. Q026 Medium Non-ISO dates by month
  27. Q027 Medium Stray-case codes by month
  28. Q028 Hard Regions driving the year-on-year change
  29. Q029 Hard Category standardisation bridge
  30. Q030 Very Hard Checksum of the final table

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