AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Flipkart Health+ Senior Business Analyst Interview Questions and Answers for Experienced
Flipkart Health+ Senior Business Analyst Interview Experiences for Experienced
1 interview found
Anonymous
Selected
I applied via LinkedIn and was interviewed before Apr 2023. There was 1 interview round.
(1 Question)
- Q1. How to find the month on Month repeat rate in a single query for the year 2023
- Ans.
To find the month on month repeat rate in a single query for the year 2023, you can use a SQL query with a self-join on the date column.
Use a self-join on the date column to compare data from the same month in different years
Calculate the repeat rate by dividing the count of repeated events by the total count of events in the month
Filter the data for the year 2023 to focus on the specific time period
Interview Preparation Tips
Skills evaluated in this interview
Interview questions from similar companies
I applied via LinkedIn and was interviewed in Apr 2020. There were 4 interview rounds.
Interview Questionnaire
2 Questions
- Q1. How can you reduce the delivery time of the order?
- Ans.
Reducing delivery time can be achieved by optimizing the supply chain, improving communication, and automating processes.
Analyze the supply chain and identify bottlenecks
Implement automation tools to streamline processes
Improve communication between departments and with customers
Use data analytics to forecast demand and plan accordingly
Consider outsourcing or partnering with third-party logistics providers
Invest in tec...
- Q2. Questions based on Case Studies
Interview Preparation Tips
I applied via Walk-in and was interviewed before Feb 2021. There were 3 interview rounds.
(1 Question)
- Q1. Tell me about yourself.
Interview Preparation Tips
I applied via LinkedIn and was interviewed before May 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Questions were from SQL, Python, Statistics & Business Case Studies/Metrics in the form of 4-5 rounds.
Interview Preparation Tips
I appeared for an interview in Nov 2020.
Interview Questionnaire
1 Question
- Q1. Mainly about sql, previous job role
I applied via Company Website and was interviewed in Jan 2021. There were 4 interview rounds.
Interview Questionnaire
2 Questions
- Q1. About General Insurannce bancasurance experience
- Q2. Let it be very clear when you are speaking about general Insurance and also about your chanel sales developement.
Interview Preparation Tips
Interview Questionnaire
1 Question
- Q1. How much work experience
- Ans.
The amount of work experience is an important factor in determining the suitability of a candidate for the Business Analyst role.
Work experience helps in developing a deep understanding of business processes and industry trends.
It allows the candidate to gain practical knowledge and skills in data analysis, problem-solving, and project management.
Having relevant work experience demonstrates the ability to work effectiv...
Interview Preparation Tips
I applied via Referral and was interviewed before May 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. How can you understand the supply of restaurant in a particular area of a city ?
- Ans.
To understand the supply of restaurants in a particular area of a city, we can use various methods.
Collect data from online directories like Yelp, Zomato, etc.
Conduct surveys to gather information about the number of restaurants in the area.
Analyze the population density and demographics of the area to estimate the demand for restaurants.
Check the number of restaurant permits issued by the local government.
Use GIS mapp...
Interview Preparation Tips
Selected
I applied via Naukri.com and was interviewed before Nov 2023. There were 2 interview rounds.
(2 Questions)
- Q1. Find 3rd highest salary using SQL
- Ans.
Use SQL query with ORDER BY and LIMIT to find 3rd highest salary.
Use SELECT statement to retrieve salary column
Use ORDER BY clause to sort salaries in descending order
Use LIMIT 2,1 to skip first two highest salaries and retrieve the third highest salary
- Q2. Queries on self join
(1 Question)
- Q1. Questions on Power B, DAX etc.,
Skills evaluated in this interview
I applied via IIM Jobs and was interviewed in Nov 2020. There were 3 interview rounds.
Interview Questionnaire
7 Questions
- Q1. Advance SQL Questions.
- Q2. Multiple Approaches in the SQL questions were seen. Some unconventional SQL Syntax was also asked.
- Q3. Metrics Driven Case studies.
- Q4. More number of solutions were seen instead of in depth implementation of 1 solution. Good Communication skills is judged.
- Q5. Tell me something about yourself.
- Ans.
I am a highly motivated and detail-oriented Business Analyst with a strong background in data analysis and problem-solving.
I have a Bachelor's degree in Business Administration with a focus on analytics.
I have experience working with cross-functional teams to gather and analyze business requirements.
I am proficient in using tools such as Excel, SQL, and Tableau for data analysis and visualization.
I have successfully im...
- Q6. Why quit last job.
- Ans.
Seeking better growth opportunities and work-life balance.
Limited growth prospects in previous role
Lack of work-life balance
Desire for new challenges and learning opportunities
Company culture misalignment
Relocation or commute issues
Better compensation or benefits elsewhere
- Q7. Why Meesho.
- Ans.
Meesho is a leading e-commerce platform that empowers individuals to start their own online businesses.
Meesho provides a user-friendly platform for individuals to sell products online without any investment.
It offers a wide range of products from various categories, allowing sellers to cater to different customer preferences.
Meesho provides extensive training and support to its sellers, helping them succeed in their on...
Interview Preparation Tips
Flipkart Health+ Interview FAQs
Tell us how to improve this page.
Flipkart Health+ Interviews By Designations
- Flipkart Health+ Pharmacist Interview Questions
- Flipkart Health+ Data Analyst Interview Questions
- Flipkart Health+ Senior Business Analyst Interview Questions
- Flipkart Health+ Web Developer Interview Questions
- Flipkart Health+ Business Analyst Interview Questions
- Flipkart Health+ Intern Interview Questions
- Flipkart Health+ Sales Executive Interview Questions
- Flipkart Health+ Senior Executive Interview Questions
- Show more
Interview Questions for Popular Designations
- Business Analyst Interview Questions
- Business Development Executive Interview Questions
- Business Development Manager Interview Questions
- Business Development Associate Interview Questions
- Business Associate Interview Questions
- Business Development Interview Questions
- Business Executive Interview Questions
- Business Manager Interview Questions
- Show more
Flipkart Health+ Senior Business Analyst Interview Process for Experienced
based on 1 interview
Interview experience
Interview Questions from Similar Companies
|
Assistant Manager
83
salaries
|  ₹2.8 L/yr - ₹6 L/yr |
|
Senior Executive
60
salaries
| ₹2 L/yr - ₹4.2 L/yr |
|
Pharmacist
50
salaries
| ₹2 L/yr - ₹5.5 L/yr |
|
Executive
36
salaries
| ₹1.3 L/yr - ₹5 L/yr |
|
Executive Pharmacist
30
salaries
| ₹3.5 L/yr - ₹4.8 L/yr |
Udaan
Swiggy
BlackBuck
Ninjacart
- Home >
- Interviews >
- Flipkart Health+ Interview Questions >
- Flipkart Health+ Senior Business Analyst Interview Questions for Experienced
