Business Analytics Interview Questions in Hyderabad

Show answer

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.

What is a subquery and when would you use it?

Show answer

A query nested inside another, used for filtering or calculating values such as customers whose spend is above the average.

What is the difference between release notes and a user manual?

UAT and BA DocumentationEasy

Show answer

Release notes describe what changed in a specific release: new features, enhancements, fixed defects, known issues and any actions users must take. They are short and version-specific. A user manual or user guide explains how to use the whole system to complete tasks, with step-by-step instructions and screenshots, and is updated as the product evolves. BAs often review both, because users rely on them in the first weeks after go-live.

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

It is a regression: the fix for one defect broke existing functionality, which usually means changes were not impact-analysed and there is no regression suite. Log it as a new high-priority defect linked to the fix. Agree with the team that every UAT build comes with release notes listing the changes, and that QA runs an automated or core manual regression pack before handing the build to business testers. Also add the broken flow to the UAT regression checklist.

Write an Excel formula for a two-way lookup that finds sales for a given product and month.

Excel for Business AnalystsMedium

Show answer

// products in A2:A50, months in B1:M1, data in B2:M50 // G1 = product, G2 = month =INDEX(B2:M50, MATCH(G1, A2:A50, 0), MATCH(G2, B1:M1, 0)) // Excel 365 alternative =XLOOKUP(G1, A2:A50, XLOOKUP(G2, B1:M1, B2:M50))

What is UAT sign-off and who should give it?

UAT and BA DocumentationEasy

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.

What is the 80/20 rule in business analysis?

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.

What is a SWOT analysis?

Show answer

A framework listing internal Strengths and Weaknesses and external Opportunities and Threats to assess a project or business position.

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

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.

What is Power Pivot?

Show answer

An Excel add-in for building data models with relationships and DAX measures over millions of rows, beyond normal worksheet limits.

Tell me about a time you built a business case for a project. Was it approved?

Financial and Business AnalysisMedium

Show answer

Situation: our support team handled order-status queries manually, about 9,000 a month. Task: I was asked to evaluate a self-service tracking page. Action: I measured handling time from ticket data, estimated deflection conservatively at 40 percent, worked with IT on build and run costs and showed best, base and worst cases with payback. Result: leadership approved the base case. Six months after launch, deflection reached 46 percent, and I presented the benefits review to the same committee.

During UAT, users log 60 defects, but you suspect many are actually new requirements. How do you handle it?

Show answer

Run a joint triage with the business owner, QA and development. Compare each item against the signed-off requirements and acceptance criteria. Real defects stay in the defect log; items not covered by requirements are reclassified as change requests and prioritised separately through change control. Keep the tone neutral so users do not feel dismissed. Also review why the gap happened, for example prototypes were not shown early enough, and fix that for the next release.

How do you handle NULL values when calculating averages?

Show answer

AVG ignores NULLs; use COALESCE(col, 0) if NULLs should count as zero, depending on the business meaning.

What are the 4 Ps of marketing?

Show answer

Product, Price, Place and Promotion, the levers a business uses to bring an offering to market.

Write Given-When-Then acceptance criteria for applying a discount coupon at checkout.

Requirements and AgileMedium

Show answer

Given a cart of 1,200 rupees and a valid coupon SAVE10 with a minimum order of 1,000 rupees, when the user applies it, then 10 percent is deducted and the new total is shown. Given an expired coupon, when applied, then the message 'This coupon has expired' appears and the total is unchanged. Given a cart below the minimum, when applied, then the user is told how much more to add.

What is the difference between a sprint review and a sprint retrospective?

Requirements and AgileEasy

Show answer

A sprint review is held at the end of the sprint with stakeholders to demonstrate completed work, gather feedback and adjust the backlog; it is about the product. A sprint retrospective is an internal team meeting afterwards to discuss what went well, what did not and what to improve in the way of working; it is about the process. The BA often helps demo stories in the review.

Tell me about a time you mapped a process and discovered a major inefficiency.

Process Modelling and BPMNMedium

Show answer

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.

An online learning platform finds that only 12 percent of learners complete paid courses. How do you analyse it?

Show answer

