Skip to content

Meta Business Analytics Interview Questions & Answers

Curated interview practice questions with answers. These are practice scenarios, not a verified list of past interview questions.

About Meta hiring for Business Analytics roles

Meta Platforms owns Facebook, Instagram, WhatsApp, Messenger and Reality Labs. Its India presence includes business, partnerships and engineering teams, with WhatsApp and payments work closely tied to the Indian market. Technical hiring in India covers software engineering, data science, data engineering and analytics roles focused on product growth and measurement.

For Business Analytics roles, this Meta practice set focuses most on Excel for Business Analysts (9), Case Studies and Guesstimates (6), Product Analytics (4), Process Modelling and BPMN (4). It has 31 medium, 9 hard questions, so you can start easy and work up to the harder ones.

Company type
Product
Headquarters
Menlo Park, California, USA
Main India offices
Gurugram, Bengaluru, Hyderabad, Mumbai

Meta Business Analytics interview process

  1. Recruiter screening
  2. Technical phone screen (coding or SQL)
  3. Onsite coding rounds
  4. Product sense or system design round
  5. Behavioural round

Typical pattern based on public candidate experiences. Rounds vary by role, team and year.

Solved for MetaStart practicing
3 QUESTIONS FREESign up to unlock the full question bank and track your progress.Unlock every question and answer, then continue practising company-wise and package-wise.
3 questions free Unlock the rest in seconds
01

How would you decide whether to launch a new product?

Save to ▾
Show answer
Assess market size and demand, customer need, competition, unit economics, capabilities, risks and strategic fit, then test with a pilot before scale-up.
02

An online learning platform finds that only 12 percent of learners complete paid courses. How do you analyse it?

Save to ▾
Show answer
Define completion and see where learners drop: first week, a specific module or before assessments. Segment by course, length, learner background, device and acquisition channel. Look at causes in content difficulty, video length, lack of deadlines, mentor support and job relevance. Recommend tests such as shorter modules, cohort-based deadlines, progress nudges and live doubt sessions, and measure completion and referral impact.
03

Revenue grew 20 percent this quarter but the number of active customers stayed flat. How do you interpret it?

Save to ▾
Show answer
Growth came from more value per customer, not more customers. Break revenue into customers times orders per customer times average order value to see which moved. It could be price increases, larger baskets, a shift to premium products or a few large accounts. Then check risks: is new customer acquisition stalling, is churn being masked, and is growth concentrated in a small segment that could leave?
04

How would you size the market for IT courses in Delhi NCR?

Save to ▾
Show answer
Top-down: NCR population aged 18–30 × share of graduates × share wanting paid upskilling × average fee. Cross-check bottom-up with institutes × batches × students × fees. State your assumptions.
05

What is process mining and how does it help a business analyst?

Save to ▾
Show answer
Process mining uses event logs from systems such as ERP or CRM, each record holding a case ID, activity name and timestamp, to automatically rebuild how a process really runs. It shows actual paths, rework loops, bottlenecks and how often cases deviate from the designed flow. For a BA it replaces opinion-based AS-IS workshops with evidence, for example showing that 22 percent of purchase orders are changed after approval. Data quality of the logs is the main limitation.
06

Write a SQL query to show cumulative revenue by month.

Save to ▾
Show answer
WITH monthly AS ( SELECT DATE_TRUNC('month', order_date) AS month, SUM(amount) AS revenue FROM orders GROUP BY 1 ) SELECT month, revenue, SUM(revenue) OVER (ORDER BY month) AS cumulative_revenue FROM monthly ORDER BY month; -- add PARTITION BY EXTRACT(YEAR FROM month) to reset each year
07

How would you build a simple financial model in Excel?

Save to ▾
Show answer
Separate inputs, calculations and outputs, link all formulas to input cells, add scenarios and checks, and avoid hard-coded numbers inside formulas.
08

How do you build a forecast in Excel?

Save to ▾
Show answer
Use historical data with FORECAST.ETS or trend lines, state assumptions, compare against actuals and show best, base and worst scenarios.
09

What are data objects and data stores in BPMN?

Save to ▾
Show answer
A data object (page shape with a folded corner) represents information that an activity needs or produces during one process instance, such as an invoice or an application form. It is linked with dotted associations. A data store (cylinder) represents information that persists beyond the process instance, such as the customer database or ERP. Showing them helps developers see which systems are read or updated at each step and helps spot missing integrations.
10

A manager says the dashboard total does not match the finance team's Excel sheet. What do you do?

