AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Flipkart
Compare
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Flipkart Business Analyst Interview Questions, Process, and Tips
Top Flipkart Business Analyst Interview Questions and Answers
- Q1. If you have 100 unbiased coins and one of them is defective. You have a weighing balance to check the weight of the coins. What is the minimum number of times you need to ...read more
- Q2. A car manufacturer has observed a decline in profits by 40% year over year. What would be the possible reasons for this?
- Q3. Visualize a Uber database of drivers and riders(users) and write a SQL query to get the top 100 drivers by city.
Flipkart Business Analyst Interview Experiences
10 interviews found
Anonymous
(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
Casestudy relate dto ab testing
Sql tests on joins and emp database
(2 Questions)
- Q1. Why do you want to switch
- Ans.
I am looking for new challenges and opportunities for growth in my career.
Seeking opportunities to expand my skill set
Interested in working on different projects and industries
Want to learn new technologies and methodologies
Desire for career advancement and professional development
- Q2. Why do you want to join flipkart?
- Ans.
I want to join Flipkart because of its innovative work culture and market leadership in the e-commerce industry.
Impressed by Flipkart's innovative approach to e-commerce
Excited about the opportunity to work in a market leader in the industry
Interested in contributing to Flipkart's growth and success
Appreciate Flipkart's focus on customer satisfaction and user experience
Harshkumar Mukeshbhai Patel
Sql joins and ranks and all
(2 Questions)
- Q1. Tell about yourself
- Q2. What is expected
What people are saying about Flipkart
I applied via Naukri.com and was interviewed in May 2024. There were 2 interview rounds.
Basic aptitude test which is easily done
(2 Questions)
- Q1. What are joins? What is windows function
- Ans.
Joins are used to combine rows from two or more tables based on a related column between them. Window functions perform calculations across a set of table rows that are related to the current row.
Joins are used in SQL to combine data from multiple tables based on a related column
Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
Window functions are used to perform calculations on a set of rows rela...
- Q2. Aggregation and ctes and subqueries
Interview Preparation Tips
Skills evaluated in this interview
Flipkart interview questions for designations
I applied via Referral and was interviewed in Apr 2024. There was 1 interview round.
(1 Question)
- Q1. QL Question and Schema design
Get interview-ready with Top Flipkart Interview Questions
120, it was good interview
120, it was good interview
120, it was good interview
(3 Questions)
- Q1. Introduction and Current job
- Q2. Weakness strength
- Q3. What makes you good fiy
Selected
I applied via campus placement at Indian Institute of Technology (IIT), Chennai and was interviewed before Apr 2023. There were 3 interview rounds.
Topic was given to a group of 10 students and 10 were shortlisted.
(2 Questions)
- Q1. Included guesstimates and business case studies.
- Q2. Number of netflix users in Delhi
- Ans.
The number of Netflix users in Delhi is not publicly available.
The exact number of Netflix users in Delhi is not disclosed by Netflix.
One way to estimate the number of users in Delhi could be to look at the overall subscriber base in India and make assumptions based on population demographics.
Market research firms may have data on the number of Netflix users in India, but specific data for Delhi may not be available.
(1 Question)
- Q1. Questions based on situations and about the reason to join this role.
I was interviewed before Nov 2019.
Interview Questionnaire
6 Questions
- Q1. Visualize a Uber database of drivers and riders(users) and write a SQL query to get the top 100 drivers by city.
- Ans.
SQL query to get top 100 Uber drivers by city
Join drivers and users tables on city
Aggregate driver ratings and count of rides
Order by rating and count of rides
Limit to top 100
- Q2. How do you optimize the listing of Restaurants on Swiggy?
- Ans.
Optimizing the listing of Restaurants on Swiggy involves using data-driven strategies to improve visibility, relevance, and user experience.
Analyze user behavior and preferences to understand their needs and preferences
Implement a ranking algorithm based on factors like ratings, reviews, popularity, and delivery time
Optimize search functionality to ensure accurate and relevant results
Collaborate with restaurants to imp...
- Q3. What are the major differences between a Linear Regression and a Logistic Regression?
- Ans.
Linear Regression is used for continuous data while Logistic Regression is used for categorical data.
Linear Regression predicts continuous values while Logistic Regression predicts probabilities.
Linear Regression uses a straight line to fit the data while Logistic Regression uses an S-shaped curve.
Linear Regression uses Mean Squared Error as the cost function while Logistic Regression uses Log Loss.
Linear Regression is...
- Q4. What is the Bias Variance trade-off and name some models with high bias and low variance?
- Ans.
Bias-Variance trade-off is the balance between overfitting and underfitting. High bias models are simple but inaccurate, low variance models are complex but overfit.
Bias-Variance trade-off is a fundamental concept in machine learning.
High bias models are simple and have low variance, but are inaccurate.
Low bias models are complex and have high variance, but can overfit the data.
Examples of high bias models are linear r...
- Q5. A car manufacturer has observed a decline in profits by 40% year over year. What would be the possible reasons for this?
- Ans.
Possible reasons for a car manufacturer's decline in profits by 40% year over year
Decreased demand for cars due to economic downturn
Increased competition from other car manufacturers
Rising production costs and expenses
Decline in consumer confidence and spending
Changes in government regulations impacting the automotive industry
- Q6. If you have 100 unbiased coins and one of them is defective. You have a weighing balance to check the weight of the coins. What is the minimum number of times you need to weigh the coins to identify the de...
Interview Preparation Tips
Skills evaluated in this interview
Interview Questionnaire
1 Question
- Q1. Question 1: General HR questions, some based on the CV Question 2: A marketing specific question
Interview Preparation Tips
Experience: The test basically tests your ability to solve questions as quickly as possible as it's a 60 minute test for 60 questions. The level of difficulty is pretty decent, so one just needs to be focused right from the beginning. English can trouble a bit, so some practice in English sections is also advisable.
Tips: Prepare from Arun Sharma Quantitative Aptitude and Logical Reasoning for CAT. It's a wholesome book and has enough questions to practice and build concepts. Join a test series so that you get a timed analysis of your performance, the ability to skip tough questions and to score as many marks as possible.
Duration: 40 minutes
Round: Group Discussion
Experience: It went pretty well. We had a great discussion. The approach was to list out all the problems one by one and think of probable solutions for each of them. During this, general group dynamics should be taken in consideration. Respect the views and thoughts of other people. Add value to the discussion by thinking critically and bringing new content every now and then. Always be specific and speak to the point.
Tips: Read. Read and Read.
Follow google news, read relevant articles in newspapers, magazines, social media sites or any other place.
Follow Quora, It'a an amazing source to boost your knowledge around any topic.
Duration: 50 minutes
Round: HR Interview
Experience: Be spontaneous, little humorous and lastly very confident. Communication skills improve with time, so start as early as possible. Take part in discussions. Speak up !
Tips: Have a sound knowledge about the industry and the company. They just check your approach. So be very clear and critical on the approach. Have good reasons to back what ever you present. Rest will be fine.
Skills: Communication And Confidence, Analytical Skills, Business Logic, Business Acumen
College Name: Institute of Management, Nirma University
Aman Tomar
Interview Questionnaire
3 Questions
- Q1. General HR questions, some based on the CV
- Q2. A marketing specific question
- Q3. Weight of an aircraft
- Ans.
The weight of an aircraft is crucial for its performance and safety.
The weight of an aircraft includes the weight of the aircraft itself, fuel, passengers, cargo, and any other equipment on board.
The weight of an aircraft is measured in pounds or kilograms.
The weight of an aircraft affects its takeoff and landing performance, as well as its fuel efficiency and range.
Aircraft manufacturers provide maximum takeoff and la...
Interview Preparation Tips
Experience: The test basically tests your ability to solve questions as quickly as possible as it's a 60 minute test for 60 questions. The level of difficulty is pretty decent, so one just needs to be focused right from the beginning. English can trouble a bit, so some practice in English sections is also advisable.
Tips: Prepare from Arun Sharma Quantitative Aptitude and Logical Reasoning for CAT. It's a wholesome book and has enough questions to practice and build concepts. Join a test series so that you get a timed analysis of your performance, the ability to skip tough questions and to score as many marks as possible.
Round: Group Discussion
Experience: It went pretty well. We had a great discussion. The approach was to list out all the problems one by one and think of probable solutions for each of them. During this, general group dynamics should be taken in consideration. Respect the views and thoughts of other people. Add value to the discussion by thinking critically and bringing new content every now and then. Always be specific and speak to the point.
Tips: Read. Read and Read.
Follow google news, read relevant articles in newspapers, magazines, social media sites or any other place.
Follow Quora, It'a an amazing source to boost your knowledge around any topic.
Round: HR Interview
Experience: Be spontaneous, little humorous and lastly very confident. Communication skills improve with time, so start as early as possible. Take part in discussions. Speak up !
Tips: Have a sound knowledge about the industry and the company. They just check your approach. So be very clear and critical on the approach. Have good reasons to back what ever you present. Rest will be fine.
Round: Guesstimate Interview
Experience: A very commonly asked guesstimate problem. Ask as many questions as possible to clear out the situation for yourself and get enough hints to solve the problem. Break it down into smaller sections and solve each section individually.
Tips: Follow "case in point", Analytics Vidya and similar blogs and websites to practice more and more guesstimates.
General Tips: There are so many opportunities. You just need one. Be focused on that ONE.
Skill Tips: Take part in discussions among your friends. Read books and quora to get more content. Practice as many questions as possible for aptitude. Discuss problems and have critical analysis sessions to understand things with a company's perspective.
Skills: Communication , Aptitude, Business Acumen
College Name: IIT GUWHATI
Motivation: To learn the operations and Logistics of the e-commerce industry.
Funny Moments: There will be many while you'll be preparing with your friends. :D
All the best.
Flipkart Interview FAQs
Some of the top questions asked at the Flipkart Business Analyst interview -
Tell us how to improve this page.
Flipkart Interviews By Designations
- Flipkart Data Entry Operator Interview Questions
- Flipkart Senior Executive Interview Questions
- Flipkart Operations Executive Interview Questions
- Flipkart Software Developer Interview Questions
- Flipkart Team Lead Interview Questions
- Flipkart Graduate Trainee Interview Questions
- Flipkart Customer Service Executive Interview Questions
- Flipkart Executive Interview Questions
- Show more
Flipkart Business Analyst Interview Process
based on 11 interviews
2 Interview rounds
- Group Discussion Round
- HR Round
Business Analyst Interview Questions from Similar Companies
Fast track your campus placements
Flipkart Business Analyst Reviews and Ratings
based on 27 reviews
Rating in categories
|
Senior Executive
2.5k
salaries
|  ₹2 L/yr - ₹9 L/yr |
|
Operations Executive
1.8k
salaries
| ₹1.2 L/yr - ₹6.3 L/yr |
|
Team Lead
1.8k
salaries
| ₹1.2 L/yr - ₹9.8 L/yr |
|
Assistant Manager
1.5k
salaries
| ₹6 L/yr - ₹21 L/yr |
|
Executive
1.3k
salaries
| ₹1.2 L/yr - ₹7 L/yr |
Amazon
Myntra
Snapdeal
Meesho
- Home >
- Interviews >
- Flipkart Interview Questions >
- Flipkart Business Analyst Interview Questions
