Skip to content

Accenture Business Analytics Interview Questions & Answers

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

About Accenture hiring for Business Analytics roles

Accenture is a global professional services company offering strategy, consulting, technology, operations and digital services. India hosts a large share of its workforce, delivering software engineering, testing, cloud, data and AI projects for clients worldwide. It hires freshers and experienced professionals in India for associate software engineer, test engineer, data analyst and analytics consultant roles.

For Business Analytics roles, this Accenture practice set focuses most on Excel for Business Analysts (8), Case Studies and Guesstimates (7), Financial and Business Analysis (6), Requirements and Agile (4). It has 6 easy, 30 medium, 4 hard questions, so you can start easy and work up to the harder ones.

Company type
Consulting
Headquarters
Dublin, Ireland
Main India offices
Bengaluru, Hyderabad, Pune, Mumbai, Gurugram

Accenture Business Analytics interview process

  1. Online assessment (cognitive + technical MCQs)
  2. Coding assessment
  3. Communication assessment
  4. Technical and HR interview

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

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

Control has 10,000 users with 400 purchases and the variant has 10,000 users with 460 purchases. Calculate the lift.

Save to ▾
Show answer
Control conversion is 400 divided by 10,000, which is 4.0 percent. Variant conversion is 460 divided by 10,000, which is 4.6 percent. The absolute lift is 0.6 percentage points and the relative lift is 0.6 divided by 4.0, which is 15 percent. Before calling it a win, run a two-proportion significance test and check the confidence interval and guardrail metrics.
02

A business tester raises a defect, and the developer closes it as 'works as designed'. How do you resolve it?

Save to ▾
Show answer
Go back to the requirement and acceptance criteria. If the system matches the agreed requirement, the developer is right, and the business need is a change request. If the requirement is unclear or the design misread it, it is a defect, and the requirement wording should be fixed. Discuss it in triage with both parties, using examples. Either way, close the loop with the tester so they understand the outcome and keep trusting the process.
03

What is a balanced scorecard?

Save to ▾
Show answer
A balanced scorecard is a strategic performance framework that tracks objectives and KPIs across four perspectives: financial (revenue growth, margin), customer (NPS, retention), internal processes (cycle time, defect rate) and learning and growth (training hours, employee engagement). The idea is that financial results are lagging, so leaders also need leading measures of what drives future performance. A strategy map links the objectives with cause-and-effect arrows from people to processes to customers to financial outcomes.
04

A hospital chain's average patient waiting time has risen from 30 to 50 minutes. How would you approach the case?

Save to ▾
Show answer
Clarify where the wait is measured: registration, consultation, diagnostics or billing. Split the problem into demand and capacity. On demand, check patient volume, peak-hour mix, walk-ins versus appointments and new departments. On capacity, check doctor availability, no-shows of staff, consultation time per patient and process bottlenecks such as manual billing. Identify the biggest stage and suggest fixes like slot-based appointments, triage and digital billing.
05

Use case vs user story?

Save to ▾
Show answer
A use case describes the full interaction between an actor and the system (main and alternate flows). A user story is a short statement of need from the user's point of view, refined with acceptance criteria.
06

How would you forecast next quarter's sales in Excel?

Save to ▾
Show answer
Use FORECAST.ETS or a trendline on monthly history, check seasonality, compare with a simple moving average and present a range, not a single number.
07

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

Describe how you would model an employee leave approval process in BPMN.

Save to ▾
Show answer
Use one pool for the company with lanes for Employee, Manager and HR system. Start event: leave request submitted. Task: system checks leave balance. Exclusive gateway: balance sufficient? If no, end event that notifies the employee. If yes, user task: manager reviews. Add an interrupting timer boundary event of 3 days that escalates to the skip-level manager. Gateway: approved or rejected. Approved path updates the leave balance and calendar, then both paths notify the employee and end.
09

What is a data table in Excel?

Save to ▾
Show answer
A what-if tool that recalculates a formula for different inputs, for example loan payments across different rates and tenures.
10

What is the difference between XLOOKUP and INDEX-MATCH?