Save to ▾
Show answer
First agree on the definition: date range, gross or net, tax, returns, currency and which date (order or invoice) is used. Then reconcile at a small grain, such as one month and one region, comparing row counts and sums between the source query and the sheet. Common causes are filters on the page, missing relationships, duplicate rows after a join or a late refresh. Document the agreed definition in the report tooltip.
11

What is user activation and what is an 'aha moment'?

Save to ▾
Show answer
Activation is the point at which a new user first experiences the product's core value, such as completing a first lesson, sending a first payment or creating a first project. The aha moment is the specific early action that strongly predicts long-term retention, found by comparing retained and churned users. Teams then design onboarding to get more new users to that action quickly and track the activation rate.
12

What is a user story and what makes it good?

Save to ▾
Show answer
A short requirement written as 'As a user, I want X so that Y', backed by acceptance criteria. Good stories follow INVEST: independent, negotiable, valuable, estimable, small and testable.
13

How would you estimate the market size for an electric scooter in India?

Save to ▾
Show answer
Top-down: two-wheeler market x EV share x addressable segment. Bottom-up: target households x adoption rate x price. Compare both for a sanity check.
14

Guesstimate: how many weddings take place in India in a year?

Save to ▾
Show answer
Assume a population of about 144 crore and an average life expectancy of about 70 years, so roughly 2 crore people reach a typical marriage age each year. If about 95 percent of them marry at some point, that is around 1.9 crore people, or about 95 lakh weddings, since each wedding involves two people. A reasonable estimate is around 1 crore weddings per year, concentrated in the winter wedding season.
15

Guesstimate: how many laptops are sold in India each year?

Save to ▾
Show answer
Segment by buyer. Households: about 30 crore households, roughly 15 percent own a laptop, so 4.5 crore laptops, replaced every 5 years, gives about 90 lakh a year, plus around 20 lakh first-time student buyers. Businesses: assume 4 crore office workers using laptops, replaced every 4 years, giving 1 crore. Government and education schemes add around 10 lakh. Total is about 2.2 crore. Sanity check against industry trends and give a range of 1.5 to 2.5 crore.
16

Write a SQL query for a 7-day rolling average of daily revenue.

Save to ▾
Show answer
WITH daily AS ( SELECT order_date, SUM(amount) AS revenue FROM orders GROUP BY order_date ) SELECT order_date, revenue, AVG(revenue) OVER (ORDER BY order_date ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) AS rolling_7d FROM daily ORDER BY order_date; -- fill missing dates from a calendar table first, or gaps skew the average
17

How can LET and LAMBDA make complex Excel formulas easier to maintain? Give an example.

Save to ▾
Show answer
// LET names intermediate values so they are calculated once =LET(rev, SUM(C2:C100), cost, SUM(D2:D100), IF(rev=0, 0, (rev - cost) / rev)) // LAMBDA saved in Name Manager as MARGIN =LAMBDA(rev, cost, IF(rev=0, 0, (rev - cost) / rev)) // then use =MARGIN(C2, D2) anywhere in the workbook
18

How do you build a PivotTable to analyse sales by region and product?

Save to ▾
Show answer
Create a table, insert a PivotTable, drag region to rows, product to columns, sales to values, and add slicers for month or channel.
19

What does expectation management mean for a business analyst?

Save to ▾
Show answer
It means making sure stakeholders know realistically what will be delivered, when, and with what limits, before they form their own assumptions. A BA confirms scope in writing, states assumptions and dependencies, shares estimates with ranges, and flags risks early. When something changes, they update stakeholders immediately with options. Most stakeholder conflict comes from surprises, not from bad news itself.
20

The totals in your Excel report differ from the finance system by a few rupees. What could cause this?

Save to ▾
Show answer
Usually rounding. Excel may display rounded values while summing the full-precision numbers, or line items were rounded individually in the source system and the total was computed differently. Check whether finance rounds each invoice line before summing, and apply ROUND at the same level in Excel. Other causes include floating-point artifacts, values stored as text being skipped by SUM, or hidden filtered rows. Agree and document one rounding rule with finance.
21

Five departments each build their own Power BI reports with different revenue numbers. How would you design a better BI setup?

Save to ▾
Show answer
Create a shared, certified semantic model with one definition per KPI, built on a governed warehouse layer. Departments build thin reports on top of it through live connection instead of copying data. Set up workspaces by environment (dev, test, prod), deployment pipelines, naming standards, a KPI glossary and owners for each measure. Keep a small central team for the core model and let departments self-serve on top, which balances control and speed.
22

What is the use of the IFERROR function?

