Simverse
← All simulations

Business Analyst simulation

Why did orders drop last week?

Basketly · Quick commerceFresher / 1–3 yrs 40 min

You're a new Business Analyst at Basketly, a quick-commerce startup. Delivered orders fell last week and the VP of Growth wants to know why before noon. You'll write real SQL against the orders warehouse, size the problem, resist a convenient story, protect customer data and write the summary leadership will read.

💻 Simulations run best on a laptop or desktop.

Create an account to start

You can pause and come back. Time in the simulation only moves when you act.

Basketly · Business AnalystDay 1 · 09:00 AM

Your first message

Meera PillaiAnalytics Lead (your manager)09:00 AM

Orders dip: need the why by 11:30

Morning! Delivered orders dropped last week and Nikhil wants to know why before his 11:30. Can you dig in? The warehouse is open in your SQL workbench. Answer the questions in the panel and send me what you found. Numbers get checked, so please query rather than eyeball 🙂

Your objective

Find out why delivered orders fell, quantify it correctly, and get the right fix prioritised.

Your day

What's scheduled. More will come up depending on what you do.

  1. 09:00 AMOrders dip: need the why by 11:30 · Meera Pillai
  2. 09:35 AMIt's the coupon, right? · Rahul Kapoor
  3. 11:30 AMSo what do we do? · Nikhil Arora
  4. 02:30 PMQuick export pls 🙏 · Pooja Sethi
  5. 04:00 PMWBR summary · Meera Pillai

Before you start

  • It's 9:00 AM on Monday 16 March. The day ends at 6:00 PM.
  • The orders warehouse (SQLite) runs in your browser. Query it as much as you like.
  • Numbers you report are checked against the data. Round percentages to one decimal place.
  • People will push their own theories. Your job is what the data says.

You'll work in

Gmail Slack BigQuery Docs Drive
SQL workbenchWritten deliverable

Each app is laid out like the tool most teams in this role use. Simverse isn't affiliated with these companies.

People you'll work with

  • Meera Pillai · Analytics Lead (your manager)
  • Nikhil Arora · VP Growth
  • Rahul Kapoor · Growth Marketing Manager
  • Arjun Das · Engineering Manager, Checkout
  • Pooja Sethi · Sales Ops Lead

What's assessed

  • Data interpretation

    Reads data correctly, spots patterns and avoids misleading conclusions.

  • Analytical thinking

    Breaks questions down and chooses the analysis that answers them.

  • Business reasoning

    Connects decisions to revenue, cost and risk.

  • Stakeholder management

    Aligns people with different goals without losing the outcome.

  • Communication

    Writes and speaks clearly, specifically and appropriately for the audience.