Skip to content

Salesforce Business Analytics Interview Questions & Answers

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

About Salesforce hiring for Business Analytics roles

Salesforce is a cloud software company best known for its CRM platform, along with products such as Tableau, Slack, MuleSoft and Data Cloud. Its India centres in Hyderabad and Bengaluru handle large parts of product engineering and support. It hires for software engineers, quality engineers, data engineers and analysts working on CRM, analytics and AI features.

For Business Analytics roles, this Salesforce practice set focuses most on Case Studies and Guesstimates (7), Process Modelling and BPMN (5), SQL for Business Analysis (5), Business Metrics and KPIs (4). It has 29 medium, 11 hard questions, so you can start easy and work up to the harder ones.

Company type
Product
Headquarters
San Francisco, California, USA
Main India offices
Hyderabad, Bengaluru, Mumbai, Gurugram

Salesforce Business Analytics interview process

  1. Online coding assessment
  2. Technical round 1 (DSA)
  3. Technical round 2 (design or domain)
  4. Hiring manager round
  5. HR round

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

Solved for SalesforceStart 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

Write an Excel formula for month-to-date sales up to today.

Save to ▾
Show answer
// Dates in Sales[Date], amounts in Sales[Amount] =SUMIFS(Sales[Amount], Sales[Date], ">=" & EOMONTH(TODAY(), -1) + 1, Sales[Date], "<=" & TODAY()) // EOMONTH(TODAY(),-1)+1 gives the first day of the current month
02

A new TO-BE process went live three months ago. How do you prove that the improvement actually worked?

Save to ▾
Show answer
Compare against the baseline you measured before the change, using the same definitions: cycle time, first-time-right rate, cost per case, backlog and customer complaints. Pull data from system timestamps rather than surveys. Check that the gain is not explained by lower volumes or seasonality, ideally by comparing similar periods. Also check for side effects, such as faster processing but more rework downstream. Present the before-and-after with the business owner, and note where adoption is still incomplete.
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

A stakeholder keeps skipping review meetings and then rejects the deliverable at the end. How do you prevent this?

Save to ▾
Show answer
Talk to them one-to-one to understand why they skip, such as timing, relevance or workload. Offer shorter reviews, asynchronous reviews with a clear deadline, or a delegate with decision rights. Record sign-offs at each stage in writing so late changes become formal change requests. Share early drafts and mock-ups, because people react better to something visible. Escalate to the sponsor if the pattern risks the timeline.
05

An order has a value of 600 rupees, product cost 360, delivery 60, payment fee 12 and a discount of 50. What is the contribution margin?

Save to ▾
Show answer
Net revenue after discount is 600 minus 50, which is 550 rupees. Variable costs are 360 plus 60 plus 12, totalling 432. Contribution margin is 550 minus 432, so 118 rupees per order, or about 21 percent of net revenue. This is what each order contributes towards fixed costs such as salaries and rent. If the discount were raised to 150, the order would contribute only 18 rupees.
06

Tell me about a time you solved an ambiguous problem with limited data.

Save to ▾
Show answer
Situation: my manager asked why customer complaints were rising, but complaints were stored as free text with no categories. Task: give an answer within a week. Action: I sampled 300 complaints, created categories, tagged them manually and used keyword rules in Excel to classify the rest, then validated with the support lead. Result: late refunds were 40 percent of complaints, the refund process was fixed, and categorised tagging was added to the support tool.
07

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.
08

A Tableau dashboard on a 50 million row data source responds slowly to filters. How do you fix it?

Save to ▾
Show answer
Use an extract with only the needed columns and rows, aggregated to the visible grain where possible. Replace quick filters showing all values with fewer filters, use context filters wisely and avoid 'only relevant values' on large fields. Move complex calculations into the data source, reduce marks per view and the number of sheets per dashboard. Use the Performance Recorder to find the slowest queries and fix those first.
09

In UAT cycle 2, a feature that passed in cycle 1 is now broken after a defect fix. What does this tell you and what should change?

