6 Nykaa Data Analyst Interview Questions & Answers | Complete Prep Guide 2025

Nykaa Data Analyst Interview Experiences

2 interviews found

Data Analyst Interview Questions & Answers

Anonymous

posted on 25 Apr 2024

Interview experience

Average

Difficulty level

Moderate

Process Duration

Less than 2 weeks

Result

Selected

I applied via LinkedIn and was interviewed before Apr 2023. There was 1 interview round.

Round 1 - Technical

(2 Questions)

Q1. Normal SQL hands on questions , like order of commands in sql and joins

Add your answer

Q2. A guesstimate related question

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Just be yourself and look for simple approach to answer a guesstimate problem by asking correct follow-up questions

Data Analyst Interview Questions & Answers

Anonymous

posted on 19 Sep 2020

I applied via LinkedIn and was interviewed in Aug 2020. There were 3 interview rounds.

Interview Questionnaire

4 Questions

Q1. Questions on SQL involving Joins, ranker over() partition by, Group by, Coalesce.

Add your answer

Q2. Python basic questions for rank and group by and the same to do in excel.

Add your answer

Q3. Some logical thinking ability questions.

Add your answer

Q4. Any project related to online customer data.

Ans.

I have worked on a project related to online customer data for a retail company.

Analyzed customer behavior on the company's website using Google Analytics
Identified popular products and pages visited by customers
Created customer segments based on demographics and behavior
Provided recommendations to improve website navigation and product offerings

Answered by AI

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - It was overall an easy interview.

Top trending discussions

View All

Interview Tips & Stories

4d (edited)

timepasstiwari

A Digital Markter

Got Rejected In an Interview, Just Because I Didn’t Answer a Personal Question

So, I got invited for this interview, and they told me to be there at 9 AM. Of course, I get there early, like 8:30, because I don't want to be late. But then I end up waiting for 1.5 hours... read more

Got a question about Nykaa?

Ask anonymously on communities.

Interview questions from similar companies

Data Analyst Interview Questions & Answers

Myntra

Anonymous

posted on 3 Mar 2021

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)

Add your answer

Q2. Business case studies

Add your answer

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

Data Analyst Interview Questions & Answers

LimeRoad

Anonymous

posted on 21 Apr 2024

Interview experience

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

Add your answer

Q2. Joins and aggregate functions

Add your answer

Q3. Abalytical function lag() and lead() question

Add your answer

Round 2 - One-on-one

(1 Question)

Q1. Guesstimate and Puzzle

Add your answer

Data Analyst Interview Questions & Answers

Purplle.com

Anonymous

posted on 19 Dec 2024

Interview experience

Good

Difficulty level

Easy

Process Duration

Less than 2 weeks

Result

I applied via Job Portal and was interviewed in Nov 2024. There was 1 interview round.

Round 1 - One-on-one

(3 Questions)

Q1. Tell me about yourself?

Ans.

I am a data analyst with a background in statistics and programming, passionate about turning data into actionable insights.

Background in statistics and programming
Experience in data analysis and visualization
Strong problem-solving skills
Ability to communicate complex findings to non-technical stakeholders

Answered by AI

Add your answer

Q2. Tell me what work you do at your current company?

Ans.

I analyze data to identify trends, patterns, and insights to support decision-making.

Analyze large datasets to extract valuable insights
Create visualizations to communicate findings
Collaborate with stakeholders to understand business needs
Use statistical tools and techniques to interpret data
Present findings and recommendations to management

Answered by AI

Add your answer

Q3. What are your views on beauty?

Ans.

Beauty is subjective and can be found in various forms, such as nature, art, and human relationships.

Beauty is subjective and can vary from person to person.
It can be found in nature, like a breathtaking sunset or a blooming flower.
Artistic creations, such as paintings, sculptures, and music, can also be considered beautiful.
Beauty can also be seen in human relationships, acts of kindness, and expressions of love.

Answered by AI

Add your answer

