Interview prep for product, data and marketing analysts

Paste a job posting.Get ready for its interviews.

We’ll pick practice problems like the ones you could face in the interview. Solve them ahead of time and see what you still need to work on.

Build my prep

Free, no card · Pro from $29 for 30 days, no subscription

←Prepare for a jobDemo

Paste the job. Get the prep.

Product Analyst — Parsnip (grocery delivery app, New York)

Parsnip delivers groceries in under an hour. We’re hiring an analyst for the checkout team to grow repeat orders.

What you’ll do
• Own checkout metrics: conversion, retention, LTV
• Track unit economics: CAC and payback
• Design and read A/B tests with PMs
• Explain findings to leadership

What we’re looking for
• SQL: cohorts, window functions
• Python / Pandas for analysis
• Experience with ML models in production
481 / 12,000

Build my prep⌘↵

Your plan will include
✓Mock interviews by topicSQL, Python, A/B testing, product case · a score and 3 fixes
✓SQL, Pandas and Python problemsEasy to hard, with hints
✓A week as the analyst5 days at Carrot, a practice company
✓“Am I ready?” reportEach requirement: ready, almost or gap

Built from your posting

Product Analyst · Parsnip

Top skills: Product metrics · A/B testing · SQL

Your plan 5 steps, in order · cases at Carrot, a practice company

1AI mock interview · Product case“Raise the referral bonus?”~18 minStart
2AI mock interview · A/B testing Pro“Carrot+: the first month free”~18 min
3AI mock interview · SQL Pro“Do customers come back after a late delivery?”~18 min
46 problems · SQL and PandasA/B testing, statistics, cohorts · plus theory questions · checked by code~1 h
5Work week at Carrot, tuned for this job5 game days · metrics, A/B testing, SQL · checked by code2–3 hrs

0 of 6 requirements readyOpen report

←AI mock interviewSQLFind the bugsCategory revenue for August00:00 / 18 min

ProblemInterviewerCriteria

InterviewerA teammate wrote this query. The categories add up to about 14 times August’s revenue.

YouThe JOIN repeats each order’s total on every line item, so revenue is inflated.

And <= '2026-08-31' ends at the start of Aug 31, so that day is lost.

InterviewerWhy not just SUM(DISTINCT o.amount_usd)? The repeats go away.

YouNo — orders with equal totals would merge, and each category still gets the whole order.

PostgreSQLSubmit

1SELECT oi.category,

2 COUNT(DISTINCT o.order_id) AS orders,

3 SUM(o.amount_usdoi.quantity * oi.price_usd) AS revenue_usd

4FROM orders AS o

5JOIN order_items AS oi

6 ON oi.order_id = o.order_id

7WHERE o.status = 'delivered'

8 AND o.created_at >= '2026-08-01'

9 AND o.created_at <= '2026-08-31'< '2026-09-01'

10GROUP BY oi.category

The query ran: 8 rows

category	orders	revenue_usd
Beverages	1195	11257.98
Dairy	1794	19864.40
Household	791	15229.52
Meat & seafood	1713	68507.26
Pantry	1407	18519.88
Prepared foods	922	22100.92
Produce	2233	36126.14
Sweets & snacks	1016	14607.22

How it works

Four steps, one job posting

Every step below is built from the posting you paste.

1of 4

Paste the job. Get a plan for it.

Mock interviews, problems and a practice work week, picked from what the posting asks. No posting? You get a general plan.
What happens to my posting
- Without AI, the requirements are picked out right in your browser.
- If AI reads the posting, emails, phone numbers and links are hidden first.
- The full text stays temporarily in this tab, not in your saved prep.
Paste the job description here (optional)
Build my prep →Free, no card
2of 4

Rehearse the interview.

An AI interviewer asks follow-ups and challenges your answers. You get a score out of 100 and your top 3 fixes.
More about the interview
- Pick one: SQL, Python, A/B testing, product case, behavioral. A short one takes 15–20 minutes, a full one about 40.
- In SQL and Python you write code in a shared editor.
- A practice verdict on your answers, like an interviewer’s, then a debrief with a cheat-sheet card for each gap.
Example · A/B testing

