Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Dream11 Team. If you also belong to the team, you can get access from here

Dream11 Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Dream11 Business Analyst Interview Questions and Answers

Updated 28 Mar 2024

Dream11 Business Analyst Interview Experiences

1 interview found

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed in Feb 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. SQL based questions
  • Q2. Guesstimate on estimating # users on the application
  • Ans. 

    Estimate the number of users on the application based on market research, user demographics, and industry trends.

    • Consider the total addressable market (TAM) for the application

    • Analyze user demographics and behavior to estimate adoption rate

    • Look at industry benchmarks and competitor data for reference

    • Use surveys, focus groups, and user feedback to gather insights

    • Consider factors like market saturation, growth potential,

  • Answered by AI

Interview questions from similar companies

I applied via Naukri.com and was interviewed in Jun 2021. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. The questions were around technical documentation and tasks were given on documentation
  • Q2. E commerce related questions were asked

Interview Preparation Tips

Interview preparation tips for other job seekers - The managerial round was also core technical. If u do well in all the technical rounds you have high chance of clearing the interview
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Jul 2022. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Case Study 

1. Tell me about yourself
2. Estimate the number of hospitals in India

Round 3 - Case Study 

1. There has been a decrease in 20% of the users in the past 3 days in online pharmacy application, what will you do now?

Round 4 - HR 

(4 Questions)

  • Q1. Salary negotiation on what were last salary and related questions
  • Q2. How soon can you join?
  • Q3. Are you holding any other offer, in case you do..they will try to match it which ideally depends on your interview.
  • Q4. Are you comfortable relocating to the office location?

Interview Preparation Tips

Interview preparation tips for other job seekers - The interview is fairly easy, just be confident and explain your thought process to the interviewer while answering any question. They will support you and help you reach the destination if you do so.

I applied via Approached by Company and was interviewed in Dec 2021. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Assignment 

Two datasets were shared. Complete freedom was given to derive different insights.

Round 3 - One-on-one 

(1 Question)

  • Q1. Basic SQL Questions on join, queries etc.
Round 4 - One-on-one 

(1 Question)

  • Q1. Final round with Technical and Analytics head with puzzle questions and basic know hows.

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep on trying and learning from the mistakes of the past interviews.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I applied via LinkedIn and was interviewed in May 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Assignment 

Send assignment doings MS Excel

Round 3 - Technical 

(2 Questions)

  • Q1. Asked about the previous project
  • Q2. What about your roles in previous company

Interview Preparation Tips

Topics to prepare for Zolo Data Analyst interview:
  • Excel

Interview Questionnaire 

2 Questions

  • Q1. SQL and Excel were the key that helped me get this job.
  • Q2. Puzzles
Interview experience
4
Good
Difficulty level
Easy
Process Duration
More than 8 weeks
Result
Selected Selected

I applied via Company Website and was interviewed before Dec 2021. There were 2 interview rounds.

Round 1 - HR 

(3 Questions)

  • Q1. When I initially joined my job right after college there was a point where I was constantly
  • Q2. It's a great organisation and I've learner a lot here but it's such a small company that it's difficult to find ways to move up ask yourself what makes you feel passionate or happy when you work😊
  • Q3. Opportunity great time interest must
Round 2 - Group Discussion 

Group discussion can also provide feedback to instructors on participant comprehension.

Interview Preparation Tips

Interview preparation tips for other job seekers - Job search like it's your job look for opportunities
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(1 Question)

  • Q1. Introduction of yourself
Round 2 - Assignment 

Assignment of Google sheets

Round 3 - One-on-one 

(2 Questions)

  • Q1. Self introduction
  • Q2. What do you know about analysis and logical reasoning
  • Ans. 

    Analysis and logical reasoning involve examining data, identifying patterns, and drawing conclusions based on evidence.

    • Analysis involves breaking down complex information into smaller components for better understanding.

    • Logical reasoning is the process of using rational thinking to make sense of information and draw valid conclusions.

    • Analytical skills are essential for interpreting data accurately and making informed d...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Hello guys this company provide good salary but not good appraisal
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I was interviewed in Jan 2025.

