Nykaa Analytics Manager Interview Questions and Answers

Q1. SQL and pandas coding
Add your answer
Q2. Resume projects deep dive
Add your answer

Q1. Explain all of decision tree and random forest?
Ans. 
Decision tree is a tree-like model of decisions and their possible consequences, while random forest is an ensemble learning method that builds multiple decision trees and merges them together.
• Decision tree is a flowchart-like structure where each internal node represents a decision based on an attribute, each branch represents the outcome of the decision, and each leaf node represents a class label.

• Random forest is a ...read more
Answered by AI
Add your answer
Q2. Some basic probability questions
Add your answer

Q1. What do you know about Uber?
Add your answer
Q2. Went over my current role
Add your answer

The first round was a 45 min long aptitude and case study round which involved basic aptitude questions along with certain cases like "There has been a drop off in customers booking a hotel though the the total number of visits to the site has not dropped. How would you you design a system to analyze the problem and what kind of data will you collect." It was followed by a couple of HR questions

A mock data set of hotel bookings in different countries for last two years were given a week prior to the interview. We were to clean, prepare, derive insights and recommend actions. All of this needed to be documented as 15 page presentation. This presentation then needed to be presented in a 45 min meet.

Q1. Write a SQL query to find all duplicate emails in a table named person
Ans. 
SQL query to find duplicate emails in a table named person
• Use GROUP BY and HAVING clause to group emails and count their occurrences

• Select only those emails which have count greater than 1

• Example: SELECT email, COUNT(*) FROM person GROUP BY email HAVING COUNT(*) > 1;
Answered by AI
Add your answer
Q2. Given a weather table, write a sql query to find all date's ids with higher temperature compared to it's previous dates
Ans. 
SQL query to find date ids with higher temperature compared to previous dates in weather table
• Use self join to compare temperature of current date with previous dates

• Order the table by date to ensure correct comparison

• Select date ids where temperature is higher than previous dates
Answered by AI
Add your answer

Business Related case study, signed NDA

Q1. Count number of Parameters in BERT
Add your answer
Q2. 3 sum array problem
Add your answer