Capstone project
Parcel Operations Reliability Investigation
Reconstruct event journeys, calculate SLA performance, and isolate bottlenecks. This public brief explains the scenario, deliverables, dataset, assessed skills, and guided-versus-independent expectations without revealing the full solution.
Scenario and deliverables
Reconstruct event journeys, calculate SLA performance, and isolate bottlenecks.
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 | Operational schema map |
| Project step 2 | Journey reconstruction |
| Project step 3 | Milestone durations |
| Project step 4 | SLA classification |
| Project step 5 | Complete-period reliability report |
| Project step 6 | Bottleneck ranking |
| Project step 7 | Anomaly investigation |
| Project step 8 | Operations report |
Dataset, prerequisites, and workspace
The public brief describes the work; the app workspace provides the editor, dataset, hints, checker, and final export tools.
- Parcel Ops dataset
- Prerequisite: Keys, Relationships, Cardinality, and Join Planning
- Prerequisite: LEFT JOIN, Missing Relationships, and Zero Counts
- Prerequisite: Dates, Timestamps, Time Zones, and Half-Open Ranges
- Prerequisite: LAG, LEAD, and Period Change
- Prerequisite: Logical Processing Order, Systematic Debugging, and Data Quality
- Open workspace
Page highlights
- Public project brief
- Milestone rubric summary
- Canonical dataset and prerequisite links to original SQL Trail assets
- Report-export expectation