Skip to content

Barclays Business Analytics Interview Questions & Answers

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

About Barclays hiring for Business Analytics roles

Barclays is a British universal bank with retail, corporate and investment banking businesses. Its India service and technology centres in Pune, Chennai and Noida support global technology, operations, risk and analytics. It hires for software engineers, test engineers, data analysts, business analysts and risk analysts.

For Business Analytics roles, this Barclays practice set focuses most on Excel for Business Analysts (10), Product Analytics (6), SQL for Business Analysis (5), Financial and Business Analysis (3). It has 7 easy, 30 medium, 3 hard questions, so you can start easy and work up to the harder ones.

Company type
Banking & finance
Headquarters
London, United Kingdom
Main India offices
Pune, Chennai, Noida, Mumbai

Barclays Business Analytics interview process

  1. Online assessment (aptitude + technical)
  2. Technical round
  3. Managerial round
  4. HR round

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

Solved for BarclaysStart 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 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;
02

How do you evaluate a marketing campaign's ROI?

Save to ▾
Show answer
ROI = (incremental profit - campaign cost) / campaign cost. Measure incremental sales using a control group or before-after comparison.
03

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

Why should you avoid bidirectional relationships in a Power BI model?

Save to ▾
Show answer
Relationships normally filter one way, from the dimension (one side) to the fact (many side). Bidirectional filtering lets facts filter dimensions too, which can create ambiguous filter paths, unexpected totals and slower queries, especially with multiple fact tables. Prefer a clean star schema with single-direction filters, and when you need a reverse filter for one measure, use CROSSFILTER or TREATAS inside CALCULATE instead of changing the model globally.
05

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

Describe a time your analysis found a cost-saving opportunity.

Save to ▾
Show answer
Situation: monthly cloud and software subscription costs had grown 35 percent in a year without anyone tracking why. Task: my manager asked me to review them. Action: I combined invoices with user login data in Excel and found 140 licences unused for over 90 days and two tools doing the same job. Result: we cancelled unused licences and consolidated tools, saving about 18 lakh rupees a year, and I set up a quarterly licence review report.
07

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

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

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

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

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

What is a subquery and when would you use it?

Save to ▾
Show answer
A query nested inside another, used for filtering or calculating values such as customers whose spend is above the average.
13

What is ARPU and how is it calculated?

Save to ▾
Show answer
ARPU, Average Revenue Per User, is total revenue in a period divided by the average number of users in that period. If a telecom-style app earns 50 lakh in a month from 25,000 average users, ARPU is 200 rupees. It is tracked to see whether growth comes from more users or more value per user. ARPPU, revenue per paying user, is used when only some users pay.
14

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

What is user story mapping and how does it help plan releases?

Save to ▾
Show answer
User story mapping arranges stories in two dimensions. Across the top is the user journey as a sequence of activities, for example search, compare, buy and track. Below each activity, stories are stacked by priority. Drawing horizontal lines across the map creates release slices, where the first slice is a thin end-to-end MVP that covers every step at a basic level. It prevents a flat backlog where teams build one area deeply while the journey stays incomplete.
16

What is the difference between alpha testing and beta testing?

Save to ▾
Show answer
Alpha testing is done internally, by employees or a selected group, in a controlled environment before the product is released to outsiders, and aims to catch major issues early. Beta testing releases the product to a limited group of real external users in real conditions to gather feedback on usability, performance and missing features before general release. For a mobile app, beta often uses store testing tracks, and feedback is fed into the final release backlog.
17

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

Write an Excel formula to count the number of unique customers in a column.

Save to ▾
Show answer
// Excel 365 =COUNTA(UNIQUE(A2:A500)) // unique customers in the North region only =COUNTA(UNIQUE(FILTER(A2:A500, B2:B500="North"))) // older versions (no blanks in range) =SUMPRODUCT(1/COUNTIF(A2:A500, A2:A500))
19

How would you measure the success of a new feature?

Save to ▾
Show answer
Define a goal metric, a baseline and guardrail metrics, run an experiment or before-after comparison and review adoption, retention and revenue impact.
20

What are guardrail metrics in experiments?

Save to ▾
Show answer
Guardrail metrics are measures that must not get worse while you try to improve the primary metric. For a test aimed at increasing conversion, guardrails might be refund rate, page load time, unsubscribe rate and customer support tickets. If the primary metric improves but a guardrail drops significantly, the change is not shipped as is. They protect long-term health from short-term optimisation.
21

UAT starts tomorrow, but the business has not nominated any testers. What do you do?