Save to ▾
Show answer
It returns a custom value when a formula errors out, keeping reports clean, for example =IFERROR(VLOOKUP(...), "Not found").
23

Write a SQL query to find the percentage of orders delivered late in each city.

Save to ▾
Show answer
-- late = delivered after the promised date SELECT city, COUNT(*) AS total_orders, SUM(CASE WHEN delivered_at > promised_at THEN 1 ELSE 0 END) AS late_orders, ROUND(100.0 * SUM(CASE WHEN delivered_at > promised_at THEN 1 ELSE 0 END) / COUNT(*), 2) AS late_pct FROM orders WHERE status = 'DELIVERED' GROUP BY city ORDER BY late_pct DESC;
24

What are dynamic array functions in Excel and how do they help analysts?

Save to ▾
Show answer
Dynamic array functions return several values that spill into neighbouring cells. UNIQUE lists distinct values, SORT and SORTBY order data, FILTER returns rows meeting conditions, SEQUENCE builds number series, and XLOOKUP can return whole rows. For example =SORT(UNIQUE(FILTER(Sales[Region], Sales[Year]=2026))) builds a live region list. They replace many helper columns and Ctrl+Shift+Enter array formulas, and the # operator references a full spill range.
25

Write Excel formulas to find the second-highest sales value and the name of the rep who achieved it.

Save to ▾
Show answer
// second highest value =LARGE(C2:C100, 2) // rep name for that value =INDEX(B2:B100, MATCH(LARGE(C2:C100, 2), C2:C100, 0)) // with ties, SORTBY gives a clean list: =TAKE(SORTBY(B2:C100, C2:C100, -1), 2)
26

A feature was launched to all users at once without an A/B test. How would you measure its impact?

Save to ▾
Show answer
Use quasi-experimental methods. Compare before and after with enough history to account for trend and seasonality. If it rolled out at different times in regions or platforms, use difference-in-differences between early and late groups. Compare users who adopted with similar non-adopters using matching, while being careful about self-selection. For future launches, recommend keeping a small holdout group so impact can be measured cleanly.
27

A project's business case promised 30 percent cost savings, but after go-live only 10 percent is realised. What do you do?

Save to ▾
Show answer
Run a benefits review against the original baseline and assumptions. Check whether savings depended on actions that did not happen, such as reducing manual roles, retiring the old system or full user adoption. Check whether the baseline or volumes changed. Separate delayed benefits from lost ones. Then produce a recovery plan with owners, for example decommissioning the legacy licence or driving adoption. Also feed the lessons into how future business cases estimate benefits.
28

Marketing and product teams define 'active user' differently and report conflicting numbers. How do you fix this?

Save to ▾
Show answer
Bring both teams together and list each definition, its purpose and its numbers. Agree on one company-wide definition tied to real value, such as a user who completed a core action in the last 7 days, and allow clearly named secondary metrics like 'visitors' for marketing. Assign an owner, document it in a metric glossary, implement it once in the warehouse or semantic model, and retire the duplicate dashboards.
29

Write a SQL query that shows revenue, cost and gross margin percent by product category.

Save to ▾
Show answer
SELECT p.category, SUM(oi.quantity * oi.unit_price) AS revenue, SUM(oi.quantity * p.unit_cost) AS cost, ROUND(100.0 * (SUM(oi.quantity * oi.unit_price) - SUM(oi.quantity * p.unit_cost)) / NULLIF(SUM(oi.quantity * oi.unit_price), 0), 2) AS gross_margin_pct FROM order_items oi JOIN products p ON p.product_id = oi.product_id GROUP BY p.category ORDER BY gross_margin_pct DESC;
30

Your AS-IS map of a loan approval process shows 14 handoffs between teams. How do you identify improvements?

Save to ▾
Show answer
First measure each handoff: waiting time, rework rate and volume, using system timestamps where possible. Then classify steps as value-adding, required for compliance or waste. Look for patterns: repeated approvals, information re-entered in two systems, work bouncing back for missing documents. Typical fixes are merging roles, adding a checklist at intake so applications arrive complete, parallelising checks and automating rule-based approvals. Quantify the expected reduction in cycle time for each option.
31

Stakeholders give conflicting requirements. What do you do?

Save to ▾
Show answer
Clarify the goal behind each request, map them to business objectives, prioritise with MoSCoW, run a joint session, then document the decision and get sign-off.
32

Leadership wants to automate an invoice approval process with RPA. What do you check in the process model before agreeing?

