THE ANALYSTANALYTICAL WORK SIMULATIONS
OPEN WORKBENCH ↗
ASSIGNMENT REGISTER

FIELD OPERATIONS PLANNING / INCOMING BRIEF

The 7:30 Capacity Call

Build a morning risk view for appointments likely to miss their service window.

Preview anywhere. Complete the work in a current laptop or desktop browser.

ASSIGNMENT
FO-250320
YOUR ROLE
Service Capacity Analyst
WORKLOAD
10–16 hours
prepared learner
COMPLEXITY BAND
Decision
01 / SITUATION

THE OPERATING MOMENT

The decision is already in motion.

The morning service plan is already in motion. A useful risk model must be honest about time, calibrated for intervention, and ready before dispatch.

YOUR MANDATE

Create a point-in-time risk view, compare it with a credible baseline, and turn model output into an operational action threshold.

02 / OPERATING CONDITIONS

WHAT THE WORK DEMANDS

Interrogate before you recommend.

You receive access to a bounded part of Meridian’s synthetic enterprise estate. The briefing defines the decision—not the analytical path or a preferred answer.

SQL / EVIDENCE CONSTRUCTION

Establish the facts.

Create a point-in-time appointment feature mart at a stable entity and scoring time.

PYTHON / ANALYTICAL JUDGMENT

Stress-test the decision.

Build sklearn pipelines, compare a baseline, use forward validation, inspect calibration/errors, and design an intervention threshold.

CAPABILITY PROFILE1 FOUNDATION / 5 ADVANCED
SQL4/5
Python5/5
Data complexity4/5
Statistical reasoning4/5
Decision ambiguity4/5
Deliverable load5/5
03 / READINESS

BEFORE YOU ACCEPT

Know the neighborhood.

This is an open-ended workplace simulation. You can inspect the available schemas and tables before committing to an approach, but the brief intentionally does not identify every useful field or analytic test.

RECOMMENDED PREREQUISITES
  • Supervised learning
  • Feature pipelines
  • Temporal validation
  • Classification metrics
DATA NEIGHBORHOOD

6 tables across 4 schemas

  • field_ops.appointment
  • field_ops.work_order
  • field_ops.visit
  • workforce.shift
  • external.weather_hourly
  • core.business_calendar
THURSDAY, 20 MAR / 07:30

Take the desk as Service Capacity Analyst.

Your SQL, Python, notes, evidence, figures, and final handoff stay in your browser until you choose to export them.

OPEN WORKBENCH
FORWARDING DESK / OPTIONAL

CHALLENGE A COLLEAGUE

Pass the Brief

Send the same decision pressure to someone else. The link opens this spoiler-free briefing; it does not include your work, identity, or progress.

SUGGESTED NOTE

The crews are dispatching at 7:30. Which appointments need intervention? Take the capacity assignment in The Analyst.

EMAIL
MORE WAYS TO PASS THE BRIEF