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
In a behavioral interview, candidates showcase their skills through past experiences and actions in various situations.
Use the STAR method (Situation, Task, Action, Result) to structure your answers.
Example: Describe a time when you improved a process at work.
Highlight teamwork by discussing a project where collaboration was key.
Mention a challenge you faced and how you overcame it, focusing on your analytical ski...
SQL basics involve understanding database queries, data manipulation, and retrieval using structured query language.
SQL stands for Structured Query Language, used for managing and manipulating databases.
Common SQL commands include SELECT, INSERT, UPDATE, DELETE.
Example of SELECT: SELECT * FROM employees; retrieves all records from the employees table.
JOIN operations allow combining rows from two or more tables bas...
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
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, IN...
SQL query to retrieve specific data from a database table based on given conditions.
Use SELECT statement to specify the columns you want to retrieve.
Use FROM clause to indicate the table from which to fetch data.
Utilize WHERE clause to filter records based on specific conditions.
Example: SELECT name, age FROM users WHERE age > 18;
Consider using JOINs to combine data from multiple tables if necessary.
What are the roles & responsibilities of a Business Analyst at Meesho?
Read full roles & responsibilities 
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.
Meesho HR Interview Questions
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 salarie...
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'
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
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
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
226
salaries
| ₹12 L/yr - ₹21 L/yr |
|
Team Lead
177
salaries
| ₹3.5 L/yr - ₹8 L/yr |
|
Area Manager
176
salaries
| ₹3.6 L/yr - ₹7.3 L/yr |
Amazon
Flipkart
Myntra
GlowRoad
- Home >
- Interviews >
- Meesho Interview Questions
