Add office photos
i
Meesho
Compare
Filter interviews by
Meesho Lead Business Analyst Interview Questions and Answers
Meesho Lead Business Analyst Interview Experiences
1 interview found
Varadharajan Sridharan
I applied via Referral and was interviewed in Aug 2024. There were 2 interview rounds.
Sql query error validation and analytics querying for test case
(2 Questions)
- Q1. Ab testing experiment based aptitude
- Q2. Sql query to find longest streak of orders by customer
- Ans.
Use SQL query to find longest streak of orders by customer
Use window functions like ROW_NUMBER() to assign a sequential number to each order for each customer
Partition the data by customer and order the rows by order date
Calculate the difference between the sequential numbers to identify streaks of consecutive orders
Select the maximum streak length for each customer
Interview Preparation Tips
Skills evaluated in this interview
Lead Business Analyst Jobs at Meesho
Top trending discussions
Interview questions from similar companies
(2 Questions)
- Q1. Basic SQL and Excel Questions
- Q2. Tell me about yourself
- Ans.
I am a highly motivated and results-driven individual with a strong background in business development and project management.
Graduated with a degree in Business Administration from XYZ University
Worked as a business development manager at ABC Company for 5 years
Successfully led a team to increase sales by 30% in the last quarter
Proficient in project management tools such as Asana and Trello
(2 Questions)
- Q1. Guesstimate on how many Burgers a shop will sell in a day
- Ans.
It depends on the location, popularity of the shop, menu offerings, and customer traffic.
Consider the location of the shop - is it in a busy area or a residential neighborhood?
Take into account the popularity of the shop - is it a well-known chain or a new establishment?
Menu offerings can also impact sales - do they offer a variety of burgers or just a few options?
Customer traffic throughout the day will also play a ro
- Q2. You role at previous company
- Ans.
I was responsible for managing client accounts and developing new business opportunities.
Managed client accounts to ensure satisfaction and retention
Identified and pursued new business opportunities to drive revenue growth
Collaborated with cross-functional teams to deliver solutions tailored to client needs
(2 Questions)
- Q1. Strengths and Weakness
- Q2. Why Swiggy
- Ans.
Swiggy is a leading food delivery platform with a strong presence in the market.
Swiggy has a wide range of restaurant partners offering diverse cuisines.
The platform provides quick and efficient delivery services to customers.
Swiggy offers various discounts and deals to attract and retain customers.
The user-friendly app interface makes ordering food convenient for customers.
Business Development Associate Interview Questions & Answers
Urban Company
Anonymous
posted on 2 Dec 2024
Selected
I applied via LinkedIn and was interviewed in Nov 2024. There were 2 interview rounds.
(4 Questions)
- Q1. Tell me about yourself
- Q2. What did you know about Urban Company?
- Q3. Why do you want to join?
- Q4. Will you be able to relocate and join within 2 days
(2 Questions)
- Q1. If you have to convince someone to get the service, how will you do?
- Q2. How will you generate leads?
(2 Questions)
- Q1. Tell me about your self
- Q2. Tell me about your overall experience
(2 Questions)
- Q1. Do you have excel sheet skills
- Q2. Send a mail regarding product quotation
- Ans.
I will send you the product quotation via email.
Address the recipient by name and company
Provide details of the products requested
Include pricing and any applicable discounts
End with a call to action for further discussion or confirmation
(2 Questions)
- Q1. Tell me about your experience in previous Organization and role and responsibility
- Q2. How you know about porter
(1 Question)
- Q1. Salary package discussion and expectation
Interview Preparation Tips
(2 Questions)
- Q1. Questions on sql joins and window functions.
- Q2. Window functions
Interview Preparation Tips
(1 Question)
- Q1. SQL based questions were asked on Group by, Window functions
The interview was good mostly on SQL, and Python
Selected
I applied via Approached by Company and was interviewed in Nov 2024. There was 1 interview round.
(2 Questions)
- Q1. Preview company details & working
- Q2. Product knowledge
(1 Question)
- Q1. Sql questions on advanced concepts
(1 Question)
- Q1. Previous experience and business questions
Selected
I applied via Instahyre and was interviewed in Nov 2023. There were 2 interview rounds.
(2 Questions)
- Q1. Going through your resume, past projects and metrics around that project.
- Q2. 2 SQL questions. 1. based on logic 2nd highest salary. 2. Basic Question on window functions and self join
(2 Questions)
- Q1. RCA on why the conversion is down on the app.
- Q2. SQL question of high difficulty (don't remember the question as that was his self made question)
Logic used: self join with date
Selected
(3 Questions)
- Q1. Business use cases on logistics & last mile delivery??
- Ans.
Business use cases on logistics & last mile delivery
Optimizing delivery routes to reduce time and cost
Implementing real-time tracking systems for better visibility
Using predictive analytics to forecast demand and optimize inventory
Implementing automated sorting and packaging systems to improve efficiency
Integrating with third-party delivery services to expand reach
Implementing customer feedback systems to improve servi
- Q2. Basic excel functions
- Q3. Sumifs, pivot tables, Vlookup etc.
Meesho Interview FAQs
Tell us how to improve this page.
Meesho Interviews By Designations
- Meesho Business Analyst Interview Questions
- Meesho Key Account Manager Interview Questions
- Meesho Software Developer Interview Questions
- Meesho Data Analyst Interview Questions
- Meesho Product Manager Interview Questions
- Meesho Sales Officer Interview Questions
- Meesho Team Lead Interview Questions
- Meesho Sales Executive Interview Questions
- Show more
Interview Questions for Popular Designations
- Business Analyst Interview Questions
- Associate Business Analyst Interview Questions
- Business Development Executive Interview Questions
- Business Development Manager Interview Questions
- Business Technology Analyst Interview Questions
- Business Development Associate Interview Questions
- Senior Business Analyst Interview Questions
- Junior Business Analyst Interview Questions
- Show more
Meesho Lead Business Analyst Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
Meesho Lead Business Analyst Reviews and Ratings
based on 2 reviews
Rating in categories
|
Key Account Manager
726
salaries
|  ₹3 L/yr - ₹6.9 L/yr |
|
City Manager
205
salaries
| ₹4 L/yr - ₹10 L/yr |
|
Business Analyst
189
salaries
| ₹8.2 L/yr - ₹21.5 L/yr |
|
Team Lead
167
salaries
| ₹1.6 L/yr - ₹9 L/yr |
|
Business Development Manager
165
salaries
| ₹3 L/yr - ₹7.5 L/yr |
Amazon
Flipkart
Myntra
GlowRoad
- Home >
- Interviews >
- Meesho Interview Questions >
- Meesho Lead Business Analyst Interview Questions
