Skip to content

Wipro Business Analytics Interview Questions & Answers

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

About Wipro hiring for Business Analytics roles

Wipro is an Indian multinational technology services and consulting company providing IT, cloud, cybersecurity, engineering and data analytics services to enterprises worldwide. Its delivery teams work on application development, quality engineering and data platforms for clients in sectors like banking, healthcare and energy. In India it hires for testing, data analysis, support and development roles through programmes such as Wipro Elite NTH.

For Business Analytics roles, this Wipro practice set focuses most on Requirements and Agile (6), Business Metrics and KPIs (6), Process Modelling and BPMN (4), Financial and Business Analysis (4). It has 20 easy, 19 medium, 1 hard questions, so you can start easy and work up to the harder ones.

Company type
IT services
Headquarters
Bengaluru, India
Main India offices
Bengaluru, Hyderabad, Pune, Chennai, Kolkata

Wipro Business Analytics interview process

  1. Online assessment (aptitude + written communication)
  2. Coding test
  3. Technical interview
  4. HR round

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

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

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

How is a product owner's role different from a business analyst's role?

Save to ▾
Show answer
The product owner owns the product vision and the backlog order, makes final priority decisions and accepts completed work on behalf of the business. The business analyst works on understanding problems in depth: eliciting and analysing requirements, modelling processes and data, writing detailed stories and acceptance criteria and supporting the team and testers. In smaller teams one person may do both, but the PO decides what, while the BA clarifies how it should work.
03

What is the difference between SQL and Excel for analysis?

Save to ▾
Show answer
Excel suits small to medium data and quick ad-hoc work; SQL queries large databases directly and repeatably.
04

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

What is a stakeholder analysis?

Save to ▾
Show answer
Identifying everyone affected by the project and mapping their influence and interest to decide how to communicate with and involve each group.
06

What is a star schema and why do BI tools prefer it?

Save to ▾
Show answer
A star schema has one central fact table holding numeric events (sales, orders) linked to surrounding dimension tables (date, product, customer, region). BI tools prefer it because filters flow cleanly from dimensions to facts, DAX and Tableau calculations stay simple, and compression and query performance improve. A flat single table repeats text values and gets slow, while a snowflake with many chained lookups makes filtering and maintenance harder.
07

What is UAT sign-off and who should give it?

Save to ▾
Show answer
UAT sign-off is the formal acceptance by the business that the solution meets agreed requirements and is fit to go live, often with a list of known open defects and agreed workarounds. It should be given by the accountable business owner or product owner, not by the IT team or the BA. The BA prepares the evidence: test execution summary, defect status and traceability to requirements. Sign-off is recorded in writing, usually by email or in the test management tool.
08

What is the hierarchy of epic, feature and user story in Agile?

Save to ▾
Show answer
An epic is a large body of work that delivers a major business goal and spans several sprints, such as 'Online loan application'. It is broken into features or capabilities, such as 'Document upload'. Each feature is split into user stories small enough to finish in one sprint, such as 'As an applicant, I want to upload my PAN card photo so that I do not need to visit a branch'.
09

Write Excel formulas for IRR with yearly cash flows and XIRR with irregular dates.

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

What are fixed costs and variable costs?

Save to ▾
Show answer
Fixed costs stay constant regardless of volume, such as rent; variable costs change with volume, such as raw materials.
11

What is data storytelling and why does it matter for analysts?

Save to ▾
Show answer
Data storytelling combines data, visuals and narrative so the audience understands what happened, why, and what to do. A good story has context, a clear insight, supporting evidence in one or two simple charts and a recommendation. Accurate numbers alone rarely change decisions; people act when they see the implication. Remove chart clutter, highlight the key point with colour and use titles that state the conclusion.
12

What is the difference between a Tableau extract and a live connection?

Save to ▾
Show answer
A live connection queries the source database every time the view changes, so data is current but speed depends on the database. An extract (.hyper file) is a compressed snapshot stored by Tableau that is fast to query and can be refreshed on a schedule, but it is only as fresh as the last refresh. Extracts suit large, slow or remote sources; live suits fast warehouses and real-time needs.
13

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

