Flipkart 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

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

Basic SQL questions around windows function

Q1. Guesstimate : Number of lamp posts in Delhi
Ans. 
It is estimated that there are around 2 million lamp posts in Delhi.
• Estimate based on population density and urban infrastructure development

• Consider factors like road length, area covered, and lighting requirements

• Assume an average of 1 lamp post per 100 meters of road

• Take into account different types of areas like residential, commercial, and industrial

• Use satellite imagery or government data for more accurate estima
Answered by AI
Add your answer
Q2. Conversion is down RCA
Add your answer

Conversion is going Down : Deepdive case study

Q1. Why want to join?
Ans. 
I am passionate about using data to drive strategic decisions and improve business outcomes.
• I have a strong background in analytics and data-driven decision making.

• I am excited about the opportunity to work with a talented team and contribute to the success of the organization.

• I believe that my skills and experience align well with the goals of the company.
Answered by AI
Add your answer
Q2. Career aspirations
Add your answer

Q1. Sql question based on window functions
Add your answer