Data Analyst Interview Questions & Answers

Myntra

Anonymous

posted on 27 Mar 2022

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

View 4 more answers

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

View 2 more answers

Interview Preparation Tips

Interview preparation tips for other job seekers - please be ready with your resume, and work on each and every line.

Data Analyst Interview Questions & Answers

Myntra

Anonymous

posted on 5 Apr 2023

Interview experience

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

Add your answer

Q2. Pivot and Vlookup questions

Add your answer

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

Data Analyst Interview Questions & Answers

Myntra

Anonymous

posted on 9 Aug 2024

Interview experience

Excellent

Difficulty level

Process Duration

Result

Round 1 - Technical

(1 Question)

Q1. Basic SQL and Python

Add your answer

Round 2 - HR

(1 Question)

Q1. Behavioral Questions

Add your answer

Round 3 - One-on-one

(1 Question)

Q1. Company fit questions

Add your answer

Data Analyst Interview Questions & Answers

Myntra

Anonymous

posted on 10 Sep 2024

Interview experience

Good

Difficulty level

Moderate

Process Duration

Less than 2 weeks

Result

Not Selected

I applied via Naukri.com

Round 1 - Technical

(2 Questions)

Q1. Excel questions are index match, sumif, countif, vlookup

Add your answer

Q2. Sql questions are 2nd highest salary

Add your answer

Data Analyst Interview Questions & Answers

Myntra

Anonymous

posted on 17 Nov 2024

Interview experience

Good

Difficulty level

Easy

Process Duration

2-4 weeks

Result

Selected

I applied via Referral and was interviewed before Nov 2023. There was 1 interview round.

Round 1 - One-on-one

(2 Questions)

Q1. How to find the second highest salary

Add your answer

Q2. Question on dense rank,rank and row number

Add your answer

Nykaa Interview FAQs

How many rounds are there in Nykaa Data Analyst interview?

Nykaa interview process usually has 1 rounds. The most common rounds in the Nykaa interview process are Technical.

How to prepare for Nykaa 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 Nykaa. The most common topics and skills that interviewers at Nykaa expect are Data Analysis, Data Mining, Data Structures and MDM.

What are the top questions asked in Nykaa Data Analyst interview?

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

Any project related to online customer da...read more
Questions on SQL involving Joins, ranker over() partition by, Group by, Coalesc...read more
Python basic questions for rank and group by and the same to do in exc...read more

Assistant Manager 244 salaries	₹0 L/yr - ₹0 L/yr
Senior Executive 234 salaries	₹0 L/yr - ₹0 L/yr
Business Development Executive 185 salaries	₹0 L/yr - ₹0 L/yr
Beauty Advisor 180 salaries	₹0 L/yr - ₹0 L/yr
Associate Manager 119 salaries	₹0 L/yr - ₹0 L/yr

Nykaa Data Analyst Interview Questions and Answers

Nykaa Data Analyst Interview Experiences

2 interviews found

(2 Questions)

Interview Preparation Tips

Interview Questionnaire

4 Questions

Interview Preparation Tips

Data Analyst Interview Questions Asked at Other Companies

Interview questions from similar companies

Interview Questionnaire

2 Questions

Interview Preparation Tips

(3 Questions)

(1 Question)

(3 Questions)

(2 Questions)

Interview Preparation Tips

(2 Questions)

Interview Preparation Tips

(1 Question)

(1 Question)

(1 Question)

(2 Questions)

(2 Questions)

Nykaa Interview FAQs

Recently Viewed

Nykaa

Nykaa

Bank of America

Bank of America

Quantiphi Analytics Solutions Private Limited

Nykaa

Skill Lync

SPS Steels Rolling Mills

Bank of America

Bank of America

Tell us how to improve this page.

Nykaa Interviews By Designations

Interview Questions for Popular Designations

Nykaa Data Analyst Interview Process

Data Analyst Interview Questions from Similar Companies

Fast track your campus placements