What steps would you follow to create a tracking plan for a new 'save for later' feature?

Save to ▾
Show answer
Start from the questions to answer: how many users discover it, use it and later buy saved items. Define events such as save_clicked, saved_item_viewed, saved_item_removed and saved_item_purchased, with properties like product ID, price, source screen and platform. Follow the existing naming convention, assign owners, review with developers, and test events in a staging build. Build the dashboard before launch so data is checked on day one.
15

Write a DAX measure for the product return rate that avoids divide-by-zero errors.

Save to ▾
Show answer
Return Rate % = VAR ReturnedQty = SUM ( Returns[Quantity] ) VAR SoldQty = SUM ( Sales[Quantity] ) RETURN DIVIDE ( ReturnedQty, SoldQty, 0 ) // DIVIDE returns the third argument (0) when SoldQty is zero or blank. // Format the measure as a percentage in the model.
16

What is a process flow and which tools do you use?

Save to ▾
Show answer
A diagram of steps, decisions and owners in a process, made using BPMN or flowcharts in tools like Visio, Lucidchart or draw.io.
17

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

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

A new onboarding flow increased sign-ups by 15 percent, but Day-7 retention fell. How do you analyse this?

Save to ▾
Show answer
Check whether the extra sign-ups are lower-intent users who would naturally retain less. Compare Day-7 retention for comparable users in both versions and count retained users in absolute terms, not just rates. If the new flow skips a step that led users to the aha moment, retention per user may truly fall. The decision depends on whether total retained, valuable users went up or down.
20

What is the difference between capex and opex?

Save to ▾
Show answer
Capex (capital expenditure) is spending on long-term assets that benefit several years, such as machinery, buildings or capitalised software development. It goes on the balance sheet and is expensed gradually through depreciation or amortisation. Opex (operating expenditure) covers day-to-day running costs such as salaries, rent and cloud subscriptions, and is expensed in the period it occurs. Moving from owned servers to cloud services shifts IT spending from capex to opex, which changes how budgets and business cases look.
21

Write an Excel formula to extract the domain from an email address.

Save to ▾
Show answer
// Excel 365 =TEXTAFTER(A2, "@") // any version =MID(A2, FIND("@", A2) + 1, LEN(A2)) // Flash Fill (Ctrl+E) also works for one-off cleanup
22

What is gap analysis?

Save to ▾
Show answer
Compare the current state (as-is) with the desired state (to-be), list the gaps in process, people or technology, and plan actions to close them.
23

What is a North Star metric and how do you choose one?

Save to ▾
Show answer
A North Star metric is the single measure that best captures the value customers get from the product and predicts long-term revenue. Examples are weekly active learners for an ed-tech app or orders delivered on time for a delivery business. Choose one that reflects customer value, can be influenced by teams and leads revenue. Support it with input metrics such as activation, frequency and retention that teams can work on directly.
24

Difference between INNER JOIN and LEFT JOIN?

Save to ▾
Show answer
INNER returns only matching rows; LEFT returns all rows from the left table and NULLs where there is no match.
25

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

Where do you see yourself in five years as a business analyst?

Save to ▾
Show answer
Show ambition that fits the role. For example: in five years I see myself as a senior business analyst who owns a business domain, such as payments or supply chain, leads requirement and analytics work for major initiatives and mentors juniors. To get there I am building strong SQL and Power BI skills, learning the domain deeply and taking on more stakeholder-facing work. I would like to grow that path within this organisation.
27

What is SQL and why do business analysts need it?

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

What are wireframes and why are they useful for a BA?

Save to ▾
Show answer
Low-fidelity layouts of screens that help stakeholders visualise and agree on requirements before development starts.
29

What is the difference between gross margin and net margin?

Save to ▾
Show answer
Gross margin is revenue minus cost of goods sold, divided by revenue, and shows how profitable the product itself is. Net margin is net profit after all expenses, including salaries, rent, marketing, interest and tax, divided by revenue. A company can have a healthy 60 percent gross margin but a negative net margin if it overspends on marketing or overheads, which tells you where to look for fixes.
30

