Flipkart Business Analytics Interview Questions & Answers
Curated interview practice questions with answers. These are practice scenarios, not a verified list of past interview questions.
About Flipkart hiring for Business Analytics roles
Flipkart is an Indian e-commerce company and part of the Walmart group, with businesses including Flipkart, Myntra, Cleartrip and Ekart logistics. Its engineering and analytics teams work on search, recommendations, supply chain, pricing and fraud detection. It hires for software development engineers, SDETs, business analysts, data analysts and data scientists.
For Business Analytics roles, this Flipkart practice set focuses most on Case Studies and Guesstimates (7), Requirements and Agile (7), Excel for Business Analysts (6), Power BI and Tableau (5). It has 3 easy, 27 medium, 10 hard questions, so you can start easy and work up to the harder ones.
Company type
E-commerce & consumer tech
Headquarters
Bengaluru, India
Main India offices
Bengaluru, Hyderabad
Flipkart Business Analytics interview process
Online coding assessment
Machine coding round
Problem solving and DSA round
Hiring manager round
HR round
Typical pattern based on public candidate experiences. Rounds vary by role, team and year.
Solved for FlipkartStart 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
The scheduled refresh failed overnight and leadership reviews the dashboard at 10 am. What do you do?
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.
02
Write an Excel formula for month-to-date sales up to today.
// 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
03
You receive two customer lists from sales and billing and must reconcile them. How do you do it?
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.
04
Write an Excel formula to count the number of unique customers in a column.
// Excel 365
=COUNTA(UNIQUE(A2:A500))
// unique customers in the North region only
=COUNTA(UNIQUE(FILTER(A2:A500, B2:B500="North")))
// older versions (no blanks in range)
=SUMPRODUCT(1/COUNTIF(A2:A500, A2:A500))
05
Should a supermarket chain launch its own private-label products?
Evaluate attractiveness and ability. Attractiveness: private labels usually earn higher margins, so check category size, how price-sensitive customers are, and whether brand loyalty is weak in categories like staples and cleaning. Ability: supplier availability, quality control, shelf space and brand trust. Estimate the margin gain against cannibalisation of branded sales and supplier relationships. Recommend starting with a few high-volume, low-loyalty categories and measuring repeat purchase.
Log the change, assess impact on scope, cost and timeline, get approval through change control or backlog grooming, and update documents and stakeholders.
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.
09
What is a spike in Agile and when would a business analyst request one?
A spike is a time-boxed story used for research or experimentation to reduce uncertainty, not to deliver a feature. Its output is knowledge, such as a recommendation or a prototype. A BA might request one when the team cannot estimate a story because an external API, a data source or a regulation is unclear, for example checking whether a payment gateway supports partial refunds. The time box, often one to three days, prevents open-ended investigation.
10
What steps would you follow to create a tracking plan for a new 'save for later' feature?
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.
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
A lender is launching a new personal loan product. What KPIs would you set up?
Cover the full funnel and risk. Acquisition: applications, approval rate, cost per disbursed loan and time to disbursal. Value: disbursed amount, average ticket size and net interest margin. Risk: delinquency rates at 30 and 90 days past due by cohort, and early default rate. Customer: drop-off by application step, complaint rate and repeat borrowing. Track risk by monthly disbursal cohort, because defaults show up months later.
14
Because of a tight deadline, the business sponsor wants to skip UAT and go live directly. How do you respond?
Explain the risks in business terms: without UAT, there is no evidence that real processes work, and production defects cost far more to fix and can affect customers and compliance. Offer alternatives: a shortened UAT covering only critical business flows, parallel running with the old system, a phased rollout to one branch or user group, or extended hypercare. If the sponsor still decides to skip it, record the decision and accepted risks formally.
15
Why should you avoid bidirectional relationships in a Power BI model?
Relationships normally filter one way, from the dimension (one side) to the fact (many side). Bidirectional filtering lets facts filter dimensions too, which can create ambiguous filter paths, unexpected totals and slower queries, especially with multiple fact tables. Prefer a clean star schema with single-direction filters, and when you need a reverse filter for one measure, use CROSSFILTER or TREATAS inside CALCULATE instead of changing the model globally.
16
Your measure shows the same value on every row of a matrix. Why might that happen?
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.
17
What is the difference between a task and a sub-process in BPMN?
A task is an atomic unit of work that you do not break down further in the diagram, such as Verify PAN details. A sub-process is a compound activity that contains its own flow of tasks, events and gateways, shown with a small plus sign when collapsed. Sub-processes keep high-level diagrams readable: the main map shows Credit Check as one box, and a separate detailed view explains its internal steps.
18
A feature was launched to all users at once without an A/B test. How would you measure its impact?
Use quasi-experimental methods. Compare before and after with enough history to account for trend and seasonality. If it rolled out at different times in regions or platforms, use difference-in-differences between early and late groups. Compare users who adopted with similar non-adopters using matching, while being careful about self-selection. For future launches, recommend keeping a small holdout group so impact can be measured cleanly.
NFR-01 Performance: the payment page loads within 2 seconds for 95 percent of requests at 500 concurrent users. NFR-02 Availability: 99.9 percent monthly uptime outside planned maintenance. NFR-03 Security: card data is never stored by the application, and all traffic uses TLS 1.2 or higher. NFR-04 Compliance: the flow meets PCI DSS and RBI payment guidelines. NFR-05 Usability: works on mobile screens from 360 pixels wide. NFR-06 Audit: every transaction attempt is logged with a timestamp.
Use drill-through. Create a detail page, add the Region field to the page's drill-through filter well, and design visuals for orders, products and trends. Power BI adds a back button automatically. On the summary page, users right-click a region and choose Drill through. Keep all filters on so date selections carry over. For guided navigation, you can also add buttons with bookmarks, but drill-through is the cleanest way to pass the selected region.
23
Revenue grew but profit fell. Why could that happen?
Look at the cost side: heavier discounts, higher CAC, logistics costs, product mix shifting to low-margin items, one-time expenses or pricing changes. Break contribution margin down by segment.
24
A KPI on your dashboard dropped 40 percent overnight. What are your first steps?
Assume a data problem until proven otherwise, because real businesses rarely move 40 percent in a day. Check whether the refresh completed, whether source row counts look normal, and whether any tracking, pipeline or definition changed. Compare with a raw source query and a related metric, such as orders versus payments. If the data is fine, segment by channel, region and platform to locate the drop, then alert the owners quickly.
As a customer, I want to reset my password by email so that I can get back into my account.
Acceptance criteria:
• Reset link expires in 15 minutes
• Password rules are shown while typing
• A success message appears after reset
28
What checklist do you apply to a BPMN diagram before sharing it with stakeholders?
Every diagram has clear start and end events and a title with version and owner. Activities use verb-noun names such as Approve invoice. Each gateway is labelled with a question and its outgoing flows with answers. Splits and joins use matching gateway types. Message flows only connect separate pools. No dangling or crossing arrows where avoidable. The happy path reads left to right. Exceptions are handled, and complex rules are referenced to decision tables rather than drawn as gateways.
29
An online learning platform finds that only 12 percent of learners complete paid courses. How do you analyse it?
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.
Logically the database processes FROM and JOIN first, then WHERE, GROUP BY, HAVING, SELECT, DISTINCT, ORDER BY and finally LIMIT or TOP. This explains common errors: you cannot use a SELECT alias in WHERE because WHERE runs earlier, aggregate conditions must go in HAVING, and window functions cannot be filtered in WHERE, so you wrap them in a CTE or subquery. The optimiser may physically reorder steps, but the result follows this order.
32
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.
33
A quick-commerce company wants to expand into Tier-2 cities. What would you analyse before recommending it?
Demand: population density, smartphone and digital payment penetration, average basket size and how often people buy groceries. Supply: dark store rent, rider availability and local sourcing. Unit economics: orders per store per day needed to break even, given lower average order values. Competition: local kirana delivery and other apps. Then propose a pilot in two or three cities with clear success metrics such as orders per day, contribution margin per order and repeat rate before scaling.
34
Your LEFT JOIN report should list all customers, but customers without orders are missing. Why?
A condition on the right table was probably placed in the WHERE clause, for example WHERE o.order_date >= '2026-01-01'. For customers with no orders, o.order_date is NULL, so WHERE removes them and the query behaves like an INNER JOIN. Move the condition into the ON clause, as in LEFT JOIN orders o ON o.customer_id = c.id AND o.order_date >= '2026-01-01', or explicitly allow NULLs.
35
Your Power BI report takes 30 seconds to load. How do you speed it up?
Start with Performance Analyzer to see which visuals and DAX queries are slow. Then fix the model: remove unused columns, reduce high-cardinality text, use a star schema and correct data types. Rewrite heavy measures, avoiding FILTER over whole tables and nested iterators. Cut the number of visuals per page, use aggregations or Import instead of DirectQuery where possible, and push transformations upstream into SQL or Power Query.
36
What steps would you follow to run a process discovery workshop?
Before: agree scope and process boundaries, invite people who actually do the work, not only managers, and collect existing documents and sample cases. During: state the goal, map the happy path first on a wall or digital board, then add exceptions, pain points, handoffs and volumes, and park off-topic issues. Keep timing visible. After: convert the output to a clean BPMN diagram within two days, circulate it for validation, and record open questions with owners and dates.
The cash conversion cycle measures how many days cash is tied up in operations. It equals days inventory outstanding plus days sales outstanding minus days payables outstanding. Example: inventory sits 40 days, customers pay in 30 days and suppliers are paid in 45 days, so the cycle is 40 + 30 - 45 = 25 days. A shorter cycle means less working capital is needed. Some marketplaces have a negative cycle because they collect from customers before paying sellers.
38
A feature launched two months ago is used by only 4 percent of users. What would you do?
Find out whether it is a discovery problem or a value problem. Check how many users saw the entry point, how many tried it and how many returned. If few saw it, test better placement or onboarding prompts. If many tried and few returned, interview users and review session recordings to understand why. Also check if the 4 percent are high-value users. Then decide to improve, reposition or remove it.
39
How do you manage conflicting requirements from two senior stakeholders?
Clarify the underlying goals, present data and trade-offs, facilitate a joint session, escalate to the sponsor if needed and document the agreed decision.
40
Write an Excel formula to calculate the monthly EMI for a loan of 10 lakh rupees at 9 percent annual interest for 5 years.
=PMT(9%/12, 5*12, -1000000)
# Returns about 20,758 rupees per month.
# rate = annual rate / 12, nper = total months,
# pv entered as negative so the EMI shows as positive.
# Total interest = EMI * 60 - 1000000.
Tips to crack the Flipkart Business Analytics interview
Practise machine coding problems where you build a small working system, such as a parking lot or splitwise, in about 90 minutes.
For analyst roles, prepare guesstimates and cases on topics like Big Billion Days sales, returns or delivery delays.
Learn about Flipkart's supply chain and Ekart operations, as many data problems relate to logistics in Indian conditions.
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; Flipkart interviewers usually ask follow-ups on your first answer.
Frequently asked questions
How many rounds are there in the Flipkart Business Analytics interview?
Candidates usually go through 5 stages: Online coding assessment; Machine coding round; Problem solving and DSA round; Hiring manager 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 Flipkart Business Analytics interview?
This practice set leans on Case Studies and Guesstimates (7), Requirements and Agile (7), Excel for Business Analysts (6), Power BI and Tableau (5). Revise those first, then practise explaining one or two of your own projects end to end, because most Flipkart interviewers ask you to walk through real work.
Are these the exact questions asked at Flipkart?
No. These are curated practice questions that match the skills and difficulty usually tested in e-commerce & consumer tech interviews like Flipkart's. They are not a leaked or verified list of past questions.
Where does Flipkart hire Business Analytics professionals in India?
Flipkart has large teams in Bengaluru, Hyderabad. Openings and locations change often, so check the Flipkart careers page and filter by city and experience.
Business Analytics questions for similar companies