Add office photos
Myntra logo
Premium Employer

Myntra

4.0
based on 1.9k Reviews
Video summary
Filter interviews by
Data Analyst
Clear (1)

Myntra Data Analyst Interview Questions and Answers

Updated 7 Jun 2024

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

View 4 more answers
right arrow

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

View 2 more answers
right arrow

Q3. Guestimates question: How many women's drive red car in the Bangalore

Ans.

It is impossible to accurately estimate the number of women driving red cars in Bangalore without specific data.

  • There is no specific data available on the number of women driving red cars in Bangalore.

  • Estimating the number of women driving red cars in Bangalore would require access to vehicle registration data or a survey of car owners.

  • Factors such as car ownership trends among women and the popularity of red cars would also impact the estimate.

View 2 more answers
right arrow

Q4. Output resukt number of rows basis the joins

Ans.

The output result number of rows depends on the type of join used.

  • Inner join returns only the matching rows from both tables

  • Left join returns all rows from the left table and matching rows from the right table

  • Right join returns all rows from the right table and matching rows from the left table

  • Full outer join returns all rows from both tables

  • Cross join returns the Cartesian product of both tables

Add your answer
right arrow
Discover Myntra interview dos and don'ts from real experiences

Q5. Output result number of rows basis the joins

Ans.

The question asks to output the number of rows based on joins.

  • The number of rows in the output depends on the type of join used.

  • Inner join only returns rows that have matching values in both tables.

  • Left join returns all rows from the left table and matching rows from the right table.

  • Right join returns all rows from the right table and matching rows from the left table.

  • Full outer join returns all rows from both tables.

  • Use COUNT() function to count the number of rows in the out...read more

Add your answer
right arrow

Q6. how will achieve GMV if your budget is over

Ans.

Achieve GMV by optimizing marketing channels, improving product offerings, and enhancing user experience.

  • Optimize marketing channels to reach a larger audience

  • Improve product offerings to increase customer interest and sales

  • Enhance user experience to encourage repeat purchases and higher order values

Add your answer
right arrow
Contribute & help others!
Write a review
Write a review
Share interview
Share interview
Contribute salary
Contribute salary
Add office photos
Add office photos

Interview Process at Myntra Data Analyst

based on 17 interviews
1 Interview rounds
Technical Round
View more
interview tips and stories logo
Interview Tips & Stories
Ace your next interview with expert advice and inspiring stories

Top Data Analyst Interview Questions from Similar Companies

TCS Logo
3.7
 • 35 Interview Questions
Deloitte Logo
3.8
 • 25 Interview Questions
eClerx Logo
3.3
 • 18 Interview Questions
Morningstar Logo
3.9
 • 16 Interview Questions
Wipro Logo
3.7
 • 12 Interview Questions
View all
Recently Viewed
INTERVIEWS
Capgemini
No Interviews
INTERVIEWS
Capgemini
No Interviews
SALARIES
TVS Sundram Fasteners
No Salaries
REVIEWS
Alshaya Group
No Reviews
INTERVIEWS
Ace Designers
No Interviews
SALARIES
Lakshmi Precision Screws
SALARIES
TVS Sundram Fasteners
No Salaries
INTERVIEWS
Ace Designers
No Interviews
JOBS
Alshaya Group
No Jobs
REVIEWS
Verizon
No Reviews
Share an Interview
Stay ahead in your career. Get AmbitionBox app
play-icon
play-icon
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
75 Lakh+

Reviews

5 Lakh+

Interviews

4 Crore+

Salaries

1 Cr+

Users/Month

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter