Capstone project
Northstar Commerce Executive Review
Defensible monthly performance, category concentration, and revenue reconciliation. This public brief explains the scenario, deliverables, dataset, assessed skills, and guided-versus-independent expectations without revealing the full solution.
Scenario and deliverables
Defensible monthly performance, category concentration, and revenue reconciliation.
The project expects SQL, assumptions, bounded result snapshots, validation checks, and a local report export.
Milestones
Each milestone is graded as an activity and contributes to project evidence only after independent or transfer validation.
Result preview8 rows
| Step | Deliverable |
|---|---|
| Project step 1 | Schema memo |
| Project step 2 | Order-line foundation |
| Project step 3 | Independent cash facts |
| Project step 4 | Order reconciliation |
| Project step 5 | Monthly KPI report |
| Project step 6 | Category concentration |
| Project step 7 | Exception investigation |
| Project step 8 | Executive package |
Dataset, prerequisites, and workspace
The public brief describes the work; the app workspace provides the editor, dataset, hints, checker, and final export tools.
Page highlights
- Public project brief
- Milestone rubric summary
- Canonical dataset and prerequisite links to original SQL Trail assets
- Report-export expectation