01
What is a CTE?
Show answer
A named temporary result introduced with WITH that makes long queries readable and reusable in the same statement.
Dream11 Business Analytics Interview Questions & Answers
Curated interview practice questions with answers. These are practice scenarios, not a verified list of past interview questions.
About Dream11 hiring for Business Analytics roles
Dream11 is an Indian sports technology platform and the flagship brand of Dream Sports, which also includes FanCode and other businesses. Its engineering and analytics teams build systems that handle very high traffic during live matches. It hires for software engineers, SDETs, data engineers, data analysts and data scientists.
For Business Analytics roles, this Dream11 practice set focuses most on SQL for Business Analysis (6), Power BI and Tableau (6), Requirements and Agile (6), Case Studies and Guesstimates (4). It has 27 medium, 13 hard questions, so you can start easy and work up to the harder ones.
- Company type
- Product
- Headquarters
- Mumbai, India
- Main India offices
- Mumbai
Dream11 Business Analytics interview process
- Online assessment or assignment
- Technical round 1
- Technical round 2 (design or case)
- Hiring manager round
- Culture fit round
Typical pattern based on public candidate experiences. Rounds vary by role, team and year.
Solved for Dream11Start 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
02
A hospital chain's average patient waiting time has risen from 30 to 50 minutes. How would you approach the case?
Show answer
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.
03
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.
04
What is a boundary event in BPMN, and how do interrupting and non-interrupting boundary events differ?
Show answer
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.
05
How do you find duplicate customers?
Show answer
SELECT email, COUNT(*) FROM customers GROUP BY email HAVING COUNT(*) > 1;
06
How would you analyse the declining sales of a retail store?
Show answer
Break sales into footfall, conversion and average basket, compare with last year and competitors, and check stock, pricing, staffing and local events.
07
How do you use NPV and payback period to evaluate an investment in a case?
Show answer
Estimate the upfront investment and yearly incremental cash flows, then discount future cash flows at the cost of capital to compute Net Present Value. A positive NPV means the investment creates value. Payback period is how many years until cumulative cash flows recover the investment, which shows risk and liquidity but ignores later cash flows and time value. Present both, with a sensitivity check on key assumptions like volume and price.
08
Write a DAX measure to count distinct active customers in the last 30 days.
Show answer
Active Customers 30D =
CALCULATE(
DISTINCTCOUNT(Sales[CustomerID]),
DATESINPERIOD('Date'[Date], MAX('Date'[Date]), -30, DAY)
)
-- MAX('Date'[Date]) makes it relative to the date in the current filter
09
What is the difference between XLOOKUP and INDEX-MATCH?
Show answer
Both look up values flexibly; XLOOKUP is simpler with built-in not-found handling, while INDEX-MATCH works in older Excel versions.
10
Your measure shows the same value on every row of a matrix. Why might that happen?
Show answer
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.
11
A business head wants 25 charts on one dashboard page. How do you respond?
Show answer
Ask what decisions they make weekly and which three to five KPIs drive them. Propose a summary page with those KPIs, trends and one breakdown, then drill-through or separate pages for detail. Show a quick mock-up of both versions so they see the clutter and the load time. Use bookmarks or a field parameter to let them switch views without adding charts. Agree on the layout before building.
12
SQL: month-over-month revenue growth.
Show answer
WITH m AS (SELECT month, SUM(amount) AS rev FROM orders GROUP BY month)
SELECT month, rev,
ROUND(100.0 * (rev - LAG(rev) OVER (ORDER BY month))
/ LAG(rev) OVER (ORDER BY month), 1) AS mom_pct
FROM m;
13
Marketing and product teams define 'active user' differently and report conflicting numbers. How do you fix this?
Show answer
Bring both teams together and list each definition, its purpose and its numbers. Agree on one company-wide definition tied to real value, such as a user who completed a core action in the last 7 days, and allow clearly named secondary metrics like 'visitors' for marketing. Assign an owner, document it in a metric glossary, implement it once in the warehouse or semantic model, and retire the duplicate dashboards.
14
Split the epic 'Customers can track their order online' into user stories.
Show answer
Possible stories: As a customer, I want to see my order status (placed, packed, shipped, delivered) so that I know its progress. As a customer, I want an SMS or email when the status changes so that I do not have to check. As a customer, I want the expected delivery date so that I can plan. As a customer, I want a courier tracking link once shipped. As support staff, I want to see the same timeline so that I can answer queries.
15
How do you use Excel's Scenario Manager?
Show answer
Define named scenarios such as best, base and worst with different input values and compare the outputs in a summary report.
16
A mid-size manufacturer must choose between building and buying a warehouse management system. How do you advise?
Show answer
Compare options on fit, cost, time and risk. Buying a proven product is faster with lower risk and includes upgrades, but may need process changes and has recurring licence fees. Building fits unique processes exactly but needs a strong tech team, longer time and ongoing maintenance. Estimate five-year total cost of ownership, check whether processes are truly unique, and usually recommend buying and configuring unless warehousing is a core differentiator.
17
Describe a time when stakeholders resisted a process change you proposed. How did you handle it?
Show answer
Situation: I proposed removing a manual second approval for low-value expense claims, and team leads resisted, fearing fraud. Task: get agreement without weakening control. Action: I analysed six months of claims and showed the second approver rejected less than 0.5 percent below 5,000 rupees. I suggested a pilot with random audits of 10 percent of claims and agreed a reversal trigger. Result: the pilot ran for two months with no extra fraud, approval time fell by 3 days and the change was adopted.
18
What is a stakeholder analysis?
Show answer
Identifying everyone affected by the project and mapping their influence and interest to decide how to communicate with and involve each group.
19
How would you decide whether to launch a new product?
Show answer
Assess market size and demand, customer need, competition, unit economics, capabilities, risks and strategic fit, then test with a pilot before scale-up.
20
Your process diagram has grown to 80 shapes on one page and stakeholders say they cannot read it. What do you do?
Show answer
Restructure it into levels. Create a high-level map with 7 to 10 main steps, then collapse detailed parts into sub-processes with their own diagrams. Move complex decision logic into a decision table rather than chains of gateways. Show the happy path first and handle exceptions in separate views. Use consistent naming in verb-noun form and remove duplicated steps. Finally, test readability by asking a stakeholder to explain the diagram back to you.
21
What does the LTV to CAC ratio tell you and what is a healthy value?
Show answer
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.
22
What does the CALCULATE function do in DAX?
Show answer
CALCULATE evaluates an expression under a modified filter context. You pass a measure plus filter arguments that add, replace or remove filters, for example CALCULATE([Sales], 'Region'[Name] = "North") or CALCULATE([Sales], ALL('Product')). It is the basis of time intelligence, percent-of-total and comparison measures. It also triggers context transition when used inside a row context, which is powerful but a common source of confusion.
23
Your LEFT JOIN report should list all customers, but customers without orders are missing. Why?
Show answer
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.
24
A report query on a 200 million row table takes 15 minutes. How do you optimise it?
Show answer
Read the execution plan to find full scans and expensive joins. Filter early on partitioned or indexed columns such as date, select only needed columns instead of SELECT *, and avoid functions on filter columns. Pre-aggregate in a CTE before joining, replace correlated subqueries with joins or window functions, and check join keys have matching types. For repeated use, build a summary table or materialised view refreshed daily.
25
How would you improve a company's low app conversion rate?
Show answer
Map the funnel, find the biggest drop-off, check usability and load time, run A/B tests on fixes and track conversion lift.
26
Revenue grew 20 percent this quarter but the number of active customers stayed flat. How do you interpret it?
Show answer
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?
27
Write a DAX measure that shows each category's percent share of total sales.
Show answer
Category Share % =
DIVIDE(
[Total Sales],
CALCULATE([Total Sales], ALL('Product'[Category]))
)
-- ALLSELECTED instead of ALL respects slicers on the page
28
Your Power BI report takes 30 seconds to load. How do you speed it up?
Show answer
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.
29
A release passed all system testing, but business users reject it during UAT. What went wrong and what do you do?
Show answer
The team built what was written, but not what users needed, which points to gaps in elicitation, missing real-world scenarios or users not involved early. Capture each rejection and classify it as a defect, a missed requirement or a new request. Prioritise blockers with the product owner and agree on a fix plan and date. Going forward, involve users in demos every sprint and base UAT scenarios on real workflows.
30
Write a defect report for an invoice that calculates GST incorrectly.
Show answer
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.
31
What is a process flow and which tools do you use?
Show answer
A diagram of steps, decisions and owners in a process, made using BPMN or flowcharts in tools like Visio, Lucidchart or draw.io.
32
You receive two customer lists from sales and billing and must reconcile them. How do you do it?
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.
33
What is a spike in Agile and when would a business analyst request one?
Show answer
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.
34
Tell me about a time you led or mentored a team of analysts.
Show answer
Situation: I led three junior analysts on a pricing review with a six-week deadline. Task: deliver quality work while developing them. Action: I split the work by workstream, set up short daily check-ins and a shared query library, reviewed their logic rather than rewriting it, and let each present their section to the client. Result: we delivered a week early, two juniors later handled client calls alone, and the review practice became standard in our team.
35
Write non-functional requirements for an online payment page.
Show answer
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.
36
What is the novelty effect, and why should A/B tests run for full weeks?
Show answer
The novelty effect is a temporary lift because users are curious about something new, which fades after a few days; the opposite, change aversion, causes a temporary drop. Running tests for at least one or two full weeks covers weekday and weekend behaviour and lets these effects settle. You can also check whether the lift is stable over time and among new users who never saw the old version.
37
Stakeholders give conflicting requirements. What do you do?
Show answer
Clarify the goal behind each request, map them to business objectives, prioritise with MoSCoW, run a joint session, then document the decision and get sign-off.
38
What is the difference between COUNT(*) and COUNT(column)?
Show answer
COUNT(*) counts all rows; COUNT(column) counts only rows where that column is not NULL.
39
How do you build a PivotTable to analyse sales by region and product?
Show answer
Create a table, insert a PivotTable, drag region to rows, product to columns, sales to values, and add slicers for month or channel.
40
What is the difference between Definition of Ready and Definition of Done?
Show answer
Definition of Ready is a checklist a story must meet before the team pulls it into a sprint: clear description, acceptance criteria, dependencies identified, designs attached and estimated. Definition of Done is the checklist for calling work complete: coded, reviewed, tested, acceptance criteria passed, documented and deployable. The BA mostly drives readiness, while the whole team owns done. Both reduce rework and arguments at sprint end.
Tips to crack the Dream11 Business Analytics interview
- Practise system design for sudden traffic spikes, such as many users joining just before a cricket match starts.
- Prepare analytics cases on user engagement, retention and contest participation around major tournaments.
- Keep up with regulatory changes affecting online gaming in India, as they directly shape the company's 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; Dream11 interviewers usually ask follow-ups on your first answer.
Frequently asked questions
How many rounds are there in the Dream11 Business Analytics interview?
Candidates usually go through 5 stages: Online assessment or assignment; Technical round 1; Technical round 2 (design or case); Hiring manager round; Culture fit 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 Dream11 Business Analytics interview?
This practice set leans on SQL for Business Analysis (6), Power BI and Tableau (6), Requirements and Agile (6), Case Studies and Guesstimates (4). Revise those first, then practise explaining one or two of your own projects end to end, because most Dream11 interviewers ask you to walk through real work.
Are these the exact questions asked at Dream11?
No. These are curated practice questions that match the skills and difficulty usually tested in product interviews like Dream11's. They are not a leaked or verified list of past questions.
Where does Dream11 hire Business Analytics professionals in India?
Dream11 has large teams in Mumbai. Openings and locations change often, so check the Dream11 careers page and filter by city and experience.
Business Analytics questions for similar companies
Product
Workday
Business Analytics interview questions
Pune
View questionsProduct
Chargebee
Business Analytics interview questions
Chennai, Bengaluru
View questionsProduct
Autodesk
Business Analytics interview questions
Bengaluru, Pune
View questionsProduct
Meta
Business Analytics interview questions
Gurugram, Bengaluru, Hyderabad +1
View questionsProduct
Oracle
Business Analytics interview questions
Bengaluru, Hyderabad, Noida +2
View questionsProduct
Zoho
Business Analytics interview questions
Chennai, Tenkasi
View questionsMore ways to practise
Company-wise Business Analytics questionsPackage-wise Business Analytics questionsExperience-wise Business Analytics questionsRole-wise Business Analytics questionsCity-wise Business Analytics questionsMost asked Business Analytics questionsScenario-based questionsPractical / hands-on questionsHR & behavioural questionsBusiness Analytics mock interviewOnline assessment questionsTechnical round questionsManagerial round questionsBusiness Analytics topic sheets