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.
Open project workspace
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.
| Step | Deliverable |
|---|---|
| S01 | Operational schema map |
| S02 | Journey reconstruction |
| S03 | Milestone durations |
| S04 | SLA classification |
| S05 | Complete-period reliability report |
| S06 | Bottleneck ranking |
| S07 | Anomaly investigation |
| S08 | 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 datasetPrerequisite: Keys, Relationships, Cardinality, and Join PlanningPrerequisite: LEFT JOIN, Missing Relationships, and Zero CountsPrerequisite: Dates, Timestamps, Time Zones, and Half-Open RangesPrerequisite: LAG, LEAD, and Period ChangePrerequisite: Logical Processing Order, Systematic Debugging, and Data QualityOpen workspace