Flipkart Business Consultant Analyst Interview Questions and Answers

Q1. Tell me about a time when you deep dived into an issue? What were the outcomes?
Add your answer
Q2. Tell me about a time when you came up with a metric. What was the metric? How was it used to determine the business goals?
Ans. 
I developed a customer satisfaction metric to measure the success of a new product launch.
• Identified key factors influencing customer satisfaction

• Designed a survey to collect feedback on these factors

• Created a scoring system to quantify satisfaction levels

• Analyzed survey results to track changes over time

• Used metric to adjust marketing strategies and improve product offerings
Answered by AI
Add your answer

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...read more
Answered by AI
Add your answer
Q2. Employees who earn more than their manager
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. What about indiaMART?. Tell me about internship experience? Why you joint indiamart?
Add your answer

It is easy test everyone to qualify the test total number of questions is 50 and the time is 30 minutes.

General topics like social media, COVID-19, Electrical vehicles in future.

Basis CAT like aptitude with 2 simple python coding 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...read more
Answered by AI
Add your answer

Q1. SQL QUERY QUESTIONS ON JOINS
Add your answer

Q1. Excel basic formulas like lookup
Add your answer

Q1. About Yourself, resume grilling
Add your answer

Python, SQL, Quant, Statistics, Numpy

Q1. SQL, Python, Puzzle total 9Q
Add your answer
Q2. Table, Query, 2 puzzle, Python 1 code (4 Sub code)
Add your answer

Q1. Yet to declare result for the round 2 i feel +ve for round 2 result lets se
Add your answer

MCQ Mostly - Aptitude and Time Distance

RCA - Drop in Metrics

Q1. SQL & Pythonassad
Add your answer