Skip to content

Cognizant Business Analytics Interview Questions & Answers

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

About Cognizant hiring for Business Analytics roles

Cognizant is a US-headquartered IT services and consulting company with most of its workforce based in India. It provides application development, testing, cloud, digital engineering and data analytics services, with strong practices in healthcare, insurance and banking. In India it hires for programmer analyst, quality engineer and data roles through campus and off-campus programmes such as GenC.

For Business Analytics roles, this Cognizant practice set focuses most on Case Studies and Guesstimates (6), Business Metrics and KPIs (6), UAT and BA Documentation (5), Requirements and Agile (5). It has 16 easy, 23 medium, 1 hard questions, so you can start easy and work up to the harder ones.

Company type
IT services
Headquarters
Teaneck, New Jersey, USA
Main India offices
Chennai, Bengaluru, Pune, Hyderabad, Kolkata

Cognizant Business Analytics interview process

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

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

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

Guesstimate: how many smartphones are sold in India each year?

Save to ▾
Show answer
Use a replacement plus new-buyer approach. India has about 144 crore people; assume around 60 crore active smartphone users. If people replace phones every 4 years on average, replacements are about 15 crore a year. Add first-time buyers, say 2 to 3 percent of the remaining adult population, roughly 1.5 crore. The estimate is about 16 to 17 crore phones a year, which is close to reported industry numbers of around 15 crore.
02
Save to ▾
Show answer
A named temporary result introduced with WITH that makes long queries readable and reusable in the same statement.
03

What is a data dictionary and why does a business analyst maintain one?

Save to ▾
Show answer
A data dictionary is a catalogue of data elements used in a system or report: field name, business definition, data type, length, allowed values, mandatory or optional, source system, owner and example values. A BA maintains it so business users, developers and testers use one definition, for example what counts as an active customer. It prevents mapping errors in integrations and migrations, speeds up testing and reduces disputes about why reports do not match.
04

Stakeholders give conflicting requirements. What do you do?

Save to ▾
Show answer
Clarify the goal behind each request, map them to business objectives, prioritise with MoSCoW, run a joint session, then document the decision and get sign-off.
05

Revenue grew 20 percent this quarter but the number of active customers stayed flat. How do you interpret it?

Save to ▾
Show answer
Growth came from more value per customer, not more customers. Break revenue into customers times orders per customer times average order value to see which moved. It could be price increases, larger baskets, a shift to premium products or a few large accounts. Then check risks: is new customer acquisition stalling, is churn being masked, and is growth concentrated in a small segment that could leave?
06

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.
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 horizontal and vertical analysis of financial statements?

Save to ▾
Show answer
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.
09

What is the Ansoff matrix and how is it used in growth cases?

Save to ▾
Show answer
The Ansoff matrix maps four growth strategies by product and market. Market penetration sells existing products to existing markets, the lowest risk. Product development offers new products to existing customers. Market development takes existing products to new markets, such as new cities. Diversification launches new products in new markets, the highest risk. In a growth case it structures the options before you evaluate each one's size, cost and fit.
10

How do you validate that a report's numbers are correct?

Save to ▾
Show answer
Reconcile totals with source tables using SQL, check filters and joins for duplication, compare with prior periods and verify with business owners.
11

What are DAU, WAU and MAU, and what is the stickiness ratio?

Save to ▾
Show answer
DAU, WAU and MAU count unique users active in a day, week and month, where 'active' must be clearly defined, such as completing a core action. The stickiness ratio is DAU divided by MAU and shows how often monthly users return. A ratio of 0.5 means the average monthly user is active about 15 days a month. Daily-use products like messaging aim high, while a travel app naturally has low stickiness.
12

What is Net Promoter Score (NPS) and what are its limitations?

Save to ▾
Show answer
NPS asks customers how likely they are to recommend you on a 0 to 10 scale. Scores of 9 to 10 are promoters, 7 to 8 passives and 0 to 6 detractors. NPS equals percent promoters minus percent detractors, ranging from minus 100 to plus 100. Limitations: it is one question, sensitive to survey timing and sample bias, and does not explain why. Pair it with open-text reasons and behavioural metrics like retention.
13

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

The scheduled refresh failed overnight and leadership reviews the dashboard at 10 am. What do you do?

Save to ▾
Show answer
Check the refresh history error first: expired credentials, gateway offline, source schema change or timeout. Fix the quick cause and trigger a manual refresh. If it cannot be fixed in time, inform the stakeholders early, state the last refreshed date clearly on the report and share the key numbers from a direct query if needed. Afterwards add refresh failure alerts and a data-as-of label so it never surprises anyone.
15

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

Guesstimate: how many weddings take place in India in a year?

Save to ▾
Show answer
Assume a population of about 144 crore and an average life expectancy of about 70 years, so roughly 2 crore people reach a typical marriage age each year. If about 95 percent of them marry at some point, that is around 1.9 crore people, or about 95 lakh weddings, since each wedding involves two people. A reasonable estimate is around 1 crore weddings per year, concentrated in the winter wedding season.
17

What is conditional formatting and how would you use it in a business report?

Save to ▾
Show answer
Conditional formatting changes a cell's look based on rules or formulas. In reports you can highlight targets missed in red, use data bars for sales size, colour scales for a region heatmap, icon sets for trend direction, or a formula rule like =$E2<$F2 to colour an entire row. Use it sparingly and with a legend so the eye goes only to the exceptions that need action.
18

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

What is the difference between a chart and a dashboard?

Save to ▾
Show answer
A chart shows one view of data; a dashboard combines several charts and KPIs on one page for monitoring.
20