Define completion and see where learners drop: first week, a specific module or before assessments. Segment by course, length, learner background, device and acquisition channel. Look at causes in content difficulty, video length, lack of deadlines, mentor support and job relevance. Recommend tests such as shorter modules, cohort-based deadlines, progress nudges and live doubt sessions, and measure completion and referral impact.

What are functional and non-functional requirements?

Requirements and AgileEasy

Show answer

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

What is SQL and why do business analysts need it?

SQL for Business AnalysisEasy

Show answer

A language for querying databases. BAs use it to pull data themselves, validate numbers, check reports and answer questions without waiting for engineers.

Describe how you would model an employee leave approval process in BPMN.

Process Modelling and BPMNMedium

Show answer

Use one pool for the company with lanes for Employee, Manager and HR system. Start event: leave request submitted. Task: system checks leave balance. Exclusive gateway: balance sufficient? If no, end event that notifies the employee. If yes, user task: manager reviews. Add an interrupting timer boundary event of 3 days that escalates to the skip-level manager. Gateway: approved or rejected. Approved path updates the leave balance and calendar, then both paths notify the employee and end.

What do interviewers evaluate in a business case interview?

Case Studies and GuesstimatesEasy

Show answer

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.

What is value chain analysis?

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.

You added new rows to the source data, but your PivotTable does not show them even after refresh. Why?

Excel for Business AnalystsEasy

Show answer

The PivotTable source is probably a fixed range such as A1:F500, so rows added below 500 are outside it. The fix is to convert the data to an Excel Table with Ctrl+T and change the pivot's data source to the table name, so it expands automatically. Also check for blank header cells, filters on the pivot hiding new items, and whether the new rows are actually text values in a numeric column, which can change grouping.

How do you find the top 5 customers by revenue?

Show answer

SELECT customer_id, SUM(amount) AS revenue FROM orders GROUP BY customer_id ORDER BY revenue DESC LIMIT 5;

UAT starts tomorrow, but the business has not nominated any testers. What do you do?

Show answer

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.

What steps would you follow to create a tracking plan for a new 'save for later' feature?

Product AnalyticsMedium

Show answer

Start from the questions to answer: how many users discover it, use it and later buy saved items. Define events such as save_clicked, saved_item_viewed, saved_item_removed and saved_item_purchased, with properties like product ID, price, source screen and platform. Follow the existing naming convention, assign owners, review with developers, and test events in a staging build. Build the dashboard before launch so data is checked on day one.

What is the difference between Power BI Desktop, Power BI Service and Power BI Mobile?

Power BI and TableauEasy

Show answer

Power BI Desktop is the free Windows app where you connect to data, model it, write DAX and design reports. Power BI Service is the cloud portal where you publish reports, schedule refresh, build dashboards, set permissions and share with users. Power BI Mobile is the phone app for viewing reports on the go. A typical flow is build in Desktop, publish to a Service workspace, and consume on web or mobile.

Guesstimate: how many new two-wheeler helmets are sold in India each year?

Case Studies and GuesstimatesHard

Show answer

Drive it from vehicles. Assume about 2 crore new two-wheelers are sold a year, each with an average of 1.5 helmets bought (rider plus pillion), giving 3 crore. The existing fleet is around 25 crore vehicles; assume 60 percent are active and each active vehicle replaces one helmet every 3 years: 15 crore / 3 = 5 crore. Total is about 8 crore helmets a year. Sanity check: enforcement varies by state, so give a range of 6 to 9 crore.

What is a self join? Give a business example.

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.

You receive two customer lists from sales and billing and must reconcile them. How do you do it?

Excel for Business AnalystsMedium

Show answer

Standardise both first: trim spaces, fix case, convert IDs to the same type and remove duplicates. Use a unique key like customer ID, or a combined key of phone and email if IDs differ. Then use XLOOKUP or COUNTIFS to mark each record as matched, only in sales or only in billing, or a Power Query merge with anti joins. Summarise mismatches by type and share the exception list with both owners.

Write DAX measures for Total Sales, Sales Last Year and Year-over-Year growth percent.

Show answer

Total Sales = SUM(Sales[Amount]) Sales LY = CALCULATE([Total Sales], SAMEPERIODLASTYEAR('Date'[Date])) YoY % = DIVIDE([Total Sales] - [Sales LY], [Sales LY]) -- needs a marked date table; DIVIDE avoids divide-by-zero errors

What are UAT entry and exit criteria? Give examples.