01
What is a traceability matrix?
Show answer
A table linking each requirement to design, test cases and delivery status, ensuring nothing is missed and helping assess change impact.
Boston Consulting Group Business Analytics Interview Questions & Answers
Curated interview practice questions with answers. These are practice scenarios, not a verified list of past interview questions.
About Boston Consulting Group hiring for Business Analytics roles
Boston Consulting Group is a global management consulting firm known for strategy work and frameworks such as the growth-share matrix. It advises clients on strategy, digital transformation, operations and sustainability. In India it has consulting offices and capability centres, and it hires associates, analysts, data scientists and engineers, including for its technology and AI unit known as BCG X.
For Business Analytics roles, this Boston Consulting Group practice set focuses most on Excel for Business Analysts (7), Case Studies and Guesstimates (7), Product Analytics (6), Requirements and Agile (5). It has 6 easy, 31 medium, 3 hard questions, so you can start easy and work up to the harder ones.
- Company type
- Consulting
- Headquarters
- Boston, USA
- Main India offices
- Mumbai, New Delhi, Bengaluru, Chennai
Boston Consulting Group Business Analytics interview process
- Online assessment (case or aptitude based)
- Case interview round 1
- Case interview round 2
- Final round with senior leadership
Typical pattern based on public candidate experiences. Rounds vary by role, team and year.
Solved for Boston Consulting GroupStart 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
02
What is the difference between absolute, relative and mixed cell references in Excel?
Show answer
A relative reference like A1 shifts when the formula is copied. An absolute reference like $A$1 stays fixed, useful for a tax rate or target cell. A mixed reference fixes only the column ($A1) or only the row (A$1), which is handy in multiplication grids or when copying a formula across months and products. Press F4 to cycle through the four options while editing a formula.
03
What is an event tracking plan and why does it matter?
Show answer
A tracking plan is a document listing every event the product should log, such as 'checkout_started', with its trigger, properties like price, plan or source, naming rules and owner. It keeps data consistent across web, Android and iOS, prevents duplicate or vague events and makes analysis trustworthy. Without one, teams end up with events like 'click1' and 'buttonClick' meaning the same thing, and analysis becomes guesswork.
04
What is SQL and why do business analysts need it?
Show answer
A language for querying databases. BAs use it to pull data themselves, validate numbers, check reports and answer questions without waiting for engineers.
05
How do you validate data before analysis?
Show answer
Check row counts against the source, nulls, duplicates on keys, value ranges, date coverage and that totals reconcile with finance reports.
06
What is the role of a BA in Scrum?
Show answer
They help the Product Owner refine the backlog, write stories and acceptance criteria, clarify details with developers and support testing and demos.
07
What is sensitivity analysis?
Show answer
Testing how changes in key inputs such as price or volume affect the output, in Excel using data tables or scenario manager.
08
A feature launched two months ago is used by only 4 percent of users. What would you do?
Show answer
Find out whether it is a discovery problem or a value problem. Check how many users saw the entry point, how many tried it and how many returned. If few saw it, test better placement or onboarding prompts. If many tried and few returned, interview users and review session recordings to understand why. Also check if the 4 percent are high-value users. Then decide to improve, reposition or remove it.
09
The totals in your Excel report differ from the finance system by a few rupees. What could cause this?
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.
10
What are the current ratio and the quick ratio?
Show answer
Both measure short-term liquidity. The current ratio is current assets divided by current liabilities; around 1.5 to 2 is often comfortable, though it varies by industry. The quick ratio excludes inventory and prepaid items: (cash plus marketable securities plus receivables) divided by current liabilities. It is stricter because inventory may not sell quickly. A retailer with a current ratio of 1.8 but a quick ratio of 0.4 depends heavily on selling its stock to pay bills.
11
What is a market entry strategy case?
Show answer
Decide whether and how to enter a market by evaluating attractiveness, competition, capabilities and entry mode (build, buy, partner), then risks and next steps.
12
What is the use of the IFERROR function?
Show answer
It returns a custom value when a formula errors out, keeping reports clean, for example =IFERROR(VLOOKUP(...), "Not found").
13
How do you handle large datasets in Excel?
Show answer
Use tables, Power Query, remove volatile functions, filter before calculating and move to Power Pivot or a database when rows reach the millions.
14
Write Excel formulas for IRR with yearly cash flows and XIRR with irregular dates.
Show answer
# Yearly cash flows in B2:B7, year 0 investment negative
=IRR(B2:B7)
# Irregular dates: cash flows in B2:B7, dates in C2:C7
=XIRR(B2:B7, C2:C7)
# XIRR returns an annualised rate based on actual dates,
# which suits SIP returns or projects with uneven payments.
15
Finance asks you to build a monthly cohort retention table in Excel from raw order data. How do you approach it?
Show answer
Add a helper column for each customer's first order month using MINIFS on customer ID, and another for the order month. Compute the month index as the difference in months between them. Then build a PivotTable or COUNTIFS grid with cohort month as rows, month index as columns and distinct customers as values. Divide each cell by the month-zero count to get retention percentages and add a colour scale to show decay.
16
How would you size the market for IT courses in Delhi NCR?
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.
17
An online learning platform finds that only 12 percent of learners complete paid courses. How do you analyse it?
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.
18
How do you evaluate a marketing campaign's ROI?
Show answer
ROI = (incremental profit - campaign cost) / campaign cost. Measure incremental sales using a control group or before-after comparison.
19
A quick-commerce company wants to expand into Tier-2 cities. What would you analyse before recommending it?
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.
20
What is the difference between sequence flow and message flow in BPMN?
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.
21
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?
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.
22
What are heatmaps and session recordings, and when would you use them alongside funnel analysis?
Show answer
Heatmaps aggregate where users click, move and scroll on a page, while session recordings replay individual user sessions. Funnel analysis tells you where users drop off, for example 40 percent leave on the address page; heatmaps and recordings help explain why, such as a hidden Continue button or a confusing pin code field. They are qualitative, so use them to form hypotheses and then validate fixes with an A/B test. Personal data must be masked in recordings.
23
After a redesign, average time spent in the app increased. Is that good?
Show answer
It depends on the product's goal. For a content or learning app, more time may mean more engagement. For a payments or banking app, more time can mean users struggle to complete tasks. Check task completion rate, time to complete key actions, errors, support tickets and retention. A metric is good only when it moves in line with the value users came for.
24
Your project is going to miss its deadline by two weeks. How do you communicate this?
Show answer
Tell the sponsor and key stakeholders as soon as you are confident, not on the deadline. Be direct about the delay, the cause and the impact. Come with options, such as reducing scope to hit the date, adding resources, or moving the date with a phased release, plus your recommendation. Agree on the new plan, update the communication plan and track the recovery visibly.
25
Daily active users dropped 10 percent week over week. How do you investigate?
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.
26
What is a date table in Power BI and why should you mark it as a date table?
Show answer
A date table has one row per day with no gaps, plus columns like Year, Quarter, Month, Week and Fiscal Period. It is related to the fact table date column. Marking it as a date table tells Power BI to use it for time intelligence functions like TOTALYTD, SAMEPERIODLASTYEAR and DATESINPERIOD, which require a continuous date range. It also gives consistent month sorting and fiscal calendars across every report.
27
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?
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.
28
What are DAU, WAU and MAU, and what is the stickiness ratio?
Show answer
DAU, WAU and MAU count unique users active in a day, week and month, where 'active' must be clearly defined, such as completing a core action. The stickiness ratio is DAU divided by MAU and shows how often monthly users return. A ratio of 0.5 means the average monthly user is active about 15 days a month. Daily-use products like messaging aim high, while a travel app naturally has low stickiness.
29
Write Given-When-Then acceptance criteria for applying a discount coupon at checkout.
Show answer
Given a cart of 1,200 rupees and a valid coupon SAVE10 with a minimum order of 1,000 rupees, when the user applies it, then 10 percent is deducted and the new total is shown. Given an expired coupon, when applied, then the message 'This coupon has expired' appears and the total is unchanged. Given a cart below the minimum, when applied, then the user is told how much more to add.
30
What is a PESTEL analysis?
Show answer
PESTEL scans the external environment across Political, Economic, Social, Technological, Environmental and Legal factors. For an electric vehicle maker in India it would cover subsidies and policy, fuel prices and interest rates, consumer attitudes, battery technology, emission targets and safety regulations. It is useful in market entry and strategy cases to spot opportunities and risks beyond the company's control, and pairs well with SWOT.
31
What is a communication plan in a project and what does it include?
Show answer
A communication plan defines who needs what information, when, in which format and from whom. It typically lists stakeholders, their information needs, the channel such as status email, standup, steering meeting or dashboard, frequency, owner and escalation path. It prevents both silence and overload, and makes sure decision-makers hear about risks early. A BA usually keeps it updated as stakeholders change.
32
What are leading and lagging indicators? Give examples.
Show answer
Lagging indicators measure outcomes after they happen, such as monthly revenue, profit or churn. They confirm results but are hard to influence directly. Leading indicators move earlier and predict outcomes, such as demo bookings, trial activations, cart additions or support ticket backlog. A good KPI set pairs them: a sales team tracks qualified pipeline (leading) along with closed revenue (lagging) so it can act before the quarter ends.
33
Guesstimate: how many cups of tea are sold in Delhi per day?
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.
34
A manager says the dashboard total does not match the finance team's Excel sheet. What do you do?
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
What is a boundary event in BPMN, and how do interrupting and non-interrupting boundary events differ?
Show answer
A boundary event is attached to the edge of an activity and reacts to something that happens while that activity is running. An interrupting boundary event (solid double border) cancels the activity and takes the exception path, for example a 24-hour timeout cancelling manual approval. A non-interrupting one (dashed border) starts a parallel path while the activity continues, for example sending a reminder email after 12 hours without stopping the approval task.
36
Write non-functional requirements for an online payment page.
Show answer
NFR-01 Performance: the payment page loads within 2 seconds for 95 percent of requests at 500 concurrent users. NFR-02 Availability: 99.9 percent monthly uptime outside planned maintenance. NFR-03 Security: card data is never stored by the application, and all traffic uses TLS 1.2 or higher. NFR-04 Compliance: the flow meets PCI DSS and RBI payment guidelines. NFR-05 Usability: works on mobile screens from 360 pixels wide. NFR-06 Audit: every transaction attempt is logged with a timestamp.
37
What is horizontal and vertical analysis of financial statements?
Show answer
Horizontal analysis compares line items across periods, showing growth, for example revenue up 18 percent year on year while employee costs grew 30 percent. Vertical analysis expresses each item as a percentage of a base within one period, such as each expense as a percentage of revenue, or each asset as a percentage of total assets. Together they show both trends and structure, and vertical analysis also makes companies of different size comparable.
38
What is an issue tree and how does a hypothesis-driven approach work?
Show answer
An issue tree breaks the main question into smaller, MECE sub-questions until each can be answered with data, such as 'why are profits down?' into revenue and cost branches. A hypothesis-driven approach starts with a likely answer, for example 'profit fell because delivery costs rose', and uses the tree to decide which data proves or disproves it first. It focuses effort and keeps the case structured and fast.
39
What are acceptance criteria?
Show answer
Clear, testable conditions a story must meet to be accepted, often written as Given-When-Then scenarios.
40
How can LET and LAMBDA make complex Excel formulas easier to maintain? Give an example.
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
Tips to crack the Boston Consulting Group Business Analytics interview
- Practise interviewer-led and candidate-led cases with a partner, paying attention to clear structure, hypotheses and summarising recommendations.
- Work on quick, accurate calculations and chart reading, since case interviews often include data interpretation under time pressure.
- For BCG X or analytics roles, be ready for coding, SQL and machine learning questions in addition to business cases.
- 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; Boston Consulting Group interviewers usually ask follow-ups on your first answer.
Frequently asked questions
How many rounds are there in the Boston Consulting Group Business Analytics interview?
Candidates usually go through 4 stages: Online assessment (case or aptitude based); Case interview round 1; Case interview round 2; Final round with senior leadership. 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 Boston Consulting Group Business Analytics interview?
This practice set leans on Excel for Business Analysts (7), Case Studies and Guesstimates (7), Product Analytics (6), Requirements and Agile (5). Revise those first, then practise explaining one or two of your own projects end to end, because most Boston Consulting Group interviewers ask you to walk through real work.
Are these the exact questions asked at Boston Consulting Group?
No. These are curated practice questions that match the skills and difficulty usually tested in consulting interviews like Boston Consulting Group's. They are not a leaked or verified list of past questions.
Where does Boston Consulting Group hire Business Analytics professionals in India?
Boston Consulting Group has large teams in Mumbai, New Delhi, Bengaluru, Chennai. Openings and locations change often, so check the Boston Consulting Group careers page and filter by city and experience.
Business Analytics questions for similar companies
Consulting
Grant Thornton Bharat
Business Analytics interview questions
Gurugram, Mumbai, Bengaluru +3
View questionsConsulting
PwC
Business Analytics interview questions
Kolkata, Bengaluru, Mumbai +2
View questionsConsulting
EY
Business Analytics interview questions
Bengaluru, Kolkata, Gurugram +2
View questionsConsulting
ZS Associates
Business Analytics interview questions
Pune, Gurugram, Bengaluru
View questionsConsulting
Accenture
Business Analytics interview questions
Bengaluru, Hyderabad, Pune +2
View questionsConsulting
Publicis Sapient
Business Analytics interview questions
Gurugram, Noida, Bengaluru
View questionsMore ways to practise
Company-wise Business Analytics questionsPackage-wise Business Analytics questionsExperience-wise Business Analytics questionsRole-wise Business Analytics questionsCity-wise Business Analytics questionsMost asked Business Analytics questionsScenario-based questionsPractical / hands-on questionsHR & behavioural questionsBusiness Analytics mock interviewOnline assessment questionsTechnical round questionsManagerial round questionsBusiness Analytics topic sheets