Business Analytics Interview Questions in Coimbatore
36 practice questions with answers for Business Analytics interviews in Coimbatore.
Business Analytics jobs in Coimbatore
Coimbatore has a growing IT-services and engineering-services market around TIDEL Park and its SEZs, supported by a large pool of engineering graduates. Many roles are with delivery centres of bigger IT firms.
Below are 36 questions that match the mix of service, product and domain employers hiring business analysts in Coimbatore.
Solved for CoimbatoreStart 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 to find requirements that have no linked UAT test case.
SELECT r.req_id, r.title, r.priority
FROM requirements r
LEFT JOIN test_case_links l ON l.req_id = r.req_id
WHERE l.req_id IS NULL
AND r.status = 'APPROVED'
ORDER BY r.priority;
-- Run this before UAT starts: every approved requirement
-- should trace to at least one test case.
02
What is the difference between Definition of Ready and Definition of Done?
Definition of Ready is a checklist a story must meet before the team pulls it into a sprint: clear description, acceptance criteria, dependencies identified, designs attached and estimated. Definition of Done is the checklist for calling work complete: coded, reviewed, tested, acceptance criteria passed, documented and deployable. The BA mostly drives readiness, while the whole team owns done. Both reduce rework and arguments at sprint end.
03
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.
04
Write an Excel formula to extract the domain from an email address.
Link your answer to real experience. For example: during my internship I noticed reports were rebuilt manually every week, so I mapped the process and automated it with Power Query, saving the team a day each week. I enjoyed understanding the problem, talking to users and seeing the result used. A BA role combines that problem solving, communication and data work, which is where my strengths are, and I want to build deeper domain knowledge.
07
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.
08
Tell me about a time you mapped a process and discovered a major inefficiency.
Situation: vendor onboarding at my company took around 18 days and procurement blamed finance. Task: I was asked to map the AS-IS process. Action: I interviewed five roles, traced 25 recent vendor records through system timestamps and built a swimlane map. It showed that bank details were collected twice and verified by two teams separately. Result: we merged the steps into one checklist at intake, cut onboarding to 9 days and reduced rework emails by about half.
A UAT test plan defines how acceptance testing will be run. It covers scope and out-of-scope items, business processes to be tested, entry and exit criteria, roles such as testers, UAT lead and sign-off authority, test environment and test data, schedule and cycles, defect management process with severity definitions, communication and reporting, and risks. The BA usually drafts it with business owners so testers know exactly what they are accepting and when.
10
Write a SQL query to find the percentage of orders delivered late in each city.
-- late = delivered after the promised date
SELECT
city,
COUNT(*) AS total_orders,
SUM(CASE WHEN delivered_at > promised_at THEN 1 ELSE 0 END) AS late_orders,
ROUND(100.0 * SUM(CASE WHEN delivered_at > promised_at THEN 1 ELSE 0 END)
/ COUNT(*), 2) AS late_pct
FROM orders
WHERE status = 'DELIVERED'
GROUP BY city
ORDER BY late_pct DESC;
Log the change, assess impact on scope, cost and timeline, get approval through change control or backlog grooming, and update documents and stakeholders.
13
After many sprints, project documentation is out of date and new team members are confused. What do you do?
Identify which documents are actually used: usually a product overview, process maps, business rules, data dictionary and integration details. Update those first rather than everything. Make documentation part of the Definition of Done, so a story is not complete until related docs are updated. Keep living documents in a shared wiki with owners and last-reviewed dates, and archive outdated files clearly. Test the result by having a new joiner use it during onboarding.
14
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.
15
Guesstimate: how many cups of tea are sold in Delhi per day?
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.
16
How do you build a PivotTable to analyse sales by region and product?
The filter from the row field is not reaching the fact table. Usually there is no relationship between that dimension and the fact, the relationship is inactive, or it filters in the wrong direction. It can also happen when the measure uses ALL or REMOVEFILTERS on that column, or when the row field comes from the fact table of a different grain. Check the model view and test the measure with a simple SUM.
19
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.
20
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.
21
Two analysts report different monthly active user numbers from the same database. How do you resolve it?
Put both queries side by side and compare definitions: which events count as active, time zone, calendar versus rolling month, test and internal accounts, deleted users, and DISTINCT on user ID versus device ID. Run both on a single day to find where they diverge. Agree on one definition with the metric owner, document it, and publish it as a shared view or metric so everyone queries the same logic.
22
Write an Excel formula for working days between two dates excluding weekends and holidays.
// A2 = start, B2 = end, Holidays = named range of holiday dates
=NETWORKDAYS(A2, B2, Holidays)
// if the weekend is only Sunday (common in India)
=NETWORKDAYS.INTL(A2, B2, 11, Holidays)
23
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.
24
Write a SQL query to calculate monthly customer churn rate for a subscription business.
WITH monthly AS (
SELECT DISTINCT customer_id,
DATE_TRUNC('month', billing_date) AS month
FROM subscriptions_billed
)
SELECT
prev.month AS month,
COUNT(prev.customer_id) AS customers_at_start,
COUNT(prev.customer_id) - COUNT(nxt.customer_id) AS churned,
ROUND(100.0 * (COUNT(prev.customer_id) - COUNT(nxt.customer_id))
/ COUNT(prev.customer_id), 2) AS churn_pct
FROM monthly prev
LEFT JOIN monthly nxt
ON nxt.customer_id = prev.customer_id
AND nxt.month = prev.month + INTERVAL '1 month'
GROUP BY prev.month
ORDER BY prev.month;
25
What is User Acceptance Testing (UAT) and what is the BA's role in it?
UAT is the final testing phase where real business users check that the system supports their work and meets requirements before go-live. The BA helps plan UAT, prepares business scenarios and test cases from requirements, arranges test data, supports users during testing, triages defects versus change requests and tracks sign-off. UAT is not about finding code bugs, which earlier testing should have caught.
26
What is the difference between OLTP and OLAP systems?
It depends on the product's goal. For a content or learning app, more time may mean more engagement. For a payments or banking app, more time can mean users struggle to complete tasks. Check task completion rate, time to complete key actions, errors, support tickets and retention. A metric is good only when it moves in line with the value users came for.
29
Write a DAX measure to count distinct active customers in the last 30 days.
Active Customers 30D =
CALCULATE(
DISTINCTCOUNT(Sales[CustomerID]),
DATESINPERIOD('Date'[Date], MAX('Date'[Date]), -30, DAY)
)
-- MAX('Date'[Date]) makes it relative to the date in the current filter
30
What is the difference between accrual accounting and cash accounting?
Under accrual accounting, revenue is recorded when it is earned and expenses when they are incurred, regardless of when cash moves. Under cash accounting, transactions are recorded only when cash is received or paid. Companies in India report under accrual-based standards (Ind AS). Example: an annual software contract billed in April is recognised as revenue month by month over 12 months under accrual, even though all the cash came in April.
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.
33
UAT starts tomorrow, but the business has not nominated any testers. What do you do?
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.
34
Tell me about a time you handled a difficult stakeholder.
Use STAR: Situation, Task, Action, Result. Show that you listened, found the underlying goal, used data to align people and reached a documented decision.
35
What is a data dictionary and why does a business analyst maintain one?
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.
36
What is the Ansoff matrix and how is it used in growth cases?
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.
Few big employers listed in Coimbatore?
Many Coimbatore candidates also apply to teams in Chennai and to remote or hybrid roles. Practise the Chennai set as well.
Which companies hire Business Analytics professionals in Coimbatore?
Companies with large offices in Coimbatore include many IT services and product firms. Use their company pages below to practise employer-specific sets.
Are Business Analytics interviews in Coimbatore different from other cities?
The questions depend more on the company than the city. Coimbatore's mix of employers decides the style: Many roles are with delivery centres of bigger IT firms
How do I find Business Analytics jobs in Coimbatore?
Shortlist companies with Coimbatore offices, keep your CV focused on Business Analytics projects, apply on company career pages and job portals with the Coimbatore filter, and practise the questions on this page before each interview.