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

Clear (1)

Dream11 Data Analyst Interview Questions and Answers

Updated 25 Jan 2023

Dream11 Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 25 Jan 2023

Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Recruitment Consulltant and was interviewed in Dec 2022. There were 2 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 Resume tips
Round 2 - Technical 

(3 Questions)

  • Q1. Details about the projects in your resume
  • Q2. MYSQL codes in window function
  • Ans. 

    MYSQL window functions allow for calculations across rows in a result set.

    • Window functions are used to perform calculations across rows in a result set

    • They are used with the OVER() clause

    • Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE()

    • They can be used to calculate running totals, moving averages, and more

  • Answered by AI
  • Q3. Mostly questions related to cricket tables which was told to be assumed

Interview Preparation Tips

Interview preparation tips for other job seekers - Disappointing experience
Interviewer was a young girl she didn't gave any data or material.
Everything was assumption assume tables and she asked me to code in paper
never had such experience.

Skills evaluated in this interview

Interview questions from similar companies

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 Resume 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
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.
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
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 Resume 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

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

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

I applied via Walk-in and was interviewed before Feb 2021. 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 Resume tips
Round 2 - Aptitude Test 
Round 3 - HR 

(1 Question)

  • Q1. Tell me about yourself.

Interview Preparation Tips

Interview preparation tips for other job seekers - easy to crack they will ask qestions

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
Contribute & help others!
anonymous
You can choose to be anonymous

Dream11 Interview FAQs

How many rounds are there in Dream11 Data Analyst interview?
Dream11 interview process usually has 2 rounds. The most common rounds in the Dream11 interview process are Resume Shortlist and Technical.
How to prepare for Dream11 Data 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 Google Analytics, SQL, Android, Distribution System and Instrumentation.
What are the top questions asked in Dream11 Data Analyst interview?

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

  1. MYSQL codes in window funct...read more
  2. Mostly questions related to cricket tables which was told to be assu...read more

Recently Viewed

INTERVIEWS

WinZO

No Interviews

SALARIES

Gameskraft

INTERVIEWS

WinZO

No Interviews

SALARIES

Baazi Games

SALARIES

Gameskraft

No Salaries

INTERVIEWS

Dream11

No Interviews

INTERVIEWS

Octro

No Interviews

LIST OF COMPANIES

Paytm First Games

Overview

INTERVIEWS

Octro

5.6k top interview questions

REVIEWS

Baazi Games

No Reviews

Tell us how to improve this page.

Dream11 Data Analyst Interview Process

based on 1 interview

Interview experience

1
  
Bad
View more
Dream11 Data Analyst Salary
based on 4 salaries
₹4 L/yr - ₹13 L/yr
47% more than the average Data Analyst Salary in India
View more details
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
24 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