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
v1.0 · 4 filesFiles are for members. A free account takes a minute, and you come straight back here.
- Question Book PDF DD-TRF-001_Question_Book.pdf
- Dataset Documentation / Data Dictionary XLSX DD-TRF-001_Data_Dictionary.xlsx
- Business Introduction PDF DD-TRF-001_Business_Introduction.pdf
- Raw fact data DD-TRF-001_Transformation.xlsx
Questions
Open one to discuss it- Q019 Medium Clean amount by month
- Q020 Medium Valid rows by month
- Q021 Medium Distinct customers by month
- Q022 Medium Exact duplicates by month
- Q023 Medium Conflicting duplicates by month
- Q024 Medium Blank customer codes by month
- Q025 Medium Text amounts by month
- Q026 Medium Non-ISO dates by month
- Q027 Medium Stray-case codes by month
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.