Airtel Business Analytics Interview Questions & Answers
Curated interview practice questions with answers. These are practice scenarios, not a verified list of past interview questions.
About Airtel hiring for Business Analytics roles
Bharti Airtel is an Indian telecom company providing mobile, broadband, DTH, enterprise connectivity and digital services such as Airtel Thanks and Airtel Payments Bank. Its digital and analytics teams work on network data, customer analytics and app development. It hires for software engineers, testers, network engineers and data professionals.
For Business Analytics roles, this Airtel practice set focuses most on Business Metrics and KPIs (8), Excel for Business Analysts (5), UAT and BA Documentation (5), Case Studies and Guesstimates (4). It has 18 easy, 18 medium, 4 hard questions, so you can start easy and work up to the harder ones.
Company type
Telecom
Headquarters
New Delhi, India
Main India offices
Gurugram, Bengaluru, Mumbai, Pune
Airtel Business Analytics interview process
Online assessment (aptitude + technical)
Technical interview
Managerial round
HR round
Typical pattern based on public candidate experiences. Rounds vary by role, team and year.
Solved for AirtelStart 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 does the LTV to CAC ratio tell you and what is a healthy value?
LTV to CAC compares the lifetime gross profit from a customer with the cost of acquiring them. A ratio around 3 to 1 is commonly treated as healthy. Below 1 means you lose money on every customer. Far above 5 may mean you are underinvesting in growth. Always compute LTV on gross margin, not revenue, and check it by channel, because blended averages hide loss-making channels.
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.
04
What is the difference between XLOOKUP and INDEX-MATCH?
An Excel Table turns a range into a named, structured object. It expands automatically when rows are added, so formulas, charts, PivotTables and Power Query sources pick up new data without range edits. It supports structured references like =SUM(Sales[Amount]), calculated columns that fill down automatically, built-in filters, banded formatting and a total row. Tables make reports far less error-prone than fixed ranges like A2:F5000.
A typical SRS includes purpose, scope and definitions; overall description with users, operating environment, assumptions and constraints; functional requirements, each with a unique ID, description, priority and acceptance criteria; external interface requirements for UI, APIs and integrations; non-functional requirements such as performance, security, availability and compliance; data requirements; and appendices with diagrams and a traceability reference. Each requirement should be clear, testable and traceable to a business need.
09
Gross margin fell from 38 percent to 34 percent in one quarter. How do you investigate?
Break the change into drivers. Price: were discounts or promotions deeper? Mix: did sales shift towards lower-margin products, channels or regions? Cost: did raw material, freight or supplier prices rise, or did currency movements raise import costs? Also check one-offs like inventory write-offs and accounting reclassifications. Build a margin bridge showing how many percentage points each driver contributed, then take the biggest driver to the business owner with a specific action.
Level of Detail expressions compute an aggregate at a granularity different from the view. FIXED computes at the stated dimensions regardless of the view, for example { FIXED [Customer ID] : MIN([Order Date]) } for first purchase date. INCLUDE adds a dimension to the view level, useful for average sales per customer by region. EXCLUDE removes a dimension, useful for comparing each month with the yearly total. FIXED ignores normal dimension filters unless they are context filters.
12
How do you write a query to find users active in consecutive months?
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.
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.
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.
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.
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.
19
A business tester raises a defect, and the developer closes it as 'works as designed'. How do you resolve it?
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.
// Dates in Sales[Date], amounts in Sales[Amount]
=SUMIFS(Sales[Amount],
Sales[Date], ">=" & EOMONTH(TODAY(), -1) + 1,
Sales[Date], "<=" & TODAY())
// EOMONTH(TODAY(),-1)+1 gives the first day of the current month
23
What is the difference between revenue and profit?
Functional requirements describe what the system does (login, reports); non-functional ones describe how well it does it (speed, security, availability, usability).
25
What is the difference between a vanity metric and an actionable metric?
A vanity metric looks impressive but does not guide decisions, such as total app downloads, page views or social followers that only ever go up. An actionable metric links clearly to a decision and behaviour, such as Day-7 retention, conversion rate by channel or revenue per active user. A good test: if the number changes, do you know what to do differently? If not, it is probably vanity.
26
Guesstimate: what is the annual revenue of one multiplex screen in a large Indian city?
Assume 5 shows a day and 200 seats with 30 percent average occupancy, giving 300 tickets a day. At an average ticket of 250 rupees, ticket revenue is 75,000 rupees a day. Food and beverage adds about 40 percent of ticket revenue, around 30,000, and screen ads maybe 5,000. That is about 1.1 lakh a day, or around 4 crore a year. Weekends and blockbuster releases push occupancy higher.
27
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.
28
What are wireframes and why are they useful for a BA?
They assess how you think, not just the final answer. Key areas are clarifying the problem before solving, building a clear and MECE structure, handling numbers accurately with sanity checks, using business sense to prioritise, adapting to new information, and ending with a crisp recommendation with risks and next steps. Thinking aloud and communicating clearly matter as much as getting the right number.
30
Revenue grew 20 percent this quarter but the number of active customers stayed flat. How do you interpret it?
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?
MECE means Mutually Exclusive and Collectively Exhaustive. When you break a problem into parts, the parts should not overlap and together should cover every possibility. For example, profit splits into revenue and cost, and revenue into price times volume. A breakdown of customers into 'young' and 'students' is not MECE because they overlap. MECE structures prevent double counting and missed causes, which is what interviewers check.
32
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.
Send an agenda with the goal and the decisions needed beforehand, along with any pre-read. Invite only people who contribute or decide. Start by restating the goal, keep to time, park off-topic issues and confirm decisions aloud. End by summarising actions with owners and dates. Send minutes within a day. A meeting without a clear decision or output usually could have been an email.
34
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.
35
What is a boundary event in BPMN, and how do interrupting and non-interrupting boundary events differ?
A boundary event is attached to the edge of an activity and reacts to something that happens while that activity is running. An interrupting boundary event (solid double border) cancels the activity and takes the exception path, for example a 24-hour timeout cancelling manual approval. A non-interrupting one (dashed border) starts a parallel path while the activity continues, for example sending a reminder email after 12 hours without stopping the approval task.
A/B testing is a controlled experiment where users are randomly split into a control group that sees the current version and a treatment group that sees a change, such as a new checkout button. You compare a pre-decided primary metric, like conversion rate, between groups. Because assignment is random, a significant difference can be attributed to the change rather than to seasonality, marketing or user mix.
37
What is row-level security in Power BI and how do you set it up?
Row-level security restricts which rows a user can see in the same report. In Desktop you create roles under Manage Roles with a DAX filter, such as 'Region'[Manager Email] = USERPRINCIPALNAME() for dynamic RLS. You test with View as Role, publish, and then map users or groups to roles in the Service. Dynamic RLS with a mapping table scales better than creating one static role per region.
38
What is a cutover plan and a go-live readiness checklist?
A cutover plan is an hour-by-hour runbook for moving from the old system to the new one: freezing old transactions, final data migration, validation checks, configuration, smoke testing, switch-over and a rollback plan with clear decision points. A go-live readiness checklist confirms that UAT is signed off, users are trained, support and hypercare are staffed, data is reconciled, and communications are sent. The go or no-go meeting reviews this checklist before the cutover starts.
39
Compare Import mode, DirectQuery and Live Connection in Power BI.
Import copies data into the compressed in-memory model, giving the fastest visuals and full DAX, but data is only as fresh as the last refresh and size is limited. DirectQuery sends queries to the source at view time, so data is near real time but visuals are slower and some DAX is restricted. Live Connection points to an existing published semantic model or Analysis Services model without its own model. Composite models mix Import and DirectQuery.
40
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.
Tips to crack the Airtel Business Analytics interview
Learn telecom basics like ARPU, churn, 4G and 5G networks, and broadband rollout for case discussions.
Prepare analytics cases on reducing customer churn or improving network quality using data.
Read about Airtel's digital products like Airtel Thanks and Xstream, and its enterprise business Airtel Business.
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; Airtel interviewers usually ask follow-ups on your first answer.
Frequently asked questions
How many rounds are there in the Airtel Business Analytics interview?
Candidates usually go through 4 stages: Online assessment (aptitude + technical); Technical interview; 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 Airtel Business Analytics interview?
This practice set leans on Business Metrics and KPIs (8), Excel for Business Analysts (5), UAT and BA Documentation (5), Case Studies and Guesstimates (4). Revise those first, then practise explaining one or two of your own projects end to end, because most Airtel interviewers ask you to walk through real work.
Are these the exact questions asked at Airtel?
No. These are curated practice questions that match the skills and difficulty usually tested in telecom interviews like Airtel's. They are not a leaked or verified list of past questions.
Where does Airtel hire Business Analytics professionals in India?
Airtel has large teams in Gurugram, Bengaluru, Mumbai, Pune. Openings and locations change often, so check the Airtel careers page and filter by city and experience.
Business Analytics questions for similar companies