Define the assignment
Audience: an operational manager. Deliver a reproducible analysis, a source-validation log, one useful visual or table and a 250-word decision note. Suggested duration: 60–90 minutes. All source records are fictional.
Investigation plan
Inspect unique order IDs and allowed statuses; filter completed; group by month/channel; reconcile totals; draft a one-page explanation.
Exercises
1. Write the metric definition and grain. 2. Validate keys and units. 3. Calculate independently using two methods. 4. Show excluded/exception records. 5. Write one recommendation and one unanswered question.
Worked control totals
8 source orders, 6 completed, 2 cancelled; completed sales EUR700. April 300, May 400; change 100 /33.3%. Store 370,Web 330; AOV116.67.
Interpretation and limitations
Do not infer profit, customer retention or campaign effects: these fields are absent. A strong answer proposes the next evidence needed and avoids presenting a descriptive result as an established cause.
Self-review rubric
Score 0–2 each for scope, arithmetic, validation, explanation and reproducibility. For each score link to a concrete artifact. A total score is a self-check, not certification or employment evidence.
Try the activity before reading its reference. Keep your sources, commands and assumptions with your work. Companion activities are unsaved self-practice and do not award a certificate or change lesson progress.