What is the difference between revenue and profit?

Save to ▾
Show answer
Revenue is total money from sales; profit is what remains after subtracting all costs and expenses.
31

Explain exclusive, parallel and inclusive gateways in BPMN.

Save to ▾
Show answer
An exclusive gateway (diamond with X) sends the flow down exactly one path based on a condition, for example approved or rejected. A parallel gateway (diamond with +) splits into all paths at once and, when joining, waits for every path to finish. An inclusive gateway (diamond with O) activates one or more paths whose conditions are true and joins only those that were activated. Choosing the wrong one causes deadlocks or duplicated work in automated processes.
32

What is a user story and what makes it good?

Save to ▾
Show answer
A short requirement written as 'As a user, I want X so that Y', backed by acceptance criteria. Good stories follow INVEST: independent, negotiable, valuable, estimable, small and testable.
33

What is a PESTEL analysis?

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

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

What is the difference between a task and a sub-process in BPMN?

Save to ▾
Show answer
A task is an atomic unit of work that you do not break down further in the diagram, such as Verify PAN details. A sub-process is a compound activity that contains its own flow of tasks, events and gateways, shown with a small plus sign when collapsed. Sub-processes keep high-level diagrams readable: the main map shows Credit Check as one box, and a separate detailed view explains its internal steps.
36

What steps do you follow to plan and run a UAT cycle?

Save to ▾
Show answer
Plan: agree scope, entry and exit criteria, testers and schedule with the business owner. Prepare: write scenarios and test cases from requirements, set up the environment and test data, and brief testers. Execute: run test cases in daily sessions, log defects with evidence and hold a daily triage. Monitor: report progress, pass rate and open defects by severity. Close: check exit criteria, get the business sign-off with known issues documented, and hold a short lessons-learned review.
37

What are dynamic array functions in Excel and how do they help analysts?

Save to ▾
Show answer
Dynamic array functions return several values that spill into neighbouring cells. UNIQUE lists distinct values, SORT and SORTBY order data, FILTER returns rows meeting conditions, SEQUENCE builds number series, and XLOOKUP can return whole rows. For example =SORT(UNIQUE(FILTER(Sales[Region], Sales[Year]=2026))) builds a live region list. They replace many helper columns and Ctrl+Shift+Enter array formulas, and the # operator references a full spill range.
38

What is a date table in Power BI and why should you mark it as a date table?

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

What are heatmaps and session recordings, and when would you use them alongside funnel analysis?

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

What is the difference between a pool and a lane in BPMN?

Save to ▾
Show answer
A pool represents a separate participant in a process, such as the customer, your company or an external bank. A lane is a subdivision inside a pool, usually a department, role or system, such as Sales, Finance and Warehouse within your company. Sequence flows can cross lanes within one pool, but communication between two pools must be shown with message flows, because separate participants do not share one controlled flow.

Tips to crack the Wipro Business Analytics interview

  • Prepare for the essay writing section in the online test by practising short, clear, grammatically correct essays on general topics.
  • Revise basic coding problems on strings and arrays plus fundamentals of DBMS, operating systems and computer networks.
  • Learn about Wipro's values, known as the Spirit of Wipro, and its focus areas such as cloud and cybersecurity.
  • 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; Wipro interviewers usually ask follow-ups on your first answer.

Frequently asked questions

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

Candidates usually go through 4 stages: Online assessment (aptitude + written communication); Coding test; Technical interview; 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 Wipro Business Analytics interview?

This practice set leans on Requirements and Agile (6), Business Metrics and KPIs (6), Process Modelling and BPMN (4), Financial and Business Analysis (4). Revise those first, then practise explaining one or two of your own projects end to end, because most Wipro interviewers ask you to walk through real work.

Are these the exact questions asked at Wipro?

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

Where does Wipro hire Business Analytics professionals in India?

Wipro has large teams in Bengaluru, Hyderabad, Pune, Chennai, Kolkata. Openings and locations change often, so check the Wipro careers page and filter by city and experience.

Business Analytics questions for similar companies