Meesho Business Analyst Interview Questions and Answers

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

Q1. Mostly Advance SQL question on some random cases
Add your answer
Q2. Some advance SQL theory questions
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
Ans. 
Understanding SQL RANK and DENSE_RANK functions for data ranking.
• RANK() assigns a unique rank to each distinct row, with gaps for ties. Example: 1, 2, 2, 4.

• DENSE_RANK() also assigns ranks but without gaps for ties. Example: 1, 2, 2, 3.

• Use RANK() when you want to reflect the actual position with gaps in ranking.

• Use DENSE_RANK() when you want a continuous ranking without gaps.
Answered by AI
Add your answer

Q1. Why is meesho suitable for u
Add your answer
Q2. What are the strength and weaknesses
Add your answer

Online assessment - Sql basic syntax related questions + SQL queries for 4 problems + some aptitude ques

Q1. Window function related question asked
Add your answer
Q2. Then some basic questions like difference between union and union all
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
View 1 more answer
Q2. Rank dense rank cte
Ans. 
Rank, Dense Rank, and CTE are SQL functions for ordering and ranking data in queries.
• RANK() assigns a unique rank to each row within a partition, with gaps for ties. Example: RANK() OVER (ORDER BY score).

• DENSE_RANK() also ranks rows but does not leave gaps for ties. Example: DENSE_RANK() OVER (ORDER BY score).

• Common Table Expressions (CTEs) allow for temporary result sets that can be referenced within a SELECT, INSERT,...read more
Answered by AI
Add your answer