Add office photos
Meesho logo
Engaged Employer

Meesho

Verified
3.7
based on 1.7k Reviews
Video summary
Filter interviews by
Business Analyst
Skills
Clear (1)

10+ Meesho Business Analyst Interview Questions and Answers

Updated 21 Nov 2024

Q1. Describe different types of joins

Ans.

Different types of joins are used in database queries to combine data from multiple tables.

  • Inner join: Returns only the matching records from both tables.

  • Left join: Returns all records from the left table and the matching records from the right table.

  • Right join: Returns all records from the right table and the matching records from the left table.

  • Full outer join: Returns all records when there is a match in either the left or right table.

  • Cross join: Returns the Cartesian prod...read more

View 3 more answers
right arrow

Q2. Number of returns have increased, find possible reasons for it.

Ans.

Possible reasons for increased returns need to be analyzed.

  • Changes in customer preferences or expectations

  • Quality issues with products or services

  • Inadequate customer support or communication

  • Competitor actions affecting customer loyalty

  • Economic factors impacting purchasing decisions

Add your answer
right arrow

Q3. what is the Output in rows if two tables joined using various joins

Ans.

The output in rows when two tables are joined using various joins depends on the type of join used and the data in the tables.

  • Inner join - only rows with matching values in both tables are included in the output

  • Left join - all rows from the left table are included, with matching rows from the right table

  • Right join - all rows from the right table are included, with matching rows from the left table

  • Full outer join - all rows from both tables are included, with NULL values for n...read more

Add your answer
right arrow

Q4. what are the strength and weaknesses

Ans.

Strengths include analytical skills, problem-solving abilities, and communication skills. Weaknesses may include lack of technical expertise or industry knowledge.

  • Strengths: analytical skills, problem-solving abilities, communication skills

  • Weaknesses: lack of technical expertise, lack of industry knowledge

Add your answer
right arrow
Discover Meesho interview dos and don'ts from real experiences

Q5. Measure amount of time spent by each employee inside the office

Ans.

Employee time tracking system can be used to measure time spent in the office.

  • Implement an employee time tracking system to record entry and exit times

  • Use access card swipes or biometric systems for accurate tracking

  • Generate reports to analyze time spent by each employee

  • Consider implementing software solutions like time tracking apps for remote employees

Add your answer
right arrow

Q6. What is the output after joining two tables.

Ans.

The output after joining two tables is a single table containing columns from both tables based on a common key.

  • Joining two tables combines rows from both tables based on a common key

  • The output will have columns from both tables

  • Different types of joins like inner join, outer join, left join, right join can be used

Add your answer
right arrow
Are these interview questions helpful?

Q7. What is the diff between union and union all

Ans.

UNION combines the results of two or more SELECT statements, while UNION ALL includes all rows, including duplicates.

  • UNION removes duplicate rows, while UNION ALL does not

  • UNION sorts the result set, while UNION ALL does not

  • UNION is slower than UNION ALL as it performs a sort operation

Add your answer
right arrow

Q8. Strategy for marketing for new product launch

Ans.

Utilize a mix of digital and traditional marketing strategies to create buzz and reach target audience effectively.

  • Conduct market research to understand target audience and competition

  • Develop a comprehensive marketing plan including online advertising, social media campaigns, PR efforts, and events

  • Utilize influencers and brand ambassadors to generate excitement and credibility

  • Offer exclusive promotions or discounts to early adopters

  • Track and analyze results to make adjustment...read more

Add your answer
right arrow
Share interview questions and help millions of jobseekers 🌟
man with laptop

Q9. SQL query to print gold members of zomato

Ans.

SQL query to print gold members of zomato

  • Use SELECT statement to retrieve data from the database

  • Filter the results using WHERE clause to only include gold members

  • Specify the table and column names where the membership status is stored

  • Example: SELECT * FROM zomato_members WHERE membership_type = 'gold'

Add your answer
right arrow

Q10. Find order of execution

Ans.

The order of execution refers to the sequence in which tasks or processes are carried out.

  • Identify the tasks or processes that need to be executed

  • Determine the dependencies between tasks

  • Execute tasks in the correct order based on dependencies

  • Ensure that tasks are completed before moving on to the next task

Add your answer
right arrow

Q11. Match-fixing of four teams

Ans.

Match-fixing involving four teams is a serious issue in sports that undermines the integrity of the game.

  • Match-fixing can involve players, coaches, referees, or even team officials conspiring to manipulate the outcome of a game for financial gain.

  • It can have severe consequences such as bans, fines, and tarnished reputations for those involved.

  • Examples of match-fixing scandals involving four teams include the Calciopoli scandal in Italian football and the Black Sox scandal in ...read more

Add your answer
right arrow

Q12. output of joins

Ans.

Output of joins is a combination of data from two or more tables based on a common column.

  • Joins are used to combine rows from two or more tables based on a related column between them

  • Types of joins include inner join, outer join, left join, and right join

  • The output of a join will include columns from both tables, with rows that meet the join condition

Add your answer
right arrow
Contribute & help others!
Write a review
Write a review
Share interview
Share interview
Contribute salary
Contribute salary
Add office photos
Add office photos

Interview Process at Meesho Business Analyst

based on 42 interviews
3 Interview rounds
Coding Test Round
Technical Round - 1
Technical Round - 2
View more
interview tips and stories logo
Interview Tips & Stories
Ace your next interview with expert advice and inspiring stories

Top Business Analyst Interview Questions from Similar Companies

Wipro Logo
3.7
 • 19 Interview Questions
Swiggy Logo
3.8
 • 15 Interview Questions
Cognizant Logo
3.7
 • 12 Interview Questions
HCLTech Logo
3.5
 • 10 Interview Questions
Turing Logo
3.4
 • 10 Interview Questions
View all
Recently Viewed
CAMPUS PLACEMENT
Xplora Design Skool, Ahmedabad
LIST OF COMPANIES
Automotive Manufacturers
Locations
INTERVIEWS
American Express
No Interviews
INTERVIEWS
Automotive Manufacturers
No Interviews
CAMPUS PLACEMENT
Kamaraj College, Thoothukudi
INTERVIEWS
Tata Steel
No Interviews
INTERVIEWS
Tata Elxsi
No Interviews
SALARIES
Platform3 Solutions
SALARIES
Movidu Technology
SALARIES
Movidu Technology
Share an Interview
Stay ahead in your career. Get AmbitionBox app
play-icon
play-icon
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
75 Lakh+

Reviews

5 Lakh+

Interviews

4 Crore+

Salaries

1 Cr+

Users/Month

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter