Interview Query
Meesho Business Analyst Interview Questions + Guide in 2025

Meesho Business Analyst Interview Questions + Guide in 2025

Overview

Meesho is a rapidly growing social commerce platform in India that empowers small businesses and entrepreneurs to sell their products online.

As a Business Analyst at Meesho, you will play a crucial role in enhancing reporting tools, optimizing processes, and delivering insights that drive strategic decision-making. Key responsibilities include analyzing data to identify trends and root causes of issues, creating algorithms to optimize demand and supply, and collaborating with various internal partners to exceed service levels. Proficiency in advanced SQL and Excel is essential, complemented by a solid understanding of statistics and problem-solving skills. Ideal candidates will not only possess technical expertise but also demonstrate a passion for advocating for users while aligning with business objectives.

This guide will help you prepare for your interview by providing insights into the expectations and skills required for the Business Analyst role at Meesho.

Meesho Business Analyst Interview Questions

In this section, we’ll review the various interview questions that might be asked during a Business Analyst interview at Meesho. The interview process will likely focus on your analytical skills, technical proficiency in SQL and Excel, as well as your ability to solve business problems through case studies and guesstimates. Be prepared to demonstrate your understanding of metrics, data analysis, and strategic planning.

Technical Skills

1. Can you explain the difference between INNER JOIN and OUTER JOIN in SQL?

Understanding SQL joins is crucial for a Business Analyst role, as they are often used to combine data from multiple tables.

How to Answer

Clearly define both INNER JOIN and OUTER JOIN, providing examples of when each would be used in a business context.

Example

“An INNER JOIN returns only the rows where there is a match in both tables, while an OUTER JOIN returns all rows from one table and the matched rows from the other. For instance, if I have a table of customers and a table of orders, an INNER JOIN would show only customers who have placed orders, whereas an OUTER JOIN would show all customers, including those who haven’t placed any orders.”

2. Write a SQL query to find the cumulative sum of sales for each month.

This question tests your ability to use window functions, which are essential for analyzing trends over time.

How to Answer

Explain the use of the SUM() function along with the OVER() clause to calculate cumulative totals.

Example

“I would use the following SQL query: SELECT month, SUM(sales) OVER (ORDER BY month) AS cumulative_sales FROM sales_data; This will give me the cumulative sales for each month, allowing me to analyze trends effectively.”

3. How would you handle missing data in a dataset?

Handling missing data is a common challenge in data analysis.

How to Answer

Discuss various strategies such as imputation, removal, or using algorithms that can handle missing values.

Example

“I would first assess the extent of the missing data. If it’s minimal, I might choose to remove those records. For larger gaps, I could use imputation techniques, such as filling in missing values with the mean or median, or using predictive models to estimate the missing values.”

4. Can you explain the concept of window functions in SQL?

Window functions are critical for performing calculations across a set of table rows related to the current row.

How to Answer

Define window functions and provide an example of their application.

Example

“Window functions allow us to perform calculations across a set of rows that are related to the current row. For example, using ROW_NUMBER() can help rank sales representatives based on their sales figures without collapsing the result set.”

5. Describe a time when you used data analysis to solve a business problem.

This question assesses your practical experience and problem-solving skills.

How to Answer

Use the STAR method (Situation, Task, Action, Result) to structure your response.

Example

“In my previous role, we noticed a decline in customer retention rates. I analyzed customer feedback and purchase data to identify trends. I discovered that customers were dissatisfied with our delivery times. I presented my findings to management, and we implemented a new logistics strategy that improved delivery times by 20%, resulting in a 15% increase in retention rates.”

Business Acumen

1. How would you prioritize multiple requests from different stakeholders?

This question evaluates your ability to manage competing priorities.

How to Answer

Discuss your approach to assessing the impact and urgency of each request.

Example

“I would first categorize the requests based on their urgency and impact on business goals. I would then communicate with stakeholders to understand their needs better and negotiate timelines, ensuring that the most critical requests are addressed first.”

