AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Meesho
Compare
Filter interviews by
Meesho Business Analyst Interview Questions and Answers
22 Interview questions
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
Union combines unique records from two queries, while Union All includes all records, including duplicates.
Union removes duplicate records from the result set.
Union All retains all records, including duplicates.
Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2 returns unique values.
Example: SELECT column1 FROM table1 UNION ALL SELECT column1 FROM table2 returns all values, including duplicates.
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
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.
SQL query to retrieve the nth value from a dataset using various techniques.
Use the ROW_NUMBER() function to assign a unique sequential integer to rows.
Example: SELECT value FROM (SELECT value, ROW_NUMBER() OVER (ORDER BY column_name) AS rn FROM table_name) AS temp WHERE rn = n;
Alternatively, use LIMIT and OFFSET for databases like MySQL: SELECT value FROM table_name ORDER BY column_name LIMIT 1 OFFSET n-1;
In Post...
What are the roles & responsibilities of a Business Analyst at Meesho?
Read full roles & responsibilities 
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
Meesho HR Interview Questions
Hypothesis testing is a statistical method to determine if there's enough evidence to support a specific claim about a population.
Null Hypothesis (H0): Assumes no effect or no difference (e.g., a new drug has no effect compared to a placebo).
Alternative Hypothesis (H1): Indicates the presence of an effect or difference (e.g., the new drug is more effective than the placebo).
Significance Level (α): The probability ...
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 -...
Understanding join types helps determine the number of rows in SQL queries based on table relationships.
INNER JOIN: Returns rows with matching values in both tables. Example: 5 rows if both tables have 5 matching records.
LEFT JOIN: Returns all rows from the left table and matched rows from the right. Example: 7 rows if left has 7 and right has 3 matches.
RIGHT JOIN: Returns all rows from the right table and matched...
Understanding row calculations in SQL joins is crucial for accurate data analysis.
Inner Join: Returns rows with matching values in both tables. Example: Customers and Orders where customer_id matches.
Left Join: Returns all rows from the left table and matched rows from the right. Example: All Customers and their Orders, if any.
Right Join: Returns all rows from the right table and matched rows from the left. Exampl...
Meesho Business Analyst Interview Experiences
43 interviews found
Anonymous
I applied via Campus Placement and was interviewed in Oct 2024. There were 3 interview rounds.
It was based on 4 sql questions of medium to hard level and 24 mcqs based on sql,aptitude,excel.
(1 Question)
- Q1. They give you some questions and you have to write sql queries for them
- Ans.
SQL queries are essential for extracting and manipulating data in databases, crucial for business analysis.
Understand the database schema before writing queries.
Use SELECT statements to retrieve data, e.g., SELECT * FROM employees;
Utilize WHERE clauses to filter results, e.g., SELECT * FROM sales WHERE amount > 1000;
Join tables to combine related data, e.g., SELECT a.name, b.salary FROM employees a JOIN salaries b O...
(1 Question)
- Q1. You are given case study and come sql questions based on that
- Ans.
SQL questions based on a case study assess analytical skills and data handling capabilities.
Understand the case study context and objectives.
Identify key data entities and relationships.
Formulate SQL queries to extract relevant insights.
Example: Use JOINs to combine data from multiple tables.
Consider performance optimization for complex queries.
I applied via Referral and was interviewed in Oct 2024. There were 3 interview rounds.
45 minutes coding test
(1 Question)
- Q1. 2 nd round was technical.
(1 Question)
- Q1. Third round was technical
SQL and aptitude were asked in this round
(2 Questions)
- Q1. Basics of SQL Concepts
- Q2. Basics of DBMS Concepts
(2 Questions)
- Q1. Regarding the projects in Resume
- Q2. About SQL Window Functions
Interview Preparation Tips
I applied via Campus Placement and was interviewed in Aug 2024. There were 3 interview rounds.
30 question on hacker rank in which 4 questions were related to sql and rest were basic aptitude questions.
(2 Questions)
- Q1. 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
- Q2. What is the output after joining two tables.
(2 Questions)
- Q1. More about resume based questions
- Q2. Asked some puzzle questions
Interview Preparation Tips
Skills evaluated in this interview
I applied via Campus Placement and was interviewed in Jul 2024. There were 2 interview rounds.
Hackerank test based on sql with one hard question
(4 Questions)
- Q1. Questions of window functions
- Q2. Question about rank
- Q3. Question about joins
- Q4. Question about coding sql functions
I applied via Referral and was interviewed in Aug 2024. There was 1 interview round.
(2 Questions)
- Q1. Mostly Advance SQL question on some random cases
- Q2. Some advance SQL theory questions
Interview Preparation Tips
my experience was not good.
Selected
I applied via Campus Placement and was interviewed in Jul 2024. There were 3 interview rounds.
Sql questions and excel questions
(2 Questions)
- Q1. Sql question was asked to find the nth value
- 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.
(2 Questions)
- Q1. Why is meesho suitable for u
- Q2. What are the strength and weaknesses
Interview Preparation Tips
- sql
- Excel
I applied via Campus Placement
Online assessment - Sql basic syntax related questions + SQL queries for 4 problems + some aptitude ques
(2 Questions)
- Q1. Window function related question asked
- Q2. Then some basic questions like difference between union and union all
Interview Preparation Tips
I applied via Campus Placement and was interviewed in Jul 2024. There were 2 interview rounds.
(2 Questions)
- 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
- 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
Find the root cause for 20% decline in users browsing Meesho within a week
Shweta Chauhan
I applied via Approached by Company and was interviewed in Oct 2024. There was 1 interview round.
(2 Questions)
- 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
- 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,...
Skills evaluated in this interview
Top trending discussions
Meesho Interview FAQs
The duration of Meesho Business Analyst interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
Meesho Interviews By Designations
- Meesho Business Analyst Interview Questions
- Meesho Key Account Manager Interview Questions
- Meesho Data Analyst Interview Questions
- Meesho Software Developer Interview Questions
- Meesho Sales Officer Interview Questions
- Meesho Product Manager Interview Questions
- Meesho Team Lead Interview Questions
- Meesho Senior Business Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
Overall Interview Experience Rating
based on 42 interview experiences
Difficulty level
Duration
Interview Questions from Similar Companies
Meesho Business Analyst Reviews and Ratings
based on 33 reviews
Rating in categories
|
Key Account Manager
798
salaries
|  ₹3 L/yr - ₹7 L/yr |
|
City Manager
237
salaries
| ₹4.9 L/yr - ₹10 L/yr |
|
Business Analyst
205
salaries
| ₹13 L/yr - ₹22.3 L/yr |
|
Area Manager
179
salaries
| ₹3.6 L/yr - ₹7.3 L/yr |
|
Team Lead
177
salaries
| ₹3.5 L/yr - ₹8 L/yr |
Amazon
Flipkart
Myntra
GlowRoad
- Home >
- Interviews >
- Meesho Interview Questions
