L1 · Required

Data models and grain

Use data models and grain to make decisions inspectable.

What you should be able to do

Independently: Define keys, fields and relations for orders and order lines.

Suggested prerequisites

A short guide

Use data models and grain to make decisions inspectable. Define keys, fields and relations for orders and order lines. Read the indicated source section, identify its key concepts and conditions, and work through the example. Record inputs, sources, units and assumptions. Keep your method separate from the result, mark unanswered questions, and review the output against the checklist.

An example

One row per order differs from one row per item.

Your task

Define keys, fields and relations for orders and order lines.

Start with this source

Read the indicated section relevant to data models and grain and complete the foundation task.

This source is awaiting renewed review. Try the task above and adjacent skills; reviewed sources will appear here.

Your learning checklist

Required items: 0 / 10 completed or already known

Device storage

Next: Read a role through its responsibilities

Checklist statuses are self-reported; exercise scores are recorded separately. You can reset any item.

Self-check