2. Explain a business metric you have worked with and its importance.

Understanding key business metrics is essential for a Business Analyst.

How to Answer

Choose a relevant metric and explain how it impacts business decisions.

Example

“I have worked extensively with Customer Acquisition Cost (CAC). It’s crucial because it helps the company understand how much it costs to acquire a new customer. By analyzing CAC alongside Customer Lifetime Value (CLV), we can make informed decisions about marketing budgets and strategies.”

3. How would you approach a case study where sales have suddenly dropped?

This question tests your analytical thinking and problem-solving skills.

How to Answer

Outline a structured approach to identify potential causes and solutions.

Example

“I would start by gathering data on sales trends, customer feedback, and market conditions. I would analyze the data to identify any patterns or anomalies. Then, I would conduct root cause analysis to determine if the drop was due to internal factors, such as product issues, or external factors, like increased competition. Finally, I would present my findings and recommend actionable strategies to address the issue.”

4. What steps would you take to analyze a new market opportunity?

This question assesses your strategic thinking and market analysis skills.

How to Answer

Discuss the steps you would take to evaluate the opportunity, including market research and competitive analysis.

Example

“I would begin with market research to understand the target audience and their needs. Then, I would analyze competitors to identify gaps in the market. Finally, I would assess the potential return on investment and present a business case to stakeholders.”

5. How do you ensure that your analysis aligns with business goals?

This question evaluates your understanding of aligning data analysis with strategic objectives.

How to Answer

Discuss your approach to understanding business goals and how you incorporate them into your analysis.

Example

“I ensure alignment by regularly communicating with stakeholders to understand their objectives. I also review the company’s strategic goals and ensure that my analysis focuses on metrics that directly impact those goals, providing actionable insights that drive decision-making.”

Question
Topics
Difficulty
Ask Chance
Pandas
Medium
Very High
Pandas
Easy
Very High
Loading pricing options

View all Meesho Business Analyst questions

Meesho Business Analyst Interview Tips

Here are some tips to help you excel in your interview.

Understand the Role and Company Culture

Before your interview, take the time to deeply understand Meesho's business model, values, and the specific role of a Business Analyst. Familiarize yourself with their focus on e-commerce and how they leverage data to drive decisions. This knowledge will not only help you answer questions more effectively but also demonstrate your genuine interest in the company. Be prepared to discuss how your skills and experiences align with Meesho's mission and how you can contribute to their goals.

Master SQL and Excel

Given the emphasis on SQL and Excel in the interview process, ensure you are well-versed in advanced SQL queries, including window functions, joins, and aggregate functions. Practice solving complex SQL problems, as many candidates reported that SQL assessments were a significant part of the interview. Additionally, brush up on Excel skills, particularly in data analysis and visualization, as these tools are crucial for a Business Analyst role at Meesho.

Prepare for Case Studies and Guesstimates

Expect to encounter case study questions that require you to analyze business scenarios and provide actionable insights. Familiarize yourself with common business metrics and how they apply to e-commerce. Practice structuring your thought process when tackling guesstimate questions, as these are often used to assess your analytical skills and problem-solving abilities. Be ready to explain your reasoning clearly and logically.

Showcase Your Problem-Solving Skills

Throughout the interview, emphasize your problem-solving capabilities. Be prepared to discuss past experiences where you identified issues, analyzed data, and implemented solutions. Use the STAR (Situation, Task, Action, Result) method to structure your responses, ensuring you highlight the impact of your contributions. This will demonstrate your ability to think critically and strategically, which is essential for a Business Analyst at Meesho.

Engage with Interviewers

During the interview, actively engage with your interviewers. Ask insightful questions about the team, projects, and challenges they face. This not only shows your interest in the role but also allows you to gauge if Meesho is the right fit for you. Be personable and confident, as building rapport can leave a positive impression.

Prepare for Behavioral Questions

