Business Analytics Interview Questions in Visakhapatnam
36 practice questions with answers for Business Analytics interviews in Visakhapatnam.
Business Analytics jobs in Visakhapatnam
Visakhapatnam (Vizag) has a developing IT market with delivery centres, start-ups and IT parks around Rushikonda. Many local candidates also apply to Hyderabad and remote roles, so a mix of service and product styles is common.
Below are 36 questions that match the mix of service, product and domain employers hiring business analysts in Visakhapatnam.
Solved for VisakhapatnamStart 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
Developers and testers interpret the same user story differently. How do you fix this?
The story is ambiguous, so bring the three amigos together: BA or product owner, a developer and a tester. Walk through concrete examples, including edge cases and error cases, and write them as acceptance criteria, ideally in Given-When-Then format. Add business rules, sample data and mock-ups where needed. Update the story and use the same practice in refinement for future stories, so gaps are found before coding starts.
Treat each version as a hypothesis. Walk the process physically or observe real cases end to end, and pull a sample of 20 to 30 recent orders from the system to trace what actually happened. Compare timestamps and status changes with each department's story. Then hold a joint session, show the evidence-based map and mark the variants openly. Often all three are partly right because different order types follow different paths, which should be modelled explicitly.
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.
AARRR breaks the customer lifecycle into five stages: Acquisition, how users find you; Activation, their first good experience; Retention, whether they come back; Referral, whether they recommend you; and Revenue, whether they pay. Each stage gets one or two metrics, such as sign-ups by channel, activation rate, Day-30 retention, invite rate and conversion to paid. It helps find which stage is the weakest bottleneck.
# B1 = discount rate (for example 12%)
# B2 = initial investment entered as a negative number
# B3:B7 = cash inflows for years 1 to 5
=NPV(B1, B3:B7) + B2
# NPV() assumes the first value comes at the end of year 1,
# so the year-0 investment is added outside the function.
IRR (internal rate of return) is the discount rate at which a project's NPV becomes zero, so it expresses the return as a percentage. NPV gives the value created in rupees at a chosen discount rate. Accept a project if IRR exceeds the cost of capital or NPV is positive. When comparing projects of different size or timing, NPV is more reliable, because IRR ignores scale and can give multiple answers when cash flows change sign more than once.
Uncontrolled growth of requirements. Control it with a clear scope statement, change control process, impact analysis and sponsor approval for additions.
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.
12
A hospital chain's average patient waiting time has risen from 30 to 50 minutes. How would you approach the case?
Clarify where the wait is measured: registration, consultation, diagnostics or billing. Split the problem into demand and capacity. On demand, check patient volume, peak-hour mix, walk-ins versus appointments and new departments. On capacity, check doctor availability, no-shows of staff, consultation time per patient and process bottlenecks such as manual billing. Identify the biggest stage and suggest fixes like slot-based appointments, triage and digital billing.
13
Write a DAX measure that shows each category's percent share of total sales.
Use STAR: Situation, Task, Action, Result. Show that you listened, found the underlying goal, used data to align people and reached a documented decision.
17
What is the difference between alpha testing and beta testing?
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.
A sequence flow is a solid arrow that shows the order of activities inside one pool, so it represents work controlled by one participant. A message flow is a dashed arrow with an open circle at its start and shows communication between two different pools, such as an order email from a customer to a seller. A common modelling mistake is drawing sequence flows across pools, which wrongly implies one party controls the other's work.
20
How do you calculate the percentage contribution of each category?
Situation: my weekly sales report showed a 12 percent jump that no one could explain. Task: verify the number before it reached leadership. Action: I compared row counts before and after each join and found a new promotions table had multiple rows per order, duplicating revenue. I aggregated promotions per order first and added a test comparing totals with the source. Result: the corrected report went out the same day, and I now check grain on every new join.
22
What is the difference between COUNT(*) and COUNT(column)?
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.
24
Tell me about a time you discovered a missed requirement late in a project.
Situation: two weeks before go-live of a billing system, a finance user asked how GST credit notes would work, which we had not covered. Task: assess and recover. Action: I analysed the impact with developers, found a simple configuration path for most cases plus a manual step for rare ones, and presented both options with dates to the sponsor. Result: we went live on time with a documented workaround and delivered the full fix next sprint.
25
What are dynamic array functions in Excel and how do they help analysts?
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.
26
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
29
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.
30
What steps would you follow to create an AS-IS process map for a customer refund process?
Define the scope: where the process starts, such as a refund request, and where it ends, such as money credited. Identify the roles involved and draw swimlanes. Interview and observe each role, capturing steps, decisions, systems used, handoffs and time taken. Draw the flow in BPMN, mark pain points like rework loops and waiting time, and add measures such as average refund time. Validate the map with the people who do the work.
31
Write a SQL query that shows revenue, cost and gross margin percent by product category.
SELECT
p.category,
SUM(oi.quantity * oi.unit_price) AS revenue,
SUM(oi.quantity * p.unit_cost) AS cost,
ROUND(100.0 * (SUM(oi.quantity * oi.unit_price)
- SUM(oi.quantity * p.unit_cost))
/ NULLIF(SUM(oi.quantity * oi.unit_price), 0), 2) AS gross_margin_pct
FROM order_items oi
JOIN products p ON p.product_id = oi.product_id
GROUP BY p.category
ORDER BY gross_margin_pct DESC;
32
What is a star schema and why do BI tools prefer it?
A star schema has one central fact table holding numeric events (sales, orders) linked to surrounding dimension tables (date, product, customer, region). BI tools prefer it because filters flow cleanly from dimensions to facts, DAX and Tableau calculations stay simple, and compression and query performance improve. A flat single table repeats text values and gets slow, while a snowflake with many chained lookups makes filtering and maintenance harder.
33
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.
Strengths and Weaknesses are internal; Opportunities and Threats are external. Example: S = strong faculty, W = low brand awareness, O = AI upskilling demand, T = free online content.
35
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.
36
How do you analyse variance between budget and actual?
Which companies hire Business Analytics professionals in Visakhapatnam?
Companies with large offices in Visakhapatnam include many IT services and product firms. Use their company pages below to practise employer-specific sets.
Are Business Analytics interviews in Visakhapatnam different from other cities?
The questions depend more on the company than the city. Visakhapatnam's mix of employers decides the style: Many local candidates also apply to Hyderabad and remote roles, so a mix of service and product styles is common
How do I find Business Analytics jobs in Visakhapatnam?
Shortlist companies with Visakhapatnam offices, keep your CV focused on Business Analytics projects, apply on company career pages and job portals with the Visakhapatnam filter, and practise the questions on this page before each interview.