Save to ▾
Show answer
Check that the process is stable, rule-based and high volume, with structured digital inputs. Look at the variant rate: if half the cases are exceptions handled by judgement, a bot will fail often. Verify that the underlying systems and screens will not change soon. Fix the process first, because automating a broken flow only makes errors faster. Finally estimate hours saved against bot build and maintenance cost, and define how exceptions get routed to people.
33

How would you prioritise 10 features with a limited budget?

Save to ▾
Show answer
Score them with RICE or value-vs-effort, align with goals, consider dependencies and risks, validate with stakeholders, then use MoSCoW for the release plan.
34

A bank wants to reduce customer churn. What would you do?

Save to ▾
Show answer
Define churn, analyse who leaves and why, segment customers, find drivers through data and surveys, design retention offers and measure uplift with a control group.
35

Push notifications increased weekly engagement, but app uninstalls also rose. What do you recommend?

Save to ▾
Show answer
Quantify both effects: extra sessions and revenue from notifications versus users lost through uninstalls and notification opt-outs, including their lifetime value. Segment by notification type and frequency to find which ones annoy users. Recommend frequency caps, personalised timing, relevance rules and easy preference settings, then test them with uninstall rate and opt-out rate as guardrails. Short-term engagement should not cost long-term users.
36

What is a RACI matrix?

Save to ▾
Show answer
A table assigning Responsible, Accountable, Consulted and Informed roles per task so ownership is clear.
37

Monthly subscription churn jumped from 3 percent to 5 percent. How do you investigate?

Save to ▾
Show answer
Confirm the data first: definition changes, failed-payment handling or a billing date shift. Then segment churn by plan, tenure, acquisition channel, city and device to find where it concentrates. Separate voluntary cancellations from involuntary card failures. Look at events before the jump, like a price change, app release or competitor offer, and read cancellation reasons. Recommend targeted fixes, such as payment retries or win-back offers, and track the affected cohort.
38

What is the difference between ROI, ROE and ROCE?

Save to ▾
Show answer
ROI (return on investment) is the gain from a specific investment divided by its cost and is used to judge projects or campaigns. ROE (return on equity) is net profit divided by shareholders' equity and shows the return to owners; high debt can inflate it. ROCE (return on capital employed) is EBIT divided by equity plus long-term debt and shows how efficiently all long-term capital is used. ROCE is better for comparing companies with different debt levels.
39

What are acceptance criteria?

Save to ▾
Show answer
Clear, testable conditions a story must meet to be accepted, often written as Given-When-Then scenarios.
40

Tell me about a time you found an error in a spreadsheet just before it went to management.

Save to ▾
Show answer
Situation: an hour before a quarterly review I noticed regional totals were higher than the company total. Task: find the issue without delaying the meeting. Action: I traced it to a SUMIFS range that stopped at row 5000 while new data went beyond it, plus one duplicated region. I fixed both, converted the data to an Excel Table, and added a check cell comparing totals. Result: the correct deck went out on time and the check became part of our template.

Tips to crack the Meta Business Analytics interview

  • For data science roles, practise product sense questions such as defining success metrics for Instagram Reels or WhatsApp Status.
  • Solve two medium coding problems within about 40 minutes, as Meta coding rounds are known for being fast-paced.
  • Read Meta's company values like Move Fast and Focus on Long-Term Impact and link your behavioural answers to them.
  • Keep a one-minute story ready for every project on your CV: problem, your part, tools, result.
  • Practise the hard questions on this page aloud; Meta interviewers usually ask follow-ups on your first answer.

Frequently asked questions

How many rounds are there in the Meta Business Analytics interview?

Candidates usually go through 5 stages: Recruiter screening; Technical phone screen (coding or SQL); Onsite coding rounds; Product sense or system design round; Behavioural round. The exact rounds change with the role, team, location and your experience, so confirm the process with the recruiter.

Which topics should I prepare for the Meta Business Analytics interview?

This practice set leans on Excel for Business Analysts (9), Case Studies and Guesstimates (6), Product Analytics (4), Process Modelling and BPMN (4). Revise those first, then practise explaining one or two of your own projects end to end, because most Meta interviewers ask you to walk through real work.

Are these the exact questions asked at Meta?

No. These are curated practice questions that match the skills and difficulty usually tested in product interviews like Meta's. They are not a leaked or verified list of past questions.

Where does Meta hire Business Analytics professionals in India?

Meta has large teams in Gurugram, Bengaluru, Hyderabad, Mumbai. Openings and locations change often, so check the Meta careers page and filter by city and experience.

Business Analytics questions for similar companies