Expect behavioral questions that explore your past experiences and how they relate to the role. Reflect on your career journey, focusing on challenges you've faced, how you've worked with teams, and your approach to achieving goals. Be honest and authentic in your responses, as Meesho values candidates who align with their culture and can contribute positively to the team dynamic.

Follow Up and Reflect

After your interview, take the time to reflect on your performance and follow up with a thank-you note. Express your appreciation for the opportunity and reiterate your enthusiasm for the role. This not only shows professionalism but also keeps you on the interviewers' radar as they make their decisions.

By preparing thoroughly and approaching the interview with confidence and curiosity, you can position yourself as a strong candidate for the Business Analyst role at Meesho. Good luck!

Meesho Business Analyst Interview Process

The interview process for a Business Analyst role at Meesho is structured and involves multiple stages to assess both technical and analytical skills, as well as cultural fit.

1. Resume Shortlisting

The process begins with a thorough review of your resume by the recruitment team. They will evaluate your qualifications, experience, and skills to ensure they align with the requirements of the Business Analyst role. If your profile matches, you will be contacted for the next steps.

2. Online Assessment

Candidates typically undergo an online assessment, often conducted through platforms like HackerRank. This assessment focuses on SQL queries, data structures, and algorithms. Expect to encounter multiple-choice questions and coding challenges that test your proficiency in SQL, including complex queries involving joins, window functions, and debugging scenarios.

3. Technical Interview

Following the online assessment, successful candidates will participate in one or more technical interviews. These interviews delve deeper into your SQL knowledge, analytical skills, and problem-solving abilities. You may be asked to solve case studies or real-world business problems, requiring you to demonstrate your thought process and analytical reasoning. Be prepared to discuss your past projects and how they relate to the role.

4. Business Case Round

In this round, you will be presented with a business case or scenario relevant to Meesho's operations. You will need to analyze the situation, identify key metrics, and propose actionable solutions. This round assesses your ability to think critically and strategically about business challenges.

5. Behavioral Interview

The final round typically involves a behavioral interview, where the interviewer will explore your past experiences, motivations, and how you align with Meesho's values. Expect questions about teamwork, conflict resolution, and your approach to problem-solving. This round is crucial for assessing cultural fit within the organization.

6. HR Round

If you successfully navigate the previous rounds, you will have an HR interview. This round focuses on discussing your expectations, salary negotiations, and any remaining questions you may have about the role or the company.

As you prepare for these interviews, it's essential to familiarize yourself with the types of questions that may be asked, particularly those related to SQL, business metrics, and case studies.

What Meesho Looks for in a Business Analyst

1. Create a function sum_pair_indices to find indices of two integers in an array that add up to a target integer.

Given an array and a target integer, write a function sum_pair_indices that returns the indices of two integers in the array that add up to the target integer. If not found, just return an empty list. Ensure the solution runs in (O(n)) time and does not use the same index twice.

2. How would you set up an A/B test for multiple changes in a sign-up funnel?

A team wants to A/B test changes in a sign-up funnel, such as changing a button from red to blue and/or moving it from the top to the bottom of the page. How would you set up this test?

3. Where and how could you promote Instagram through Facebook?

You work on the growth team at Facebook and need to promote Instagram within the Facebook app. Where and how would you promote Instagram through Facebook?

4. What metrics/graphs/models would you use to analyze churn behavior for different pricing plans?

You work for a company like Netflix with two pricing plans: $15/month or $100/year. An executive wants you to analyze the churn behavior of users subscribed to either plan. What metrics, graphs, or models would you build to provide an overarching view of subscription performance?

5. What analysis would you run for non-normal distribution in an A/B test with low data?

Uber Fleet has low data for experimentation, and you find the distribution is not normal in an A/B test. What kind of analysis would you run, and how would you measure which variant won?

6. What retention rate is required to surpass revenue from a non-subscription price?

You sell an e-commerce product for $29 with a 50% per unit margin. You want to switch to a monthly subscription model at a 20% discount on the retail price. What retention rate would be required to surpass the revenue from the non-subscription price?

7. How would you explain what a p-value is to someone who is not technical?