Save to ▾
Show answer
Both look up values flexibly; XLOOKUP is simpler with built-in not-found handling, while INDEX-MATCH works in older Excel versions.
11

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
12

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

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

Tell me about a time you built a business case for a project. Was it approved?

Save to ▾
Show answer
Situation: our support team handled order-status queries manually, about 9,000 a month. Task: I was asked to evaluate a self-service tracking page. Action: I measured handling time from ticket data, estimated deflection conservatively at 40 percent, worked with IT on build and run costs and showed best, base and worst cases with payback. Result: leadership approved the base case. Six months after launch, deflection reached 46 percent, and I presented the benefits review to the same committee.
15

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

What are window functions in SQL and how are they different from GROUP BY?

Save to ▾
Show answer
A window function calculates across a set of related rows using OVER(), but it keeps every original row instead of collapsing them. GROUP BY returns one row per group. For example, SUM(amount) OVER (PARTITION BY region) shows each order next to its region total, which helps compute share of total, rankings, running totals and month-over-month change. Common window functions are ROW_NUMBER, RANK, LAG, LEAD and SUM.
17

How do you calculate monthly revenue growth in SQL?

Save to ▾
Show answer
Aggregate revenue per month and use LAG(revenue) OVER (ORDER BY month) to compute (revenue - previous) / previous.
18

A bank's mobile app logins increased, but digital transactions fell. What could explain this?

Save to ▾
Show answer
Users are coming but not completing transactions, so look at the gap. Possible causes: a release that broke a payment flow, new security steps like extra OTPs adding friction, logins driven by balance checks or offers, or transactions shifting to another channel. Compare the funnel from login to transaction by app version and device, check failure and error rates, and review support complaints before recommending fixes.
19

How do you handle large datasets in Excel?

Save to ▾
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.
20

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

Tell me about a time you discovered a missed requirement late in a project.

Save to ▾
Show answer
Situation: two weeks before go-live of a billing system, a finance user asked how GST credit notes would work, which we had not covered. Task: assess and recover. Action: I analysed the impact with developers, found a simple configuration path for most cases plus a manual step for rare ones, and presented both options with dates to the sponsor. Result: we went live on time with a documented workaround and delivered the full fix next sprint.
22

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
23

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

What are aggregate functions?

Save to ▾
Show answer
Functions that summarise rows into a value, such as COUNT, SUM, AVG, MIN and MAX.
25

Three departments describe the same order process in three different ways during workshops. How do you arrive at the true AS-IS?

Save to ▾
Show answer
Treat each version as a hypothesis. Walk the process physically or observe real cases end to end, and pull a sample of 20 to 30 recent orders from the system to trace what actually happened. Compare timestamps and status changes with each department's story. Then hold a joint session, show the evidence-based map and mark the variants openly. Often all three are partly right because different order types follow different paths, which should be modelled explicitly.
26

A feature launched two months ago is used by only 4 percent of users. What would you do?

Save to ▾
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.
27

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

Gross margin fell from 38 percent to 34 percent in one quarter. How do you investigate?

Save to ▾
Show answer
Break the change into drivers. Price: were discounts or promotions deeper? Mix: did sales shift towards lower-margin products, channels or regions? Cost: did raw material, freight or supplier prices rise, or did currency movements raise import costs? Also check one-offs like inventory write-offs and accounting reclassifications. Build a margin bridge showing how many percentage points each driver contributed, then take the biggest driver to the business owner with a specific action.
29

What is the difference between a test scenario and a test case?

Save to ▾
Show answer
A test scenario is a high-level statement of what to test, usually derived from a business process or user story, such as Customer applies a discount coupon at checkout. A test case is a detailed, executable set of steps with preconditions, test data, expected result and actual result, such as applying an expired coupon to a 1,000 rupee cart shows an expiry message. One scenario usually produces several test cases covering positive, negative and edge conditions.
30

What is a business case document and what does it contain?