Save to ▾
Show answer
It is a regression: the fix for one defect broke existing functionality, which usually means changes were not impact-analysed and there is no regression suite. Log it as a new high-priority defect linked to the fix. Agree with the team that every UAT build comes with release notes listing the changes, and that QA runs an automated or core manual regression pack before handing the build to business testers. Also add the broken flow to the UAT regression checklist.
10

Write a SQL query that shows revenue per region with one column per quarter.

Save to ▾
Show answer
SELECT region, SUM(CASE WHEN EXTRACT(QUARTER FROM order_date) = 1 THEN amount ELSE 0 END) AS q1, SUM(CASE WHEN EXTRACT(QUARTER FROM order_date) = 2 THEN amount ELSE 0 END) AS q2, SUM(CASE WHEN EXTRACT(QUARTER FROM order_date) = 3 THEN amount ELSE 0 END) AS q3, SUM(CASE WHEN EXTRACT(QUARTER FROM order_date) = 4 THEN amount ELSE 0 END) AS q4 FROM orders WHERE EXTRACT(YEAR FROM order_date) = 2026 GROUP BY region;
11

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.
12

Inventory days rose from 45 to 70 over two quarters. What could be the causes and what would you recommend?

Save to ▾
Show answer
Possible causes include falling sales against unchanged purchasing, poor demand forecasts, bulk buying for discounts, slow-moving or obsolete SKUs, or deliberate stock-building ahead of a festive season or expected price rise. Analyse by SKU, warehouse and age bucket to find where stock is stuck. Recommend clearing aged items, adjusting reorder points using recent demand, and reviewing supplier minimum order quantities. Also quantify the cash locked up and the carrying cost to show urgency.
13

A lender is launching a new personal loan product. What KPIs would you set up?

Save to ▾
Show answer
Cover the full funnel and risk. Acquisition: applications, approval rate, cost per disbursed loan and time to disbursal. Value: disbursed amount, average ticket size and net interest margin. Risk: delinquency rates at 30 and 90 days past due by cohort, and early default rate. Customer: drop-off by application step, complaint rate and repeat borrowing. Track risk by monthly disbursal cohort, because defaults show up months later.
14

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.
15

How would you analyse the declining sales of a retail store?

Save to ▾
Show answer
Break sales into footfall, conversion and average basket, compare with last year and competitors, and check stock, pricing, staffing and local events.
16

Two analysts report different monthly active user numbers from the same database. How do you resolve it?

Save to ▾
Show answer
Put both queries side by side and compare definitions: which events count as active, time zone, calendar versus rolling month, test and internal accounts, deleted users, and DISTINCT on user ID versus device ID. Run both on a single day to find where they diverge. Agree on one definition with the metric owner, document it, and publish it as a shared view or metric so everyone queries the same logic.
17

A quick-commerce company wants to expand into Tier-2 cities. What would you analyse before recommending it?

Save to ▾
Show answer
Demand: population density, smartphone and digital payment penetration, average basket size and how often people buy groceries. Supply: dark store rent, rider availability and local sourcing. Unit economics: orders per store per day needed to break even, given lower average order values. Competition: local kirana delivery and other apps. Then propose a pilot in two or three cities with clear success metrics such as orders per day, contribution margin per order and repeat rate before scaling.
18

Daily active users dropped 10 percent week over week. How do you investigate?

Save to ▾
Show answer
Rule out data issues first: tracking changes, app release bugs, pipeline delays or bot filters. Check whether the drop is seasonal by comparing with the same week last year or a festival calendar. Then segment by platform, app version, country or city, acquisition channel and new versus returning users to locate it. Look at the funnel for the core action. Connect findings to releases, outages or marketing changes, then recommend fixes.
19

How do sample size and minimum detectable effect affect an A/B test design?

Save to ▾
Show answer
The minimum detectable effect is the smallest lift worth detecting, such as a 2 percent relative increase in conversion. Smaller effects, lower baseline rates and higher required power need much larger samples, roughly four times the users to detect half the effect. Calculate sample size before starting using the baseline rate, MDE, significance level and power, usually 80 percent, then fix the test duration and avoid stopping early.
20

Write an Excel formula for a two-way lookup that finds sales for a given product and month.