Round 1 - Technical 

(3 Questions)

  • Q1. Sql questions mostly about windows function, aggregate, using having clause in group, union vs union all, mostly basics about sql.
  • Q2. Power Bi questions - measures in powerbi, calculate, dashboard, excel vs powerbi.
  • Q3. Assesment 5 question based on sql and excel. Easy questions like second highest salary, manager salary, count a's.

Interview Preparation Tips

Interview preparation tips for other job seekers - Go through some questions for interview on data analyst role and read those, this thing will help you to understand many concepts. Not very hard interview also the interviewer is helpful.

Data Analyst Interview Questions & Answers

Impact Guru user image Shubham Upadhyay

posted on 19 Apr 2024

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(3 Questions)

  • Q1. Difference between rank and dense rank
  • Ans. 

    Rank assigns unique ranks to each distinct value, while dense rank does not leave gaps between ranks.

    • Rank assigns unique ranks to each distinct value in a dataset

    • Dense rank does not leave gaps between ranks, assigning consecutive ranks to values with the same rank

    • For example, if values are 10, 20, 20, 30, then rank would be 1, 2, 2, 4 and dense rank would be 1, 2, 2, 3

  • Answered by AI
  • Q2. How will merge multiple file in python
  • Ans. 

    Merge multiple files in Python using pandas.concat() or pd.merge() functions.

    • Use pandas.concat() function to merge multiple files vertically (row-wise).

    • Use pd.merge() function to merge multiple files horizontally (column-wise) based on a common column.

    • Ensure that the files have compatible column names and data types before merging.

    • Handle any missing or duplicate values appropriately during the merging process.

    • Consider ...

  • Answered by AI
  • Q3. Data frame explain in detail
  • Ans. 

    A data frame is a two-dimensional data structure in which data is stored in rows and columns.

    • Data frames are commonly used in programming languages like R and Python for data analysis.

    • Each column in a data frame represents a variable, while each row represents an observation.

    • Data frames can contain different types of data, such as numeric, character, and factor.

    • Data frames can be created from various sources like CSV f

  • Answered by AI

Skills evaluated in this interview

Dream11 Interview FAQs

How many rounds are there in Dream11 Business Analyst interview?
Dream11 interview process usually has 1 rounds. The most common rounds in the Dream11 interview process are Technical.
How to prepare for Dream11 Business Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Dream11. The most common topics and skills that interviewers at Dream11 expect are MySQL, Python, SQL, Android and Gaming.
What are the top questions asked in Dream11 Business Analyst interview?

Some of the top questions asked at the Dream11 Business Analyst interview -

  1. Guesstimate on estimating # users on the applicat...read more
  2. SQL based questi...read more

Tell us how to improve this page.

Dream11 Business Analyst Interview Process

based on 2 interviews

Interview experience

4.5
  
Good
View more

Interview Questions from Similar Companies

Tracxn Interview Questions
3.1
 • 100 Interviews
InvestoXpert Interview Questions
4.5
 • 62 Interviews
MagicBricks Interview Questions
3.4
 • 57 Interviews
Zolo Interview Questions
3.4
 • 49 Interviews
Netmeds.com Interview Questions
3.6
 • 42 Interviews
Carwale Interview Questions
3.4
 • 41 Interviews
Uplers Interview Questions
4.0
 • 41 Interviews
Impact Guru Interview Questions
4.4
 • 37 Interviews
Yahoo Interview Questions
4.6
 • 29 Interviews
View all
Software Development Engineer II
46 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Developer
30 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Sde1
29 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Product Manager
26 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Development Engineer
21 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Dream11 with

My11Circle

5.0
Compare

Fantasy Akhada

2.0
Compare

MyTeam11

4.7
Compare

BalleBaazi

1.0
Compare
Did you find this page helpful?
Yes No
write
Share an Interview