01
How do you create a new column from conditions?
Show answer
Use np.where for one condition, np.select for several, or df.apply with a function for custom logic.
Bain & Company Data Analytics Interview Questions & Answers
Curated interview practice questions with answers. These are practice scenarios, not a verified list of past interview questions.
About Bain & Company hiring for Data Analytics roles
Bain & Company is a global management consulting firm that advises businesses on strategy, mergers and acquisitions, customer experience and performance improvement. In India it runs consulting offices and a large capability network that provides research, analytics and expertise support to Bain teams worldwide. It hires associate consultants, analysts and data professionals, and is known for a collaborative, team-focused culture.
For Data Analytics roles, this Bain & Company practice set focuses most on SQL (9), Python for Analysis (5), Power BI (5), Data Storytelling (4). It has 4 easy, 32 medium, 4 hard questions, so you can start easy and work up to the harder ones.
- Company type
- Consulting
- Headquarters
- Boston, USA
- Main India offices
- Gurugram, Mumbai, Bengaluru
Bain & Company Data Analytics interview process
- Online test or resume screening
- Case interview round 1
- Case interview round 2
- Fit and partner round
Typical pattern based on public candidate experiences. Rounds vary by role, team and year.
Solved for Bain & CompanyStart 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
Your A/B test ends with no significant difference. How do you report it?
Show answer
A flat result is still useful. Report the observed difference with its confidence interval, for example -0.3% to +0.8%, which shows the range of effects still possible. State whether the test had enough power for the planned MDE. If it did, conclude that any effect is probably small and the team can choose based on cost or simplicity. Share learnings so the same idea is not retested blindly.
03
What is an action title and why should you use one?
Show answer
An action title states the insight of a chart or slide as a sentence instead of a label. Instead of Monthly Sales by Region, write South region drove 70 percent of the decline since July. Busy executives may read only the titles, so each one should carry the message and, ideally, the so-what. The chart below then proves the title. Read only your titles in order: they should tell the whole story.
04
How do you let users choose Top N customers with a parameter in Tableau?
Show answer
Create an integer parameter Top N with a range of 5 to 50 and show its control. Drag Customer to the Filters shelf, choose the Top tab, select By field, and set it to top Top N by SUM(Sales). Alternatively create a set based on the parameter so you can show Top N versus Others in one chart. If the Top N must respect a category filter, add that category filter to context.
05
Explain GROUP BY with an example.
Show answer
It groups rows sharing values so aggregates run per group, for example SELECT region, SUM(sales) FROM orders GROUP BY region.
06
You loaded a month of sales into the warehouse. How do you check the load is complete and correct?
Show answer
Reconcile against the source: compare row counts, total amount, and counts by day and by store between source and target. Check for duplicate keys, nulls in mandatory columns, and dates outside the expected month. Compare with the previous month to spot big unexplained jumps. Spot-check a few individual transactions end to end. Automate these checks so each future load produces a small pass or fail report.
07
A stakeholder says the Power BI report shows different revenue than their Excel file. How do you troubleshoot?
Show answer
I would first agree on definitions: gross or net, including tax or returns, order date or invoice date. Then compare one small slice, such as one month and one region, in both. I check filters on the report and page, relationships that drop unmatched rows, refresh time versus the Excel extract time, and duplicate rows. Once the gap is explained, I document the definition in the report so the question does not repeat.
08
After a website migration, the share of direct traffic jumped from 15% to 45%. What could cause it?
Show answer
Direct is the default bucket when the source is unknown, so a jump usually means attribution broke. Common causes are redirects that strip UTM parameters, a new referrer policy hiding the referring site, the analytics tag missing on landing pages so sessions start later on the site, payment or login domains not added to the cross-domain or referral exclusion list, and HTTPS to HTTP transitions. Compare landing pages and campaign traffic before and after.
09
How do you detect outliers?
Show answer
Visually with a box plot, with the IQR rule (below Q1 − 1.5×IQR or above Q3 + 1.5×IQR) or a z-score above 3. Then decide with the business whether to cap, remove or keep them.
10
You must present to the sales team that they missed their quarterly target by 18%. How do you handle it?
Show answer
Lead with the fact clearly, then show where the gap came from, such as which regions, products or deal stages, so it becomes actionable rather than a blame session. Separate controllable causes like lower conversion from uncontrollable ones like a delayed product launch. Highlight what did work, and end with two or three specific actions and the metrics to track them. Share the numbers with sales leaders privately first, to avoid surprises.
11
Write SQL to incrementally load new and changed products into a dimension using MERGE.
Show answer
MERGE INTO dim_product t
USING stg_product s
ON t.product_id = s.product_id
WHEN MATCHED AND (t.name <> s.name OR t.category <> s.category) THEN
UPDATE SET name = s.name,
category = s.category,
updated_at = CURRENT_TIMESTAMP
WHEN NOT MATCHED THEN
INSERT (product_id, name, category, updated_at)
VALUES (s.product_id, s.name, s.category, CURRENT_TIMESTAMP);
12
Tell me about a time you migrated or rebuilt reports in a new BI tool.
Show answer
Situation: our team moved 15 Excel and older BI reports into Tableau. Task: I owned the sales set. Action: I listed every metric with its definition, rebuilt the shared data source first, then the dashboards, and ran side-by-side number checks for two weeks with the old reports. I held short demos for users. Result: all reports went live with matching numbers, and refresh effort fell from a day to an automatic schedule.
13
What is a self join and when is it used?
Show answer
Joining a table to itself with aliases, useful for hierarchies such as employees and managers or comparing rows within the same table.
14
Many reporting queries in your team use SELECT DISTINCT to remove duplicate rows. What is the risk?
Show answer
SELECT DISTINCT often hides a real problem, such as a join on the wrong key or a one-to-many join that multiplies rows. The output looks clean, but sums computed before the DISTINCT, or legitimate repeated rows, can be wrong, and DISTINCT adds a costly sort on large tables. Instead, find why duplicates appear, fix the join or aggregate the child table first, and add a uniqueness test on the key.
15
Your pandas script shows SettingWithCopyWarning and a new column does not update. What is happening and how do you fix it?
Show answer
It warns that you may be modifying a temporary copy of a slice, so the change might not reach the original DataFrame, for example df[df.sales > 0]['flag'] = 1. Avoid it by using a single loc call, df.loc[df.sales > 0, 'flag'] = 1, or by calling .copy() when you intentionally create a new subset. Newer pandas versions with copy-on-write make behaviour more predictable, but clear loc assignments remain best practice.
16
A junior analyst wants to load one huge flat table with every column into Power BI instead of a star schema. How do you advise them?
Show answer
A flat table is quick to start and fine for a small one-off analysis. But at scale it bloats the model because repeated text attributes compress poorly, makes DAX filters and time intelligence harder, and breaks when you add a second fact like targets or returns. I would show them a star schema with one fact and a few dimensions, compare model size and measure speed, and let the results convince them.
17
Write SQL to find the median order value overall and per city.
Show answer
-- Works in PostgreSQL, Snowflake, SQL Server (with OVER for SQL Server)
SELECT
city,
PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY order_value) AS median_value,
AVG(order_value) AS mean_value
FROM orders
GROUP BY city
ORDER BY median_value DESC;
18
What are field parameters in Power BI?
Show answer
Field parameters let report users switch which measure or dimension a visual uses through a slicer. For example, one chart can switch between Sales, Profit and Quantity, or between grouping by Region, Category and Channel. This replaces many duplicate visuals or bookmark tricks, keeping the report lighter and easier to maintain. They are created from Modeling, New parameter, Fields, which generates a small table behind the slicer.
19
Orders arrive in the warehouse with customer IDs that do not exist yet in the customer dimension. What do you do?
Show answer
These are late-arriving dimensions. Do not drop the orders, or revenue will be understated. Common practice is to insert a placeholder customer row with the natural key and 'Unknown' attributes, link the order to it, and update that row when full details arrive. Alternatively map to a single Unknown member with key -1. Also monitor how many such rows appear daily, because a spike usually means a broken feed.
20
How do you calculate a running total?
Show answer
SUM(amount) OVER (ORDER BY order_date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) adds up values cumulatively.
21
How do you improve Power BI report performance?
Show answer
Use a star schema, remove unused columns, prefer measures, reduce visuals per page, limit high-cardinality fields and use aggregations or incremental refresh.
22
What is statistical significance vs practical significance?
Show answer
A result can be statistically significant yet too small to matter; always report effect size and business impact together with the p-value.
23
Import mode vs DirectQuery?
Show answer
Import loads data into memory for fast visuals; DirectQuery queries the source live, giving fresh data but slower performance and some DAX limits.
24
What is the difference between a view and a materialised view?
Show answer
A view stores a query and runs it each time; a materialised view stores the result physically and must be refreshed, making reads faster.
25
What are vanity metrics?
Show answer
Vanity metrics look impressive but do not help decisions or reflect real value, such as total app downloads, total registered users or social media likes. They usually only go up. Better alternatives are actionable metrics such as active users, retention by cohort, conversion rate and revenue per user. A quick test: if the number changed, would anyone do anything differently? If not, it probably does not belong on the main dashboard.
26
What is the difference between a data warehouse, a data lake and a lakehouse?
Show answer
A data warehouse stores cleaned, structured data in modelled tables optimised for SQL reporting. A data lake stores raw data of any type, such as logs, JSON and images, cheaply in files, with structure applied when read. A lakehouse combines them: open table formats on lake storage add transactions, schemas and fast SQL on top of files. Analysts typically query the warehouse or the curated layer of a lakehouse.
27
How do you choose the right chart?
Show answer
Line for trends, bar for comparisons, scatter for relationships, histogram for distributions and pie only for few parts of a whole.
28
Write pandas code to calculate monthly revenue from an orders DataFrame.
Show answer
import pandas as pd
orders = pd.read_csv('orders.csv', parse_dates=['order_date'])
orders['revenue'] = orders['qty'] * orders['unit_price']
monthly = (
orders
.groupby(orders['order_date'].dt.to_period('M'))['revenue']
.sum()
.reset_index(name='revenue')
)
print(monthly)
29
How would you find customers who never placed an order?
Show answer
LEFT JOIN customers to orders and keep rows where order_id IS NULL, or use NOT EXISTS, which also handles NULLs safely.
30
A stakeholder wants 20 more visuals added to an already crowded dashboard page. How do you respond?
Show answer
I would ask which decisions each new visual supports and how often they will look at it. Usually a few are essential and the rest are nice to have. I would propose keeping the main page focused on core KPIs and moving detail into drill-through pages, tooltips or a separate analysis tab. Showing a quick mock-up of both versions helps them see that the cleaner page answers questions faster.
31
What is a pivot table and when do you use it?
Show answer
A pivot table summarises large data by dragging fields into rows, columns, values and filters — for example total sales by region and month — without writing formulas.
32
Why is testing many metrics or many variants at once a problem, and how do you handle it?
Show answer
Each comparison at alpha 0.05 has a 5% false positive chance, so checking 20 metrics will probably flag one as significant by luck. This is the multiple comparisons problem. Handle it by choosing one primary metric in advance, treating others as exploratory, and adjusting p-values with Bonferroni or Benjamini-Hochberg when several comparisons matter. With many variants, compare each to control and adjust, or use a larger sample.
33
Explain the common marketing attribution models.
Show answer
Attribution decides how credit for a conversion is shared across touchpoints. Last click gives all credit to the final touch, first click to the first one. Linear splits credit equally, time decay gives more to recent touches, and position-based gives most to first and last. Data-driven attribution uses an algorithm on your own paths to estimate each channel's contribution. Each model answers a different question, so state which one a report uses.
34
Write Python code to test whether conversion differs between control and treatment.
Show answer
from statsmodels.stats.proportion import proportions_ztest, proportion_confint
conversions = [1180, 1295] # control, treatment
visitors = [30000, 30100]
z, p = proportions_ztest(conversions, visitors)
print(f'z = {z:.2f}, p = {p:.4f}')
for c, n in zip(conversions, visitors):
low, high = proportion_confint(c, n, method='wilson')
print(f'rate {c/n:.3%} 95% CI {low:.3%} to {high:.3%}')
35
Tell me about a time you found a mistake in a report after it had already been shared.
Show answer
Situation: a day after sending a weekly report, I noticed one region's numbers included test orders. Task: correct it before decisions were made. Action: I quantified the impact, a 3 percent overstatement, and emailed the same audience with the corrected figures, a short explanation and the fix I had added to prevent repeats. Result: my manager appreciated the quick ownership, and the test-order filter became part of our shared dataset.
36
What is a CTE and when would you use one?
Show answer
A Common Table Expression (WITH name AS (...)) is a named temporary result used inside one query. Use it to break complex logic into readable steps or for recursive queries.
37
What are bookmarks and drill-through in Power BI?
Show answer
Bookmarks save a report view state for navigation; drill-through jumps to a detail page filtered to the item you picked.
38
A manager asks for a dashboard that refreshes every minute. How do you decide the right refresh frequency?
Show answer
Match refresh to how quickly decisions are made. A monthly board pack needs daily refresh at most, while a warehouse dispatch board may need 15-minute or live updates. Faster refresh costs more in source load, licensing and complexity, and can show incomplete data. Ask how quickly someone will act on a change, check when upstream systems finish loading, and always display the last refreshed time on the dashboard.
39
Your scheduled Python report failed silently and nobody noticed for a week. How do you make it reliable?
Show answer
Add logging to a file or central log, wrap the main steps in try and except that send an alert by email or chat on failure, and exit with a non-zero code so the scheduler marks the job failed. Add data checks, such as row counts above a minimum and no missing dates, before sending output. Use a proper scheduler or orchestrator with retries, and include the data date in every report.
40
An inner join between orders and customers returns fewer orders than the orders table has. What could be wrong?
Show answer
Orphan records are child rows whose foreign key has no matching parent, such as orders with a customer_id that does not exist in the customer table. They break joins silently: an inner join drops them and totals fall short. Find them with a LEFT JOIN from the child to the parent and filter where the parent key IS NULL. Then fix the source, add an Unknown member, or report them separately.
Tips to crack the Bain & Company Data Analytics interview
- Practise case interviews with a focus on profitability, market entry and market sizing, keeping your structure simple and logical.
- Prepare concise stories about teamwork and initiative, because Bain places strong emphasis on cultural fit and collaboration in interviews.
- For capability network roles, revise Excel, PowerPoint and basic analytics skills, which are central to day-to-day research and analysis work.
- 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; Bain & Company interviewers usually ask follow-ups on your first answer.
Frequently asked questions
How many rounds are there in the Bain & Company Data Analytics interview?
Candidates usually go through 4 stages: Online test or resume screening; Case interview round 1; Case interview round 2; Fit and partner 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 Bain & Company Data Analytics interview?
This practice set leans on SQL (9), Python for Analysis (5), Power BI (5), Data Storytelling (4). Revise those first, then practise explaining one or two of your own projects end to end, because most Bain & Company interviewers ask you to walk through real work.
Are these the exact questions asked at Bain & Company?
No. These are curated practice questions that match the skills and difficulty usually tested in consulting interviews like Bain & Company's. They are not a leaked or verified list of past questions.
Where does Bain & Company hire Data Analytics professionals in India?
Bain & Company has large teams in Gurugram, Mumbai, Bengaluru. Openings and locations change often, so check the Bain & Company careers page and filter by city and experience.
Data Analytics questions for similar companies
Consulting
ZS Associates
Data Analytics interview questions
Pune, Gurugram, Bengaluru
View questionsConsulting
Publicis Sapient
Data Analytics interview questions
Gurugram, Noida, Bengaluru
View questionsConsulting
Grant Thornton Bharat
Data Analytics interview questions
Gurugram, Mumbai, Bengaluru +3
View questionsConsulting
KPMG
Data Analytics interview questions
Gurugram, Bengaluru, Mumbai +2
View questionsConsulting
Deloitte
Data Analytics interview questions
Hyderabad, Bengaluru, Mumbai +2
View questionsConsulting
EY
Data Analytics interview questions
Bengaluru, Kolkata, Gurugram +2
View questionsMore ways to practise
Company-wise Data Analytics questionsPackage-wise Data Analytics questionsExperience-wise Data Analytics questionsRole-wise Data Analytics questionsCity-wise Data Analytics questionsMost asked Data Analytics questionsScenario-based questionsPractical / hands-on questionsHR & behavioural questionsData Analytics mock interviewOnline assessment questionsTechnical round questionsManagerial round questionsData Analytics topic sheets