Zensar Technologies Business Analytics Interview Questions & Answers
Curated interview practice questions with answers. These are practice scenarios, not a verified list of past interview questions.
About Zensar Technologies hiring for Business Analytics roles
Zensar Technologies is an Indian IT services company and part of the RPG Group. It provides digital experience, application engineering, testing, cloud and data services to clients in manufacturing, retail, financial services and hi-tech. In India it hires for software engineers, test engineers and data professionals.
For Business Analytics roles, this Zensar Technologies practice set focuses most on Stakeholder Communication (6), UAT and BA Documentation (5), Power BI and Tableau (4), Process Modelling and BPMN (4). It has 23 easy, 17 medium questions, so you can start easy and work up to the harder ones.
Company type
IT services
Headquarters
Pune, India
Main India offices
Pune, Hyderabad, Bengaluru
Zensar Technologies Business Analytics interview process
Online assessment (aptitude + reasoning)
Coding test
Technical interview
HR round
Typical pattern based on public candidate experiences. Rounds vary by role, team and year.
Solved for Zensar TechnologiesStart 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.
TAM, Total Addressable Market, is total demand for the product if every possible customer bought it. SAM, Serviceable Available Market, is the part you can reach with your model, geography and channels. SOM, Serviceable Obtainable Market, is the share you can realistically capture in the next few years given competition. For an online tutoring startup in India, TAM is all school students, SAM those online in target cities, SOM a small share of that.
02
What is the difference between ROW_NUMBER, RANK and DENSE_RANK?
All three number rows within a window ordered by a column. ROW_NUMBER gives a unique sequence 1, 2, 3 even for ties. RANK gives ties the same number and then skips, so 1, 1, 3. DENSE_RANK gives ties the same number without gaps, so 1, 1, 2. Use ROW_NUMBER to pick exactly one row per group, such as the latest order, and DENSE_RANK for 'top 3 distinct salary levels' type questions.
03
Write a UAT test case for logging in to a banking app with OTP.
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.
04
What is the difference between Power BI Desktop, Power BI Service and Power BI Mobile?
Power BI Desktop is the free Windows app where you connect to data, model it, write DAX and design reports. Power BI Service is the cloud portal where you publish reports, schedule refresh, build dashboards, set permissions and share with users. Power BI Mobile is the phone app for viewing reports on the go. A typical flow is build in Desktop, publish to a Service workspace, and consume on web or mobile.
05
What is a swimlane diagram and how is it different from a simple flowchart?
A simple flowchart shows the sequence of steps and decisions but not who performs them. A swimlane diagram divides the chart into horizontal or vertical lanes, one per role, team or system, and places each step in the lane of its owner. This makes handoffs visible, because every arrow crossing a lane boundary is a handoff where delays, errors and unclear ownership often occur. BPMN lanes are a standardised form of swimlanes.
06
What is the difference between defect severity and defect priority?
Severity describes the impact of a defect on the system or business, such as critical when payments fail or low for a spelling mistake. Priority describes how urgently it must be fixed, which is a business decision. They can differ: a wrong company logo on the login page is low severity but high priority before a launch, while a crash in a rarely used year-end report may be high severity but lower priority if the report is months away.
07
Tell me about a time you received critical feedback on your work.
Situation: my manager said my first analysis deck was hard to follow. Task: improve it before it went to the client. Action: I asked for specific examples, learned that I had put twenty charts before any conclusion, and restructured it with the recommendation first, three supporting charts and an appendix. Result: the client meeting went well, and I now ask a colleague to review my storyline before every major presentation.
08
How do you write an effective executive summary for an analysis report?
Put it first and keep it to one page or five lines on a slide. Start with the answer or recommendation, then the two or three key findings that support it, each with a number, then the impact in rupees or percentage, and finally the decision or action needed and by when. Avoid methodology details, which go in the appendix. Test it by asking whether a busy leader could act after reading only this section.
09
What is user story mapping and how does it help plan releases?
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.
10
What is horizontal and vertical analysis of financial statements?
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.
11
What is a power-interest grid and how do you use it?
A power-interest grid maps stakeholders by how much influence they have over the project and how interested or affected they are. High power and high interest: manage closely with regular involvement. High power, low interest: keep satisfied with concise updates. Low power, high interest: keep informed, for example end users. Low power, low interest: monitor. It helps a BA decide who to consult, how often and in what format.
12
What are the four basic categories of elements in BPMN?
BPMN groups its shapes into four categories. Flow objects are events (circles), activities (rounded rectangles) and gateways (diamonds). Connecting objects are sequence flows, message flows and associations. Swimlanes are pools and lanes that show participants and roles. Artifacts are data objects, groups and text annotations that add context without changing the flow. Knowing these four groups lets you read almost any BPMN diagram quickly.
13
Write an Excel formula to count the number of unique customers in a column.
// 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))
14
What is the difference between revenue and profit?
Average Order Value is total revenue divided by number of orders. If an online store earns 9 lakh from 1,500 orders, AOV is 600 rupees. Businesses increase it with bundles, cross-sell and upsell recommendations, free delivery above a threshold, volume discounts and premium options. Watch margin and conversion while doing so, because a high free-delivery threshold can raise AOV but reduce the number of orders.
16
What is the difference between a test scenario and a test case?
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.
17
What are start, intermediate and end events in BPMN?
Events are circles that show something happening. A start event (thin border) triggers the process, such as a form submitted or a timer firing on the first of the month. An intermediate event (double border) happens during the process, such as waiting for a payment message or a 48-hour timer. An end event (thick border) marks where a path finishes and can carry a result such as a message, an error or termination of all paths.
18
What is the difference between a chart and a dashboard?
XLOOKUP can look left or right, uses exact match by default, returns a custom value if nothing is found and doesn't break when columns move. VLOOKUP only looks right and needs a column number.
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.
21
Tell me about yourself, for a business analyst role.
Keep it to about 90 seconds in a present, past, future flow. For example: I am a commerce graduate working as an analyst intern, where I build Excel and Power BI reports and write SQL queries for the sales team. Earlier, my college project analysed customer churn for a local gym and recommended changes they adopted. I want to grow as a business analyst because I enjoy turning business problems into clear requirements and data-driven decisions.
22
What is the difference between a process, a procedure and a work instruction?
A process describes what happens end to end to achieve an outcome, across roles, such as customer onboarding. A procedure describes how one part of that process is carried out and who is responsible, such as the KYC verification procedure. A work instruction is the most detailed, step-by-step guide for a single task, often with screenshots, such as how to upload a document in the CRM. BAs usually model processes and reference the other two.
23
What does expectation management mean for a business analyst?
It means making sure stakeholders know realistically what will be delivered, when, and with what limits, before they form their own assumptions. A BA confirms scope in writing, states assumptions and dependencies, shares estimates with ranges, and flags risks early. When something changes, they update stakeholders immediately with options. Most stakeholder conflict comes from surprises, not from bad news itself.
24
How do you build a PivotTable to analyse sales by region and product?
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.
26
How do you analyse variance between budget and actual?
Quantify both effects: extra sessions and revenue from notifications versus users lost through uninstalls and notification opt-outs, including their lifetime value. Segment by notification type and frequency to find which ones annoy users. Recommend frequency caps, personalised timing, relevance rules and easy preference settings, then test them with uninstall rate and opt-out rate as guardrails. Short-term engagement should not cost long-term users.
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.
29
What is the debt-to-equity ratio and how do you interpret it?
Debt-to-equity equals total borrowings divided by shareholders' equity. It shows how much the company relies on borrowed money versus owners' funds. A ratio of 0.5 means 50 paise of debt for every rupee of equity. Higher leverage can boost returns but raises interest burden and risk in downturns. Acceptable levels depend on the industry: utilities and infrastructure carry more debt than software firms. Always read it with interest coverage, which is EBIT divided by interest expense.
30
Tell me about a time you misunderstood a requirement. What did you learn?
Situation: I was asked for 'monthly active customers' and built it on login data. Task: deliver the report for a review. Action: in the demo, the stakeholder said active meant customers who purchased, not logged in. I owned the mistake, rebuilt the measure in two days and wrote down the definition for sign-off. Result: the report was accepted, and now I always confirm definitions and sample outputs with stakeholders before building anything.
31
What are the steps to publish and share a Power BI report with your team?
Save the .pbix and click Publish, choosing the team workspace. In the Service, set data source credentials and, for on-premises data, configure the gateway. Schedule refresh. Then share by giving workspace access to editors, or package it as an app for viewers, and apply row-level security roles if needed. Finally, check it on web and mobile and send the link with a short note on what each page answers.
32
What are heatmaps and session recordings, and when would you use them alongside funnel analysis?
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.
33
Why do Agile teams estimate in story points rather than hours?
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.
34
How would you measure the success of a new feature?
Define a goal metric, a baseline and guardrail metrics, run an experiment or before-after comparison and review adoption, retention and revenue impact.
A BA bridges business and technology: gathers requirements, analyses data and processes, documents BRD/FRD and makes sure the final solution actually solves the business problem.
36
What is the difference between a calculated column and a measure in Power BI?
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 %.
37
What is the difference between absolute, relative and mixed cell references in Excel?
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.
38
Write a defect report for an invoice that calculates GST incorrectly.
Title: Invoice applies 12 percent GST instead of 18 percent for service items. Environment: UAT, build 2.4.1. Steps: create an order with service item SRV-101 at 1,000 rupees for a customer in Maharashtra and generate the invoice. Expected: CGST 90 and SGST 90, total 1,180. Actual: CGST 60 and SGST 60, total 1,120. Severity: high, as it affects tax compliance. Attachments: invoice PDF and screenshot. Linked requirement: FR-TAX-07.
39
Tell me about a time poor or outdated documentation caused a problem. How did you fix it?
Situation: a new developer built a GST calculation from an old FRD version, and the error was caught only in UAT. Task: fix the defect and prevent repeats. Action: I moved all requirement documents into one shared space with version history, added a change log and status labels such as draft or approved, and linked each user story to the latest approved section. Result: in the next two releases we had no defects caused by outdated specifications.
40
What are window functions in SQL and how are they different from GROUP BY?
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.
Tips to crack the Zensar Technologies Business Analytics interview
Practise aptitude and basic programming questions for the online test, along with simple SQL queries.
Read about the RPG Group and Zensar's focus on digital experience and engineering services.
Prepare to explain your projects clearly, including tools used and testing done, in a short structured answer.
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; Zensar Technologies interviewers usually ask follow-ups on your first answer.
Frequently asked questions
How many rounds are there in the Zensar Technologies Business Analytics interview?
Candidates usually go through 4 stages: Online assessment (aptitude + reasoning); 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 Zensar Technologies Business Analytics interview?
This practice set leans on Stakeholder Communication (6), UAT and BA Documentation (5), Power BI and Tableau (4), Process Modelling and BPMN (4). Revise those first, then practise explaining one or two of your own projects end to end, because most Zensar Technologies interviewers ask you to walk through real work.
Are these the exact questions asked at Zensar Technologies?
No. These are curated practice questions that match the skills and difficulty usually tested in it services interviews like Zensar Technologies's. They are not a leaked or verified list of past questions.
Where does Zensar Technologies hire Business Analytics professionals in India?
Zensar Technologies has large teams in Pune, Hyderabad, Bengaluru. Openings and locations change often, so check the Zensar Technologies careers page and filter by city and experience.
Business Analytics questions for similar companies