Meesho Business Analyst Interview Questions, Process, and Tips

Two debugging, 1 Joins related questions

Q1. 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 ...read more
Answered by AI
Add your answer
Q2. 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...read more
Answered by AI
Add your answer

Test was consisting of aptitude question, SQL query question(total 4- two of them were easy, other 2 were medium level)

Q1. There were two tables given and interviewer ask to run different different queries on those table itself
Add your answer

Sql round test, contains 1 query and 2 mcq

Q1. Sql basics interview round
Add your answer

1 hour test, consisting of SQL coding questions. 1 coding question and 2 debugging questions.

Q1. SQL questions, Joins, question of self join
Add your answer
Q2. Questions using lag and lead
Add your answer
Q3. Question using rolling average,rolling sum
Add your answer

Q1. Root Cause Analysis, problem solving
Add your answer
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
Answered by AI
Add your answer