InterviewerConversion is up 3%. The PM wants to ship. Your call?

YouFirst I’d check that the groups really split 50/50.

InterviewerThe PM says the split doesn’t matter if the effect is big. Agree?

72/100· your top 3 fixes
3of 4

A work week in 2–3 hours.

Five game days at Carrot, a practice company: emails with deadlines, SQL on its database and an A/B test to decide on. Stop any time and pick up where you left off.
More about the week
- Saved as you go. The traps are the ones from real work: a vague ask, a skewed split, a peek before the test ends, a colleague’s report to review.
- A wrong call on a key email comes back later in the week.
- Friday: present your findings to the CEO, played by AI
Example · Monday 8:41 AM

How many active users do we have?

ARAshley Rivera, MarketingDue Tue 12:00 PM

Hi! Can you pull how many active users we have? I need one number for Tuesday’s deck — any definition is fine.

The trap: “active” isn’t defined. Ask first, or pick a definition and say so.
4of 4

See where you’re ready.

Each requirement from the posting is marked ready, almost or gap. The report combines code-checked results and AI reviews.
When a skill counts as ready
- Only when two independent results agree — a mock interview and the work week, for example.
- One bar for everyone: what a senior analyst would do. New to it? Start with the easy problems and hints.
- A line about a tool Offer doesn’t have — ClickHouse, Tableau — is marked not tested. Nice-to-haves are listed separately and don’t count.
- A self-check in a simulator, not a certificate.
Example · another posting

Am I ready? · Data Analyst · Parsnip

2 of 4 requirements ready
- SQLReady
- A/B testingReady
- DashboardsAlmost
- Explaining results to leadershipGap

The mock interview screen, SQL section: the task “Do customers come back after a late delivery” on the left, a shared PostgreSQL editor with a query on the right, and the result table below it. — **Mock interview, SQL section.** The task, a shared editor on PostgreSQL and the result. The interviewer is in the next tab.

The work week screen: Monday 9:00 AM at Carrot, an inbox with two requests and their deadlines, and an open email from Marcus Reed, the product manager, asking whether to ship the new cart. — **Work week, Monday 8:55 AM.** A PM wants a ship decision for Thursday’s committee — and his P.S. slips in a slice with p = 0.048.

The same email on a phone: New cart test results — do we ship? — **Work week, Monday 8:55 AM.** A PM wants a ship decision for Thursday’s committee — and his P.S. slips in a slice with p = 0.048.

How it’s checked

Code checks. AI reviews answers.

Code checks task results. AI grades written answers against a rubric you can see and backs each score with a quote from your answer; code checks the quotes and calculates the final score.

codeCode checks

Your SQL result against the reference — on PostgreSQL, in your browser
A/B statistics: the split, the test you chose, the ship call
Every number in the work week and every practice answer

AIAI plays the people

The interviewer, the stakeholders and the CEO
Reads the posting once, with emails, phone numbers and links masked

Works without AI too: everything checked by code stays the same.

One bar for everyone

Ready means proven twice

Every answer is scored against what a senior analyst would do, so ‘ready’ means the same on every posting. A requirement counts as ready only when two independent results agree — a mock interview and a work week, for example. Practice alone isn’t enough. Junior? Same bar — just start with the easy problems and hints.

Who it’s for

An interview is coming up

You have a product, data or marketing analyst interview in one to three weeks — CRM and lifecycle roles too. Paste the posting and spend that time on what it asks for and the work it describes. You’ll finish with an honest list of gaps.

Aiming for the next level

Rehearse what a senior analyst owns: a ship call under pressure from a PM who wants a yes, choosing the main metric for a product area, impact in dollars.

You want practice that feels like work

You can solve puzzles. Now practice SQL, Pandas and A/B on one company’s data, with deadlines and a stakeholder who disagrees.

