Skip to main content
Data Dare data transformation L4 sticker: the findi360 mascot analysing Enterprise Data Transformation and Performance Lab.

DD-TRF-004

Enterprise Data Transformation and Performance Lab

Decide what each monthly partition adds that the export does not yet hold, which partitions drifted, and whether the pipeline reconciles at scale.

  • Data Transformation
  • L4 · PARQUET
  • ~6,179,937 rows
  • 18 tables
  • 60 questions
Get the data 60 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-004_Question_Book.pdf 1.3 MB · v1.0
  • Dataset Documentation / Data Dictionary XLSX DD-TRF-004_Data_Dictionary.xlsx 14.1 KB · v1.0
  • Business Introduction PDF DD-TRF-004_Business_Introduction.pdf 614.6 KB · v1.0
  • Relationship Diagram PDF DD-TRF-004_Relationship_Model.pdf 616.1 KB · v1.0
  • Raw fact data DD-TRF-004_FactDataPipelineEvents.parquet 139.3 MB · v1.0
  • Dimension / supporting data DD-TRF-004_Supporting_Tables.zip 16.3 MB · 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

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