What are functional and non-functional requirements?

Save to ▾
Show answer
Functional requirements describe what the system does (login, reports); non-functional ones describe how well it does it (speed, security, availability, usability).
21

Because of a tight deadline, the business sponsor wants to skip UAT and go live directly. How do you respond?

Save to ▾
Show answer
Explain the risks in business terms: without UAT, there is no evidence that real processes work, and production defects cost far more to fix and can affect customers and compliance. Offer alternatives: a shortened UAT covering only critical business flows, parallel running with the old system, a phased rollout to one branch or user group, or extended hypercare. If the sponsor still decides to skip it, record the decision and accepted risks formally.
22

What is value chain analysis?

Save to ▾
Show answer
Value chain analysis breaks a business into the activities that create value: primary activities such as inbound logistics, operations, outbound logistics, marketing and sales, and service, plus support activities like procurement, technology, HR and infrastructure. For each activity you look at cost and differentiation. In cases it helps locate where costs are rising or where a competitive advantage can be built, for example in last-mile delivery.
23

What is the time value of money?

Save to ▾
Show answer
The time value of money means a rupee today is worth more than a rupee in the future, because today's rupee can be invested to earn a return and future money carries inflation and risk. Future cash is converted to present value using PV = FV / (1 + r)^n. At a 10 percent discount rate, 1,10,000 rupees received after one year is worth 1,00,000 rupees today. It is the basis of NPV, IRR, loan EMIs and valuation.
24

SQL: top 5 customers by spend.

Save to ▾
Show answer
SELECT customer_id, SUM(amount) AS spend FROM orders GROUP BY customer_id ORDER BY spend DESC LIMIT 5;
25

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

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

What is a self join? Give a business example.

Save to ▾
Show answer
A self join joins a table to itself using two aliases, so you can compare rows within the same table. A classic business example is an employees table with a manager_id column: joining employees e to employees m on e.manager_id = m.employee_id lists each employee with their manager's name. Another example is finding customers who placed two orders on the same day by joining orders to orders on customer_id and date with different order IDs.
28

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

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

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

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

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

What is an issue tree and how does a hypothesis-driven approach work?

Save to ▾
Show answer
An issue tree breaks the main question into smaller, MECE sub-questions until each can be answered with data, such as 'why are profits down?' into revenue and cost branches. A hypothesis-driven approach starts with a likely answer, for example 'profit fell because delivery costs rose', and uses the tree to decide which data proves or disproves it first. It focuses effort and keeps the case structured and fast.
34

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

Daily active users dropped 10 percent week over week. How do you investigate?

Save to ▾
Show answer
Rule out data issues first: tracking changes, app release bugs, pipeline delays or bot filters. Check whether the drop is seasonal by comparing with the same week last year or a festival calendar. Then segment by platform, app version, country or city, acquisition channel and new versus returning users to locate it. Look at the funnel for the core action. Connect findings to releases, outages or marketing changes, then recommend fixes.
36

What steps would you follow to run a process discovery workshop?

Save to ▾
Show answer
Before: agree scope and process boundaries, invite people who actually do the work, not only managers, and collect existing documents and sample cases. During: state the goal, map the happy path first on a wall or digital board, then add exceptions, pain points, handoffs and volumes, and park off-topic issues. Keep timing visible. After: convert the output to a clean BPMN diagram within two days, circulate it for validation, and record open questions with owners and dates.
37

Write non-functional requirements for an online payment page.

Save to ▾
Show answer
NFR-01 Performance: the payment page loads within 2 seconds for 95 percent of requests at 500 concurrent users. NFR-02 Availability: 99.9 percent monthly uptime outside planned maintenance. NFR-03 Security: card data is never stored by the application, and all traffic uses TLS 1.2 or higher. NFR-04 Compliance: the flow meets PCI DSS and RBI payment guidelines. NFR-05 Usability: works on mobile screens from 360 pixels wide. NFR-06 Audit: every transaction attempt is logged with a timestamp.
38

What is a primary key?

Save to ▾
Show answer
A column or set of columns that uniquely identifies each row in a table and cannot contain NULL.
39

Write Excel formulas to find the second-highest sales value and the name of the rep who achieved it.

Save to ▾
Show answer
// second highest value =LARGE(C2:C100, 2) // rep name for that value =INDEX(B2:B100, MATCH(LARGE(C2:C100, 2), C2:C100, 0)) // with ties, SORTBY gives a clean list: =TAKE(SORTBY(B2:C100, C2:C100, -1), 2)
40

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.

Tips to crack the Cognizant Business Analytics interview

  • Understand the GenC, GenC Next and GenC Elevate tracks so you know which skills and coding level each role expects.
  • Revise SQL queries, OOP concepts and basic testing terminology since many freshers are placed in development or QA projects.
  • Read about Cognizant's healthcare and life sciences domain work, which is a large part of its client base.
  • 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; Cognizant interviewers usually ask follow-ups on your first answer.

Frequently asked questions

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

Candidates usually go through 4 stages: Online assessment (aptitude + reasoning); Coding assessment; 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 Cognizant Business Analytics interview?

This practice set leans on Case Studies and Guesstimates (6), Business Metrics and KPIs (6), UAT and BA Documentation (5), Requirements and Agile (5). Revise those first, then practise explaining one or two of your own projects end to end, because most Cognizant interviewers ask you to walk through real work.

Are these the exact questions asked at Cognizant?

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

Where does Cognizant hire Business Analytics professionals in India?

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

Business Analytics questions for similar companies