Interrogate the estate
Use SQL to establish grain, point-in-time availability, and reconciled evidence before reaching for a model.
SIMULATION WORLD / MERIDIAN LIVING SYSTEMSFROZEN ENTERPRISE ESTATE / REV 2026.09
ANALYTICAL WORK, UNDER OPERATING CONDITIONS
Do the work.
Defend the decision.
The Analyst places you inside Meridian Living Systems, a fictional products-and-services company. Across nine full assignments and a permanent weekly rotation of 16 Priority Briefs, you step into different analyst roles and confront what clean tutorials remove: unclear requests, competing clocks, unreliable grains, operational limits, and accountable handoffs.
WORKSPACE NOTE / Complete assignments in a current laptop or desktop browser.
ASSIGNMENTS09foundation to practicum
ENTERPRISE SCHEMAS1696 documented tables
FULL ESTATE16.5Msynthetic source rows
RUNTIMELOCALSQL + Python in browser
01 / THE SIMULATION WORLD
YOUR EMPLOYER, FOR THE DURATION OF THE WORK
Welcome to Meridian. Your inbox is already full.
The Analyst is the training environment. Meridian Living Systems is the fictional company inside it: a multi-region operator selling connected-home products and subscriptions, dispatching field service, running warehouses and commerce, and supporting customers after the sale.
Meridian has grown through acquisitions, platform migrations, new models, and operational change. Its data reflects that history. Across nine assignments, you move between teams and moments in the same company. The systems, customers, devices, branches, definitions, and consequences belong to one connected estate—not nine unrelated classroom datasets.
03 / ASSIGNMENT SEQUENCE
Built to progress.
The sequence moves from metric reconciliation to production-grade model risk. Complexity rises, but judgment begins in assignment one.
01
Customer CareThe Monday Scorecard
Reconcile two conflicting satisfaction figures before the executive review.
Foundation02Commercial Data TransitionThe Quarter That Moved
Certify Q2 orders, revenue, and fulfillment timing after an acquisition cutover.
Investigation03Product ExperimentationThe Navigation Vote
Determine whether a mobile-navigation experiment warrants rollout.
Decision04Connected ReliabilityRollback Before Dawn
Recommend global rollback, scoped containment, or monitored continuation during a storm.
DecisionSERVICE PERFORMANCE / INCOMING
The Denominator Dispute
Two satisfaction figures—7.6 and 3.8—are headed for the same executive review. Reconcile their scales, populations and coverage before choosing the headline.
- YOUR ROLE
- Performance Reporting Analyst
- WORKING TIME
- 60–75 minutes
- DATA NEIGHBORHOOD
- 3 existing tables / 213,000 mounted rows
- DIFFICULTY
- Focused
FOR INDEPENDENT LEARNERS
OPEN SELF-GUIDED MANUAL Run a serious course of study—without pretending you have an instructor.
The self-guided manual supplies readiness gates, honest workload routes, a repeatable assignment cadence, stuck protocols, and a spoiler-controlled way to review your own work.
CAREER READINESS / STUDENTS + CAREER CENTERS
OPEN CAREER EVIDENCE GUIDE Turn completed work into evidence you can defend.
The Career Readiness Evidence Guide connects assignments to carefully bounded NACE competency practice, portfolio review, truthful résumé and career-profile language, interview preparation, and ready-to-use career-center formats.
FOR INSTRUCTORS AND FACILITATORS
OPEN INSTRUCTOR DESK Planning guidance, workload bands, assessment boundaries, and local review tools sit in a deliberately separate instructor desk so the learner route stays focused on the work.
MONDAY / 08:05 / CUSTOMER CARE
OPEN CC-241202