Not the best fit if you want a certificate or a promise of an offer. And if you’ve never written SQL, start with the basics first: Offer’s easy problems assume you can read a JOIN.

Compared

Compared with the usual mix

Problem sets, mock interviews with people — and Offer.

	Problem sets	Mock interviews with people	Offer
Your target job	Problem setsGeneric question lists	Mock interviews with peopleDepends on the interviewer	OfferMocks, practice and a week picked for the posting, plus a readiness report
The interview	Problem setsQuestions, no conversation	Mock interviews with peopleA real conversation — when you can book one, usually paid	OfferAn interviewer who asks follow-ups and pushes back — any time, in your browser
The work itself	Problem setsIsolated puzzles	Mock interviews with peopleYou talk about work you’ve done	OfferFive days at one company: emails, deadlines, SQL, an A/B test to call
Unclear asks	Problem setsThe prompt tells you everything	Mock interviews with peopleIf the interviewer plays along	OfferVague on purpose; each question to a stakeholder costs 15 minutes of the simulated day
What’s checked	Problem setsWhether your output matches	Mock interviews with peopleOne person’s judgment	OfferNumbers, queries and statistics by code; writing by AI against a visible rubric

Offer has a problem set too: 230+ problems from easy to hard — SQL, Pandas and Python algorithms, “Find the bugs” tasks included — all checked by code, with hints if you’re stuck. Browse sample problems

Pricing

Free to start

Problems, work weeks and your prep plan are free, plus one AI mock interview. Pro adds more AI when your interview is close.

Free

No card needed

One AI mock interview once you sign in: 15–40 min, a score and your top 3 fixes
230+ problems in SQL, Pandas and Python, checked by code
Work weeks at Carrot: 5 days of emails, SQL and an A/B test, checked by code
A prep plan and a readiness report for your job posting
Cheat sheet, plus “Rate the candidate”: score sample answers like an interviewer

Start free

Pro pass

$29 for 30 days

or $59 for 90 days, about $20 a month

One-time payment. No auto-renewal. Tax, if any, is shown at checkout.

Payment isn’t available in Russia, Belarus or Ukraine.

Everything in Free, plus:

AI mock interviews — about 40 in 30 days (about 100 in 90), at your own pace
Work weeks with AI: ask stakeholders and your Carrot mentor anything, get feedback on write-ups, defend your call to the CEO

Interview within a month? Take 30 days. Still searching? Take 90.

Get 30 days — $29 Get 90 days — $59

Full refund within 7 days of buying, for any reason.

FAQ

How is this different from practicing with an AI chat?

Code checks your work: every task has a known right answer, so you see whether your SQL or Python is actually right. Mock interviews are scored on criteria you can open during the interview. And the plan, work week included, is tuned to your posting.

Can I try it for free?

Yes, no card needed. Problems, work weeks, your prep plan and report are free. Sign in — also free — for one AI mock interview and to keep your progress on any device. Pro adds about 40 AI mock interviews in 30 days.

Is it right for my level?

Yes, if you can read a SQL JOIN. Problems go from easy to hard, with hints; mock interviews and the work week are scored at a senior analyst’s bar.

Do I type or talk in the mock interview?

You type. The interviewer writes in a chat, and in SQL and Python you write code in a shared editor. On a phone, your keyboard’s mic lets you answer out loud.

Will the company I’m applying to see my results?

No. Offer isn’t connected to any employer: the company in your posting never sees your prep or your results.

What happens when my pass ends?

Nothing renews and nothing is charged. You get 24 hours to finish what you started, then you’re back on Free with all your progress. Need more time? Buy before it ends and the new days are added on.

Can I get a refund?

Yes, a full refund within 7 days of buying, for any reason, however much you’ve used. Email support@offerbeta.com with your receipt or account email. Refund policy

Got an interview coming up?

Paste the posting — or skip it — and take the first step today.

Build my prep Free to start · 1 AI mock interview included · Runs in your browser