Meesho Business Analyst Interview Questions, Process, and Tips

Hackerank test based on sql with one hard question

Q1. Questions of window functions
Add your answer
Q2. Question about rank
Add your answer
Q3. Question about joins
Add your answer
Q4. Question about coding sql functions
Add your answer

Sql questions and excel questions

Q1. Sql question was asked to find the nth value
Add your answer
Q2. Sql question based on rank and dense rank
Add your answer

Q1. Why is meesho suitable for u
Ans. 
Meesho is suitable for me because of its innovative business model, growth opportunities, and positive work culture.
• Innovative business model allows for flexible work hours and remote work options.

• Opportunities for growth and advancement within the company.

• Positive work culture that values employee well-being and encourages collaboration.

• Meesho's focus on empowering women entrepreneurs aligns with my values and interes
Answered by AI
Add your answer
Q2. 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
Answered by AI
Add your answer

Q1. Find no of employees inside the office at current time?
Ans. 
To find the number of employees inside the office at the current time.
• Check the attendance records or sign-in logs

• Count the number of occupied desks or workstations

• Use access control data to track entries and exits

• Ask the receptionist or security personnel for a headcount
Answered by AI
Add your answer
Q2. 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
Answered by AI
Add your answer

Find the root cause for 20% decline in users browsing Meesho within a week

Q1. 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
Answered by AI
Add your answer
Q2. Rank dense rank cte
Add your answer