THE ANALYSTANALYTICAL WORK SIMULATIONS
OPEN WORKBENCH ↗
ASSIGNMENT REGISTER

CUSTOMER CARE / INCOMING BRIEF

The Monday Scorecard

Reconcile two conflicting satisfaction figures before the executive review.

ACCEPT THE ASSIGNMENT PASS THE BRIEF

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

ASSIGNMENT
CC-241202
YOUR ROLE
Customer Insights Analyst
WORKLOAD
3–4 hours
prepared learner
COMPLEXITY BAND
Foundation
01 / SITUATION

THE OPERATING MOMENT

The decision is already in motion.

Two defensible-looking numbers are headed into the same executive meeting. Their disagreement is small enough to ignore—and large enough to change the story.

YOUR MANDATE

Establish what each figure measures, reconcile the evidence, and leave leadership with a scorecard whose definitions and limitations can survive review.

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.

Profile grains, scales, cohorts, duplicate interactions, and response coverage.

PYTHON / ANALYTICAL JUDGMENT

Stress-test the decision.

Reproduce the profile in Pandas, visualize scale/cohort differences, and create the scorecard artifact.

CAPABILITY PROFILE1 FOUNDATION / 5 ADVANCED
SQL2/5
Python2/5
Data complexity2/5
Statistical reasoning1/5
Decision ambiguity3/5
Deliverable load2/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
  • Tables and data types
  • Basic SELECT/GROUP BY
  • Pandas introduction
DATA NEIGHBORHOOD

3 tables across 2 schemas

  • support.csat_response
  • support.ticket
  • crm.account
MONDAY, 02 DEC / 08:05

Take the desk as Customer Insights 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

Two satisfaction figures. One executive meeting. Which number would you defend? Take The Monday Scorecard in The Analyst.

EMAIL
MORE WAYS TO PASS THE BRIEF