Subject 1 · First subject, no account needed

Core data concepts

Start with the question the data must answer, not a file extension. Compare regular CSV columns with JSON documents whose keys may vary, and with images or audio that require extraction before their content can be counted. Separate interchange formats from object storage and an operational database: retaining proof images differs from updating an order state or preventing a double sale. Concurrent state changes indicate a transactional workload; grouping history by month or category indicates analytical work. In the extended case, trace record counts from source to pipeline, model and visual. The first count divergence identifies where to investigate; blaming the chart alone is insufficient. Distinguish the roles that verify source data, repair transformations and agree on metric meaning. Exercises classify records, calculate a rate and reconcile a pipeline, while explicitly marking what cannot be inferred from unindexed scans or incomplete fields.

Read the whole first subject without an account: its lessons, summary and review questions.

Subject lessons

  1. Lesson 1 Representing data: structure is not a file extension 8 min read
  2. Lesson 2 From files to a store that fits the query 8 min read
  3. Lesson 3 Distinguishing transactions from analysis 9 min read
  4. Lesson 4 Who owns which decision in the data chain? 8 min read
  5. Lesson 5 Read file formats before choosing a store 7 min read
  6. Lesson 6 Data quality and lineage across roles 7 min read
  7. Integrated subject summary Review questions

The remaining subjects unlock in sequence once you create a free account.