AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Nykaa Business Analyst Interview Questions and Answers
Nykaa Business Analyst Interview Experiences
1 interview found
Anonymous
I applied via Naukri.com and was interviewed in Jan 2023. There was 1 interview round.
(2 Questions)
- Q1. What is your opinion about business?
- Ans.
Business is the backbone of the economy, driving innovation, growth, and prosperity.
Business plays a crucial role in creating jobs and generating income for individuals and communities.
It fosters competition, which leads to improved products and services for consumers.
Businesses contribute to economic development by investing in infrastructure and technology.
They provide opportunities for entrepreneurship and innovatio...
- Q2. Why business is important
- Ans.
Business is important because it drives economic growth, creates jobs, and fosters innovation.
Business drives economic growth by producing goods and services that meet the needs and wants of consumers.
Businesses create jobs by hiring employees and providing them with income and opportunities for career growth.
Businesses foster innovation by investing in research and development, driving technological advancements.
Busin...
Interview Preparation Tips
Interview questions from similar companies
I applied via LinkedIn and was interviewed in Sep 2024. There was 1 interview round.
(2 Questions)
- Q1. Joins and their output
- Ans.
Joins are used in SQL to combine rows from two or more tables based on a related column between them.
Joins are used to retrieve data from multiple tables based on a related column
Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
INNER JOIN returns rows when there is at least one match in both tables
LEFT JOIN returns all rows from the left table and the matched rows from the right table
RIGHT JOIN re...
- Q2. Employees who earn more than their manager
Skills evaluated in this interview
I applied via LinkedIn and was interviewed in Sep 2024. There was 1 interview round.
SQL queries - 3. Was asked to write on notepad using the table structure given by interviewer
Interview Preparation Tips
- Hackerrank
- Stratascratch
- Leetcode
(2 Questions)
- Q1. Tell me about a project you faced difficulties?
- Q2. Given a table ..asked some SQL questions
(2 Questions)
- Q1. Shared a table ...asked to write some SQL queries
- Q2. Sman queries result how to derive in excel
- Ans.
Use Excel functions like VLOOKUP or INDEX/MATCH to derive results from SQL queries in Excel.
Use VLOOKUP function to search for a value in a table and return a corresponding value from another column.
Use INDEX/MATCH function to perform a two-way lookup by matching values in two different ranges.
Import SQL query results into Excel using data connection or copy-paste method.
Interview Preparation Tips
Skills evaluated in this interview
Rahul Kiroriwal
Basis CAT like aptitude with 2 simple python coding question
(1 Question)
- Q1. What Central limit theorem
- Ans.
The Central Limit Theorem states that the sampling distribution of the sample mean approaches a normal distribution as the sample size increases.
States that the sampling distribution of the sample mean will be approximately normally distributed regardless of the shape of the population distribution
Helps in making inferences about the population mean based on the sample mean
Important concept in statistics and hypothesis...
Selected
I applied via Referral and was interviewed in Feb 2024. There were 3 interview rounds.
(1 Question)
- Q1. SQL QUERY QUESTIONS ON JOINS
(1 Question)
- Q1. Excel basic formulas like lookup
(1 Question)
- Q1. About Yourself, resume grilling
Interview Preparation Tips
I was interviewed in Oct 2023.
Python, SQL, Quant, Statistics, Numpy
(2 Questions)
- Q1. SQL, Python, Puzzle total 9Q
- Q2. Table, Query, 2 puzzle, Python 1 code (4 Sub code)
(1 Question)
- Q1. Yet to declare result for the round 2 i feel +ve for round 2 result lets se
MCQ Mostly - Aptitude and Time Distance
RCA - Drop in Metrics
(1 Question)
- Q1. SQL & Pythonassad
Interview Preparation Tips
I applied via Company Website and was interviewed in Feb 2022. There were 2 interview rounds.
(1 Question)
- Q1. Asking about yourself and asking of other knowledge and consulting knowledge.
Interview Preparation Tips
- Sales
(2 Questions)
- Q1. Sumifs Functions
- Q2. Vlookup Function
Interview Preparation Tips
Advance Excel -
Sumifs formula may be they will ask a commission payout question in which you have to find the commission payout value then in Sheet 1 you have the master data, sheet 2 you have Commission percentage in sheet 3 you have to do work
Then use the sumifs formula for just reference i am writing the formula here
=sumifs for the total & join the formula with vlookup for % calculation
in SQL they might ask the questions
-DDL & DML
-Group query etc.
Nykaa Interview FAQs
Tell us how to improve this page.
Nykaa Interviews By Designations
- Nykaa Beauty Advisor Interview Questions
- Nykaa Senior Software Engineer Interview Questions
- Nykaa Android Developer Interview Questions
- Nykaa Product Manager Interview Questions
- Nykaa Store Manager Interview Questions
- Nykaa Applications Engineer Interview Questions
- Nykaa Assistant Manager Interview Questions
- Nykaa Assistant Manager - Content Interview Questions
- Show more
Interview Questions for Popular Designations
- Business Development Executive Interview Questions
- Business Development Manager Interview Questions
- Business Development Associate Interview Questions
- Senior Business Analyst Interview Questions
- Business Associate Interview Questions
- Business Development Interview Questions
- Business Executive Interview Questions
- Business Manager Interview Questions
- Show more
Nykaa Business Analyst Interview Process
based on 1 interview
Interview experience
Business Analyst Interview Questions from Similar Companies
Fast track your campus placements
|
Assistant Manager
239
salaries
|  ₹5.4 L/yr - ₹17 L/yr |
|
Senior Executive
233
salaries
| ₹2.4 L/yr - ₹10 L/yr |
|
Business Development Executive
196
salaries
| ₹1.8 L/yr - ₹4.5 L/yr |
|
Beauty Advisor
187
salaries
| ₹1.7 L/yr - ₹5 L/yr |
|
Store Manager
114
salaries
| ₹4.4 L/yr - ₹10 L/yr |
Myntra
Purplle.com
LimeRoad
Voonik
- Home >
- Interviews >
- Nykaa Interview Questions >
- Nykaa Business Analyst Interview Questions
