Upload Button Icon Add office photos

Filter interviews by

Clear (1)

Mad Street Den Data Analyst Interview Questions and Answers

Updated 20 Nov 2024

Mad Street Den Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 20 Nov 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed before Nov 2023. There were 3 interview rounds.

Round 1 - Aptitude Test 

Basic Aptitude (prob, )

Round 2 - One-on-one 

(1 Question)

  • Q1. Basic sql and exel
Round 3 - HR 

(1 Question)

  • Q1. Tell me about your self

Interview questions from similar companies

I applied via Referral and was interviewed in Feb 2021. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Technical Questions (SQL and Python)
  • Q2. Business case studies

Interview Preparation Tips

Interview preparation tips for other job seekers - Brush up SQL skills, learn different methods of solving the same problem, learn basics of python, especially Pandas and Numpy
Interview experience
3
Average
Difficulty level
Hard
Process Duration
4-6 weeks
Result
No response

I applied via Referral and was interviewed in Oct 2023. There were 2 interview rounds.

Round 1 - Technical 

(3 Questions)

  • Q1. Window functions
  • Q2. Joins and aggregate functions
  • Q3. Abalytical function lag() and lead() question
Round 2 - One-on-one 

(1 Question)

  • Q1. Guesstimate and Puzzle
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
More than 8 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Sep 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Double-check your resume for any spelling mistakes. The recruiter may consider spelling mistakes as careless behavior or poor communication skills.
View all Resume tips
Round 2 - Case Study 

It was a simple case study with a regression problem

Round 3 - Technical 

(4 Questions)

  • Q1. The interview was focused on basics of data analytics and python.
  • Q2. What is the imp stw in data analytics?
  • Ans. 

    The importance of data analytics lies in its ability to help organizations make informed decisions, identify trends, and improve overall performance.

    • Data analytics helps organizations make data-driven decisions

    • It allows businesses to identify trends and patterns in data

    • Data analytics can improve operational efficiency and performance

    • It enables organizations to gain insights and make predictions based on data

    • Data analyt...

  • Answered by AI
  • Q3. What is rank and dense rank
  • Ans. 

    Rank and dense rank are functions used in SQL to assign a rank to each row based on a specified column.

    • Rank function assigns a unique rank to each distinct row based on the specified column.

    • Dense rank function assigns a unique rank to each distinct row based on the specified column, but does not leave gaps between ranks.

    • Example: If we have a table of students with their scores, using rank function will assign ranks lik...

  • Answered by AI
  • Q4. Advanced excel formulas were asked

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Assignment 

They will provide you with dataset and we need to find insights from that

Round 2 - Personality Assessment 

(1 Question)

  • Q1. Why do want to join as a data analyst
  • Ans. 

    I am passionate about uncovering insights from data and using them to drive informed decision-making.

    • I have a strong background in statistics and data analysis

    • I enjoy working with large datasets and finding patterns within them

    • I am excited about the opportunity to make a meaningful impact through data-driven decision-making

    • I am proficient in data visualization tools like Tableau and Power BI

  • Answered by AI
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all Resume tips
Round 2 - Assignment 

There was a data with some 6000 rows and we have to derive 5 useful insights from it

Round 3 - Aptitude Test 

To know yourself like it was a kind of OPQ

Round 4 - Technical 

(1 Question)

  • Q1. Tjere was a questions on what is data analysis,how we do it,wep scrapper ,data crawling
Round 5 - Technical 

(1 Question)

  • Q1. It was a discussion with CEO of company

Interview Preparation Tips

Interview preparation tips for other job seekers - It is good place to start your career as data analyst. Very good place to work
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed before Oct 2023. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. It was basic data analyst non technical quesions
Round 2 - HR 

(1 Question)

  • Q1. Salary Discussion
Round 1 - Technical 

(2 Questions)

  • Q1. Create the pivot table, sort the data in ascending order
  • Ans. 

    Create a pivot table and sort the data in ascending order.

    • To create a pivot table, select the data range and go to the 'Insert' tab in Excel.

    • Choose 'PivotTable' and select the location for the pivot table.

    • Drag the desired fields to the 'Rows' and 'Values' areas.

    • To sort the data in ascending order, click on the drop-down arrow next to the field name in the pivot table and select 'Sort A to Z'.

  • Answered by AI
  • Q2. Use lookup with the product based given data and find the needed data
  • Ans. 

    Using lookup with product-based data to find the needed data.

    • Use a lookup function like VLOOKUP or INDEX/MATCH to search for the needed data

    • Identify the key or unique identifier to match the data

    • Specify the range or table where the data is located

    • Retrieve the desired data based on the lookup value

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - please be ready with your resume, and work on each and every line.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed in May 2022. 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 - Technical 

(2 Questions)

  • Q1. Intermediate SQL questions
  • Q2. Pivot and Vlookup questions
Round 3 - Case Study 

How many cars are sold in your city in a month and questions on the projects I have done in my previous organisation

Interview Preparation Tips

Topics to prepare for Myntra Data Analyst interview:
  • Advanced Excel
  • SQL
Interview preparation tips for other job seekers - Be very well prepared with Excel and SQL. Even though the questions are intermediate level questions, they can confuse you by asking simple tricky questions
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Basic SQL and Python
Round 2 - HR 

(1 Question)

  • Q1. Behavioral Questions
Round 3 - One-on-one 

(1 Question)

  • Q1. Company fit questions
Contribute & help others!
anonymous
You can choose to be anonymous

Mad Street Den Interview FAQs

How many rounds are there in Mad Street Den Data Analyst interview?
Mad Street Den interview process usually has 3 rounds. The most common rounds in the Mad Street Den interview process are Aptitude Test, One-on-one Round and HR.
How to prepare for Mad Street Den 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 Mad Street Den. The most common topics and skills that interviewers at Mad Street Den expect are Data Analysis, Data Analytics, Data Architecture, Management and Product Engineering.

Recently Viewed

JOBS

Browse jobs

Discover jobs you love

COMPANY BENEFITS

KNR Constructions

20 benefits

COMPANY BENEFITS

IRB Infrastructure

60 benefits

COMPANY BENEFITS

Dilip Buildcon

304 benefits

COMPANY BENEFITS

Dilip Buildcon

304 benefits

INTERVIEWS

Grant Thornton

No Interviews

LIST OF COMPANIES

Decimal Point Analytics

Overview

LIST OF COMPANIES

5paisa Capital Ltd.

Locations

INTERVIEWS

5paisa Capital Ltd.

No Interviews

INTERVIEWS

Grant Thornton

No Interviews

Tell us how to improve this page.

Mad Street Den Data Analyst Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Data Analyst Interview Questions from Similar Companies

View all
Mad Street Den Data Analyst Salary
based on 6 salaries
₹3 L/yr - ₹10 L/yr
At par with the average Data Analyst Salary in India
View more details

Mad Street Den Data Analyst Reviews and Ratings

based on 1 review

3.0/5

Rating in categories

3.0

Skill development

3.0

Work-life balance

3.0

Salary

3.0

Job security

3.0

Company culture

3.0

Promotions

3.0

Work satisfaction

Explore 1 Review and Rating
Graphic Designer
53 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Graphic Designer
16 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Machine Learning Engineer
14 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Image Editor
7 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Data Analyst
6 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Mad Street Den with

Myntra

4.0
Compare

Flipkart

4.0
Compare

Paytm

3.3
Compare

Snapdeal

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