Save to ▾
Show answer
// products in A2:A50, months in B1:M1, data in B2:M50 // G1 = product, G2 = month =INDEX(B2:M50, MATCH(G1, A2:A50, 0), MATCH(G2, B1:M1, 0)) // Excel 365 alternative =XLOOKUP(G1, A2:A50, XLOOKUP(G2, B1:M1, B2:M50))
21

Guesstimate: how many cups of tea are sold in Delhi per day?

Save to ▾
Show answer
Population about 20 million, adult tea drinkers about 50%, cups bought outside per person around 1 on average. This gives roughly 10 million cups, then adjust for offices and stalls.
22

An A/B test shows a 5 percent higher conversion rate, but revenue per user is lower. Should you ship it?

Save to ▾
Show answer
Not automatically. Find out why: the variant may push cheaper products, bigger discounts or smaller orders, so more people buy but each spends less. Check average order value, margin and long-term metrics like repeat purchase. Decide based on the metric tied to the business goal, usually revenue or contribution per user, which should have been the primary metric or a guardrail. Consider iterating to keep the conversion gain without lowering order value.
23

What is a break-even point?

Save to ▾
Show answer
The sales volume where total revenue equals total cost. It equals fixed cost divided by contribution margin per unit.
24

Write a SQL query to calculate the repeat purchase rate.

Save to ▾
Show answer
WITH per_customer AS ( SELECT customer_id, COUNT(DISTINCT order_id) AS orders FROM orders GROUP BY customer_id ) SELECT ROUND(100.0 * SUM(CASE WHEN orders >= 2 THEN 1 ELSE 0 END) / COUNT(*), 2) AS repeat_rate_pct FROM per_customer;
25

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.
26

Why do Agile teams estimate in story points rather than hours?

Save to ▾
Show answer
Story points measure relative effort, complexity and uncertainty compared with a reference story, using a scale like 1, 2, 3, 5, 8. People are better at comparing sizes than predicting exact hours, and points do not depend on who does the work. Over a few sprints the team's velocity, points completed per sprint, makes forecasting reliable. Points should never be used to compare productivity across teams.
27

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.
28

Your analysis contradicts a strongly held belief of the vice president. How do you handle it?

Save to ▾
Show answer
Double-check the data and method first, and ask a peer to review it. Then share it privately with the VP before any group meeting, so they are not surprised in public. Present it neutrally: what we expected, what the data shows, and possible reasons. Invite their context, as they may know factors you missed. Suggest a small test to settle it. Focus on the decision, not on being right.
29

Your monthly Excel report takes a full day of manual work. How would you automate it?

Save to ▾
Show answer
Map the steps first: which files arrive, what cleaning is done and which outputs are needed. Move the import and cleaning into Power Query so a refresh replaces copy-paste. Base calculations on Excel Tables and PivotTables that update automatically, and keep a fixed template for the output. Use a small macro or Office Script only for the remaining formatting or emailing. Add checks such as row counts and totals so errors surface quickly.
30

How do you find the top 5 customers by revenue?

Save to ▾
Show answer
SELECT customer_id, SUM(amount) AS revenue FROM orders GROUP BY customer_id ORDER BY revenue DESC LIMIT 5;
31

What is the difference between sequence flow and message flow in BPMN?

Save to ▾
Show answer
A sequence flow is a solid arrow that shows the order of activities inside one pool, so it represents work controlled by one participant. A message flow is a dashed arrow with an open circle at its start and shows communication between two different pools, such as an order email from a customer to a seller. A common modelling mistake is drawing sequence flows across pools, which wrongly implies one party controls the other's work.
32

Write SQL checks to validate a customer data migration between the legacy and new systems during UAT.

Save to ▾
Show answer
-- 1. Row counts should match SELECT (SELECT COUNT(*) FROM legacy.customers) AS legacy_rows, (SELECT COUNT(*) FROM target.customers) AS target_rows; -- 2. Records missing in the target SELECT l.customer_id FROM legacy.customers l LEFT JOIN target.customers t ON t.customer_id = l.customer_id WHERE t.customer_id IS NULL; -- 3. Financial totals should reconcile SELECT SUM(outstanding_balance) FROM legacy.customers; SELECT SUM(outstanding_balance) FROM target.customers;
33

