THE ANALYSTANALYTICAL WORK SIMULATIONS
OPEN WORKBENCH ↗
ASSIGNMENT REGISTER

COMMERCIAL DATA TRANSITION / INCOMING BRIEF

The Quarter That Moved

Certify Q2 orders, revenue, and fulfillment timing after an acquisition cutover.

ACCEPT THE ASSIGNMENT PASS THE BRIEF

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

ASSIGNMENT
CM-240708
YOUR ROLE
Commercial Data Transition Analyst
WORKLOAD
5–8 hours
prepared learner
COMPLEXITY BAND
Investigation
01 / SITUATION

THE OPERATING MOMENT

The decision is already in motion.

An acquisition cutover has put order identity, event timing, and revenue certification on different systems—and the quarter cannot close on intuition.

YOUR MANDATE

Construct a stable commercial fact, isolate the exceptions that matter, and make a documented certification call on Q2 performance.

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.

Construct a stable order fact across headers, lines, events, and shipments.

PYTHON / ANALYTICAL JUDGMENT

Stress-test the decision.

Profile collisions and clock errors, build reusable exception flags, test reconciliations, and certify an extract.

CAPABILITY PROFILE1 FOUNDATION / 5 ADVANCED
SQL3/5
Python3/5
Data complexity3/5
Statistical reasoning2/5
Decision ambiguity3/5
Deliverable load3/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
  • Python functions
  • Pandas joins
  • SQL joins and aggregation
DATA NEIGHBORHOOD

5 tables across 2 schemas

  • commerce.order
  • commerce.order_event
  • commerce.order_line
  • commerce.shipment_event
  • catalog.product_price_history
MONDAY, 08 JUL / 08:40

Take the desk as Commercial Data Transition 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 quarter closed, but the systems do not agree. Can you certify the numbers? Take The Quarter That Moved in The Analyst.

EMAIL
MORE WAYS TO PASS THE BRIEF