NORTHSTAR SHOP — GUIDED PORTFOLIO BRIEF
Question: what does the April–May completed-order change show, what qualifies it,
and what evidence should be gathered before recommending expansion?
Reader: fictional operations lead. Case: fictional guided learning, not client work.
Data: unchanged Module 4 raw46/reference44 orders; 40 completed, 20 each month.
Period: 1 April–31 May 2026, order dates; EUR major units, not cents.
Observed dates end on the 22nd of each month; fixture completeness is not proof
of complete real-world trading coverage. No costs/customers/experiment supplied.

PRIMARY ROUTE
Choose a local spreadsheet or SQLite. Recreate preparation and metrics before
looking at the worked case study. Use the methods from earlier modules.
SQL setup creates raw_orders and a separately supplied reference orders table;
it does not automatically clean the source. Use a new empty local practice DB.

EIGHT MILESTONES
1 Scope/plan: question, grain, population, units, acceptance criteria, local folder.
2 Prepare: eight-entry quality log; 46 -> 44 records; preserve genuine missingness.
3 Calculate: monthly/channel metrics, coverage/status denominators, reconciliation.
4 Investigate: mix, distribution, verified high order and labelled sensitivity.
5 Present: dashboard or honest static views; check filters and narrative scope.
6 Explain: case study and 120–180 word decision note linked to methods.
7 Package: editable analysis, source, method, test record and contribution statement.
8 Extend: one bounded independent question, changed-input test and final review.

ACCEPTANCE
Counts/values reconcile; group averages use correct weights; missing is not zero;
comparison windows and channel scopes align; verified A020 remains baseline;
scenarios are named; statements match evidence; files and links are reproducible.
Label guided material, your actual work and the independent extension separately.
No fabricated savings, client endorsements, credentials, causal or profit claims.
Work remains local. No upload, automatic grading, paid enrolment or publication.