What is the 80/20 rule in business analysis?

Save to ▾
Show answer
Pareto principle: about 80% of outcomes come from 20% of causes, such as most revenue from a few customers or most defects from a few issues.
34

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.
35

Write a SQL query for the top 3 products by revenue in each category.

Save to ▾
Show answer
WITH ranked AS ( SELECT category, product_id, SUM(amount) AS revenue, DENSE_RANK() OVER (PARTITION BY category ORDER BY SUM(amount) DESC) AS rk FROM sales GROUP BY category, product_id ) SELECT category, product_id, revenue FROM ranked WHERE rk <= 3 ORDER BY category, rk;
36

Write a DAX measure for a running total of sales by date.

Save to ▾
Show answer
Running Sales = CALCULATE( [Total Sales], FILTER( ALL('Date'[Date]), 'Date'[Date] <= MAX('Date'[Date]) ) ) -- for a yearly reset use TOTALYTD([Total Sales], 'Date'[Date])
37

Your process diagram has grown to 80 shapes on one page and stakeholders say they cannot read it. What do you do?

Save to ▾
Show answer
Restructure it into levels. Create a high-level map with 7 to 10 main steps, then collapse detailed parts into sub-processes with their own diagrams. Move complex decision logic into a decision table rather than chains of gateways. Show the happy path first and handle exceptions in separate views. Use consistent naming in verb-noun form and remove duplicated steps. Finally, test readability by asking a stakeholder to explain the diagram back to you.
38

Describe a time you influenced an important decision without having authority.

Save to ▾
Show answer
Situation: leadership planned to expand a loyalty programme company-wide. Task: as the analyst, I believed the pilot results were inflated. Action: I showed that pilot stores were already our best performers and built a matched control comparison, which cut the estimated uplift from 15 to 4 percent. I presented it to the sponsor first and proposed a larger randomised pilot. Result: the rollout was redesigned, saving significant cost on a weak programme.
39

Describe a BPMN model for a purchase order process where credit check and stock check happen at the same time.

Save to ▾
Show answer
Start event: purchase order received. Task: validate order details. A parallel gateway then splits into two paths: Finance lane runs Check customer credit, Warehouse lane runs Check stock. A second parallel gateway joins them, waiting for both to complete. An exclusive gateway then decides: credit OK and stock available goes to Confirm order and Schedule dispatch; otherwise go to Notify customer with reason. Using a parallel join here is correct because both results are always needed.
40

What steps would you follow to create an AS-IS process map for a customer refund process?

Save to ▾
Show answer
Define the scope: where the process starts, such as a refund request, and where it ends, such as money credited. Identify the roles involved and draw swimlanes. Interview and observe each role, capturing steps, decisions, systems used, handoffs and time taken. Draw the flow in BPMN, mark pain points like rework loops and waiting time, and add measures such as average refund time. Validate the map with the people who do the work.

Tips to crack the Salesforce Business Analytics interview

  • Learn Salesforce core ideas like multi-tenancy, objects and Apex basics, and know what Tableau and Data Cloud do.
  • Practise test automation concepts using Selenium or similar tools if applying for quality engineering roles.
  • Read about Salesforce's values of Trust, Customer Success, Innovation, Equality and Sustainability for behavioural questions.
  • 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; Salesforce interviewers usually ask follow-ups on your first answer.

Frequently asked questions

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

Candidates usually go through 5 stages: Online coding assessment; Technical round 1 (DSA); Technical round 2 (design or domain); Hiring manager round; HR 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 Salesforce Business Analytics interview?

This practice set leans on Case Studies and Guesstimates (7), Process Modelling and BPMN (5), SQL for Business Analysis (5), Business Metrics and KPIs (4). Revise those first, then practise explaining one or two of your own projects end to end, because most Salesforce interviewers ask you to walk through real work.

Are these the exact questions asked at Salesforce?

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

Where does Salesforce hire Business Analytics professionals in India?

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

Business Analytics questions for similar companies