Explain the concept of a p-value in simple terms to a non-technical person, focusing on its role in determining the significance of results in an experiment or study.

8. What could be the cause of the decrease in overall capital approval rates?

Analyze why the overall capital approval rate dropped from 85% to 82% despite individual product approval rates staying flat or increasing. Consider factors such as changes in the mix of products or external influences.

9. What is the probability that both flips result in the same side with one fair and one biased coin?

Calculate the probability that both flips result in the same side when selecting a coin at random, where one coin is fair and the other has a 34 probability of landing heads.

10. What is the percentage chance a review is actually fake when the algorithm detects it as fake?

Determine the probability that a review is fake given that the machine learning algorithm has identified it as fake, considering the base rates and accuracy of the algorithm.

11. What metrics would you use to track accuracy and validity of a spam classifier model?

Assume you have built a V1 of a spam classifier for emails. What metrics would you use to evaluate the model’s accuracy and validity?

12. When would you use a bagging algorithm versus a boosting algorithm?

Compare two machine learning algorithms. In which scenarios would you prefer a bagging algorithm over a boosting algorithm? Provide examples of the tradeoffs between the two.

13. What are the assumptions of linear regression?

List and explain the key assumptions underlying linear regression models.

14. How would you build a restaurant recommender on Facebook?

Describe how you would gather data and build a restaurant recommendation system for Facebook. What potential issues or concerns might arise from adding this feature?

15. How would you design the YouTube video recommendation algorithm?

Explain how you would design a recommendation system for YouTube videos. What important factors should be considered when building this recommendation algorithm?

How to Prepare for a Business Analyst Interview at Meesho

You should plan to brush up on any technical skills and try as many practice interview questions and mock interviews as possible. A few tips for acing your Meesho business analyst interview include:

  • Master SQL and DBMS Concepts: Given that a significant part of the interview process revolves around SQL queries and database management, make sure you are proficient in these areas, especially with complex queries and window functions.
  • Prepare for Case Studies and Guesstimates: Meesho places a strong emphasis on business scenarios and analytical thinking. Practice solving different business case studies and guesstimates to demonstrate your problem-solving skills.
  • Showcase Relevant Experience: Be prepared to discuss your past projects and how they align with the responsibilities of the role you’re applying for. Ensure that you can clearly articulate your work and its impact.

FAQs

What is the average salary for a Business Analyst at Apixio?

According to Glassdoor, Business Analyst at Meesho earn between $97K to $101K per year, with an average of $99K per year.

What specific skills and experience are Meesho looking for in a Business Analyst?

Meesho seeks candidates with proven experience in enterprise systems analysis, particularly in supporting digital sales and marketing teams. They value expertise in eCommerce platforms, digital marketing analytics, and project management. Familiarity with manufacturing processes, strong communication skills, and experience with relevant software solutions like Salesforce and Adobe Experience platforms are highly desirable.

What types of projects will I work on as a Business Analyst at Meesho?

As a Business Analyst at Meesho, you will work on projects related to the integration, optimization, and effective utilization of enterprise systems to drive digital sales and marketing initiatives. You’ll collaborate with various departments to ensure technology solutions align with business objectives, and you’ll play a key role in process improvements and system performance monitoring.

What is the company culture like at Meesho?

Meesho fosters a collaborative and innovative culture. They emphasize diversity, teamwork, and continuous learning. The company values proactive problem-solving and encourages employees to engage in ongoing professional development.

Conclusion

As the digital landscape continues to evolve, Meesho remains steadfast in its quest for top-tier Business Analysts to drive their digital sales and marketing endeavors. With a focus on both technical prowess and team alignment, Meesho offers a collaborative and dynamic environment where you can truly unleash your potential.

If you want more insights about the company, check out our main Meesho Interview Guide, where we have covered many interview questions that could be asked. Additionally, explore our interview guides for other roles such as data engineer and data scientist to learn more about Meesho’s interview process for different positions.

Good luck with your interview!