Save to ▾
Show answer
Escalate immediately to the business sponsor with the impact: each day without testers delays sign-off and go-live. Ask for named testers with protected time, even part-time. Meanwhile, prepare so no time is lost: finalise test cases, check the environment and data, and plan a short tester briefing. If testers cannot be released, propose re-planning UAT dates rather than letting IT or the BA test on the business's behalf, because acceptance must come from the users.
22

What is the novelty effect, and why should A/B tests run for full weeks?

Save to ▾
Show answer
The novelty effect is a temporary lift because users are curious about something new, which fades after a few days; the opposite, change aversion, causes a temporary drop. Running tests for at least one or two full weeks covers weekday and weekend behaviour and lets these effects settle. You can also check whether the lift is stable over time and among new users who never saw the old version.
23

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

A stakeholder's only requirement is 'make the app faster'. How do you turn this into clear requirements?

Save to ▾
Show answer
Ask which screens or actions feel slow, for which users, on which devices and networks, and how it affects the business, such as checkout drop-off. Gather current timings from monitoring data. Then write measurable non-functional requirements, for example 'the search results page loads within 2 seconds for 95 percent of requests on a 4G connection'. Confirm targets with the stakeholder and agree how they will be tested.
25

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

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

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

Which what-if analysis tools does Excel have?

Save to ▾
Show answer
Goal Seek (find the input for a target output), Data Tables (see outputs for many inputs) and Scenario Manager (save best, base and worst cases).
29

How do you find duplicate customers?

Save to ▾
Show answer
SELECT email, COUNT(*) FROM customers GROUP BY email HAVING COUNT(*) > 1;
30

When would you use SUMPRODUCT instead of SUMIFS?

Save to ▾
Show answer
SUMIFS is faster and easier for sums with AND conditions on ranges. SUMPRODUCT multiplies arrays and sums the result, so it handles cases SUMIFS cannot: weighted totals like price times quantity, OR logic, conditions on calculated values such as MONTH(date)=4, or comparing two columns row by row. On very large sheets SUMPRODUCT is slower, so prefer SUMIFS or a helper column when possible.
31

Write a UAT test case for logging in to a banking app with OTP.

Save to ▾
Show answer
Test case ID: UAT-LOGIN-03. Precondition: registered customer with a verified mobile number. Steps: 1. Open the app and enter the registered mobile number. 2. Tap Send OTP. 3. Enter the 6-digit OTP received by SMS within 3 minutes. 4. Tap Verify. Expected result: the customer lands on the account dashboard, and the login is recorded in the activity log. Related negative cases: wrong OTP shows an error, and three wrong attempts lock login for 30 minutes.
32

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

What is the difference between absolute, relative and mixed cell references in Excel?

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

How do you handle NULL values when calculating averages?

Save to ▾
Show answer
AVG ignores NULLs; use COALESCE(col, 0) if NULLs should count as zero, depending on the business meaning.
35

What are the current ratio and the quick ratio?

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

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))
37

What is the difference between a calculated column and a measure in Power BI?

Save to ▾
Show answer
A calculated column is computed row by row at refresh time and stored in the model, so it uses memory and can be used in slicers, rows and relationships. A measure is computed at query time based on the current filters, so it is not stored and responds to slicers. Use a column for attributes such as an age band, and a measure for aggregations such as Total Sales or Margin %.
38

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

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

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.

Tips to crack the Barclays Business Analytics interview

  • Learn retail and investment banking basics like accounts, payments, trade lifecycle and regulatory reporting.
  • Revise testing concepts and automation tools if applying for QA roles, as banking systems need heavy regression testing.
  • Read Barclays' values of Respect, Integrity, Service, Excellence and Stewardship for behavioural answers.
  • 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; Barclays interviewers usually ask follow-ups on your first answer.

Frequently asked questions

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

Candidates usually go through 4 stages: Online assessment (aptitude + technical); Technical round; Managerial 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 Barclays Business Analytics interview?

This practice set leans on Excel for Business Analysts (10), Product Analytics (6), SQL for Business Analysis (5), Financial and Business Analysis (3). Revise those first, then practise explaining one or two of your own projects end to end, because most Barclays interviewers ask you to walk through real work.

Are these the exact questions asked at Barclays?

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

Where does Barclays hire Business Analytics professionals in India?

Barclays has large teams in Pune, Chennai, Noida, Mumbai. Openings and locations change often, so check the Barclays careers page and filter by city and experience.

Business Analytics questions for similar companies