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

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

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
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I appeared for an interview 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
Less than 2 weeks
Result
Not Selected

I applied via Recruitment Consulltant and was interviewed in Sep 2024. There were 3 interview rounds.

Round 1 - Aptitude Test 

Questions related to logical thinking

Round 2 - Group Discussion 

Common topics related to AI & other stuffs

Round 3 - Technical 

(2 Questions)

  • Q1. Excel basic questions such as conditional formatting
  • Q2. Sql questions such as Types of Joints etc

Interview Preparation Tips

Interview preparation tips for other job seekers - Stay confident throughout, that's the key here.
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 experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I appeared for an interview before Mar 2024.

Round 1 - Coding Test 

The test lasted about an hour and included data structures, algorithms and basic problem solving.

Round 2 - One-on-one 

(2 Questions)

  • Q1. What some projects you've worked on before and how have you helped improve efficiency?
  • Ans. 

    I have worked on various data analysis projects, focusing on improving efficiency through data-driven insights and automation.

    • Developed a dashboard for sales data analysis, reducing report generation time by 50%.

    • Automated data cleaning processes, which decreased manual effort by 30 hours per month.

    • Implemented predictive analytics for inventory management, leading to a 20% reduction in stockouts.

    • Conducted A/B testing fo...

  • Answered by AI
  • Q2. Introduce yourself
  • Ans. 

    Data Analyst with a passion for transforming data into actionable insights, skilled in SQL, Python, and data visualization tools.

    • Educational Background: Bachelor's degree in Statistics, where I developed a strong foundation in data analysis techniques.

    • Technical Skills: Proficient in SQL for database management and data extraction, and Python for data manipulation and analysis.

    • Experience: Worked on a project analyzing c...

  • Answered by AI

Interview Questionnaire 

2 Questions

  • Q1. SQL and Excel were the key that helped me get this job.
  • Q2. Puzzles

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

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

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 5 salaries
₹4 L/yr - ₹16.8 L/yr
56% more than the average Data Analyst Salary in India
View more details
Software Development Engineer II
46 salaries
unlock blur

₹23 L/yr - ₹60 L/yr

Software Developer
31 salaries
unlock blur

₹19 L/yr - ₹49.8 L/yr

Sde1
29 salaries
unlock blur

₹10.8 L/yr - ₹31 L/yr

Product Manager
24 salaries
unlock blur

₹26 L/yr - ₹45 L/yr

Software Development Engineer
21 salaries
unlock blur

₹20 L/yr - ₹54 L/yr

Explore more salaries
Compare Dream11 with

Uplers

4.0
Compare

Impact Guru

3.7
Compare

Tracxn

3.2
Compare

MagicBricks

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