Save to ▾
Show answer
A business case justifies why an organisation should invest in a project. It usually contains the problem or opportunity, objectives and success measures, options considered including do nothing, costs and benefits of each option with a financial evaluation such as NPV and payback, risks and assumptions, impact on people and processes, a recommended option and an implementation timeline. A BA often builds it with finance, and it becomes the baseline for checking benefits after delivery.
31

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

What is scope creep and how do you control it?

Save to ▾
Show answer
Uncontrolled growth of requirements. Control it with a clear scope statement, change control process, impact analysis and sponsor approval for additions.
33

What is Customer Acquisition Cost (CAC) and what is CAC payback period?

Save to ▾
Show answer
CAC is total sales and marketing spend in a period divided by new customers acquired in that period. If you spend 10 lakh and gain 2,000 customers, CAC is 500 rupees. CAC payback period is how many months of gross profit from a customer it takes to recover that CAC. A shorter payback means the business can reinvest faster; many subscription businesses aim for under 12 months.
34

What is working capital and why does it matter?

Save to ▾
Show answer
Working capital is current assets minus current liabilities, mainly receivables plus inventory minus payables. It is the money tied up in running daily operations. Too little means the company may struggle to pay suppliers and salaries; too much means cash is locked in slow inventory or unpaid customer invoices. Analysts track it because a growing business often needs more working capital, so fast growth can create cash shortages even when the business is profitable.
35

Tell me about a time a SQL query you wrote gave wrong results. How did you catch it?

Save to ▾
Show answer
Situation: my weekly sales report showed a 12 percent jump that no one could explain. Task: verify the number before it reached leadership. Action: I compared row counts before and after each join and found a new promotions table had multiple rows per order, duplicating revenue. I aggregated promotions per order first and added a test comparing totals with the source. Result: the corrected report went out the same day, and I now check grain on every new join.
36

A ride-hailing app's ride cancellation rate rose from 8 to 14 percent. How would you structure the problem?

Save to ▾
Show answer
First split by who cancels: riders or drivers. For rider cancellations, check wait times, pickup accuracy, price surges and changes in ETA. For driver cancellations, check trip distance, payment mode, low fares, destination visibility and incentive changes. Then segment by city, time of day and area. Link to recent changes like a new pricing rule. Recommend fixes for the largest driver, such as better matching or adjusted incentives.
37

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

A company reports a profit every quarter but is running out of cash. How do you explain and investigate it?

Save to ▾
Show answer
Profit is an accrual figure, while cash depends on timing. Check working capital first: receivables may be growing because customers pay late, inventory may be piling up, or suppliers may be demanding faster payment. Then look at large capex, loan repayments, and dividends. Review the cash flow statement and compute days sales outstanding and inventory days over time. Fixes include tighter credit terms, collection drives, inventory reduction and renegotiating supplier terms.
39

Write an Excel formula for the weighted average selling price across orders.

Save to ▾
Show answer
// B2:B200 = price per unit, C2:C200 = units sold =SUMPRODUCT(B2:B200, C2:C200) / SUM(C2:C200) // a simple AVERAGE(B2:B200) would wrongly give a small order // the same weight as a large one
40

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.

Tips to crack the Accenture Business Analytics interview

  • Practise the communication assessment, which checks spoken English through reading, listening and repeating sentences in a recorded format.
  • Revise MS Office, cloud basics, networking and pseudocode, as Accenture technical MCQs often cover these general IT topics.
  • Read about Accenture's focus on cloud, data and AI and be ready to discuss how you would work in client-facing teams.
  • 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; Accenture interviewers usually ask follow-ups on your first answer.

Frequently asked questions

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

Candidates usually go through 4 stages: Online assessment (cognitive + technical MCQs); Coding assessment; Communication assessment; Technical and HR interview. 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 Accenture Business Analytics interview?

This practice set leans on Excel for Business Analysts (8), Case Studies and Guesstimates (7), Financial and Business Analysis (6), Requirements and Agile (4). Revise those first, then practise explaining one or two of your own projects end to end, because most Accenture interviewers ask you to walk through real work.

Are these the exact questions asked at Accenture?

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

Where does Accenture hire Business Analytics professionals in India?

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

Business Analytics questions for similar companies