Business Analytics Interview Questions for Mid-Level Roles (₹8–10 LPA)
40 questions with answers for mid-level roles — 6 easy, 32 medium, 2 hard.
What ₹8–10 LPA interviews expect
About ₹8–10 LPA Business Analytics roles
Roles in the ₹8–10 LPA band are typically for mid-level roles. Interviewers check whether you can already do the work expected at this level, so questions here are weighted towards Excel for Business Analysts (8), Case Studies and Guesstimates (5), Product Analytics (5), UAT and BA Documentation (5).
Salary bands are indicative only. The same skills can pay differently across cities, company types and negotiation.
What are dynamic array functions in Excel and how do they help analysts?
Show answer
Write a SQL query that shows revenue, cost and gross margin percent by product category.
Show answer
What does GROUP BY do and how is HAVING different from WHERE?
Show answer
What is the difference between XLOOKUP and INDEX-MATCH?
Show answer
You receive two customer lists from sales and billing and must reconcile them. How do you do it?
Show answer
How do you protect a worksheet or workbook?
Show answer
How do you run an effective stakeholder meeting?
Show answer
A new onboarding flow increased sign-ups by 15 percent, but Day-7 retention fell. How do you analyse this?
Show answer
What is a data table in Excel?
Show answer
What is conditional formatting and how would you use it in a business report?
Show answer
Tell me about a time you said no to a stakeholder.
Show answer
What is the difference between release notes and a user manual?
Show answer
What is a feasibility study?
Show answer
Write an Excel formula for the NPV of a project with an initial investment today and five yearly cash inflows.
Show answer
What are LOD expressions in Tableau and how do FIXED, INCLUDE and EXCLUDE differ?
Show answer
After many sprints, project documentation is out of date and new team members are confused. What do you do?
Show answer
How do you build a forecast in Excel?
Show answer
What is sensitivity analysis?
Show answer
Write a SQL query to find requirements that have no linked UAT test case.
Show answer
What is value chain analysis?
Show answer
Guesstimate: how many new two-wheeler helmets are sold in India each year?
Show answer
Which chart would you choose for trend, part-to-whole, comparison and distribution?
Show answer
How would you measure the success of a new feature?
Show answer
What are UAT entry and exit criteria? Give examples.
Show answer
Tell me about a time you misunderstood a requirement. What did you learn?
Show answer
What is product analytics and how is it different from business reporting?
Show answer
In UAT cycle 2, a feature that passed in cycle 1 is now broken after a defect fix. What does this tell you and what should change?
Show answer
What is a process flow and which tools do you use?
Show answer
Write a SQL query to show cumulative revenue by month.
Show answer
What is an issue tree and how does a hypothesis-driven approach work?
Show answer
How would you decide whether to launch a new product?
Show answer
What are data objects and data stores in BPMN?
Show answer
Tell me about a time you had to learn a new analytics tool quickly for a project.
Show answer
What is a star schema and why do BI tools prefer it?
Show answer
A bank's mobile app logins increased, but digital transactions fell. What could explain this?
Show answer
How do you analyse variance between budget and actual?
Show answer
What techniques do you use to elicit requirements?
Show answer
Control has 10,000 users with 400 purchases and the variant has 10,000 users with 460 purchases. Calculate the lift.
Show answer
What are leading and lagging indicators? Give examples.
Show answer
Frequently asked questions
What do Business Analytics interviews for ₹8–10 LPA roles test?
At ₹8–10 LPA the focus is usually on: practical depth in core tools, design choices and trade-offs, ownership of modules or features, mentoring juniors informally. This page's set is weighted towards Excel for Business Analysts (8), Case Studies and Guesstimates (5), Product Analytics (5), UAT and BA Documentation (5).
Which companies pay ₹8–10 LPA for Business Analytics roles?
Pay depends on company type, city, skills and negotiation, not only experience. Use the company-wise pages to practise for the specific employers you are targeting, and treat salary bands as a rough guide.
How should I prepare for a ₹8–10 LPA Business Analytics interview?
Solve every question here without looking at the answer first, mark the ones you miss, save them to Last-Minute Revision and revise them the night before. Prepare two project stories that show impact at the level expected for ₹8–10 LPA.