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 Intelligence Analyst Interview Questions and Answers
Meesho Business Intelligence Analyst Interview Experiences
1 interview found
Anonymous
Selected
I applied via Recruitment Consulltant and was interviewed before Aug 2023. There were 3 interview rounds.
Set of SQL questions using Joins , Create an sql query for user cohort analysis
(2 Questions)
- Q1. Difference between having and where
- Ans.
The difference between having and where in SQL queries
HAVING is used with GROUP BY to filter grouped rows based on a specified condition
WHERE is used to filter rows before any grouping is done
HAVING is used with aggregate functions like SUM, COUNT, AVG, etc.
WHERE is used with individual columns for filtering
- Q2. SQL query using joins
- Ans.
SQL query using joins to combine data from multiple tables
Use INNER JOIN to combine rows from two or more tables based on a related column between them
Specify the columns to select from each table in the SELECT statement
Use ON clause to specify the join condition
(2 Questions)
- Q1. How would you go about understanding competitors
- Ans.
To understand competitors, I would conduct market research, analyze their products/services, pricing strategies, marketing tactics, and customer feedback.
Conduct market research to identify key competitors in the industry
Analyze competitors' products/services, pricing strategies, and target market
Monitor competitors' marketing tactics and promotional activities
Gather customer feedback and reviews to understand competit
- Q2. Guesstimates on how many air planes fly in Bangalore airport in a day
- Ans.
It is estimated that around 400-500 airplanes fly in and out of Bangalore airport daily.
Consider the number of flights scheduled for the day
Take into account the number of domestic and international flights
Factor in the average number of flights per hour
Look at the airport's capacity and traffic volume
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
I applied via Referral and was interviewed before May 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. How can you understand the supply of restaurant in a particular area of a city ?
- Ans.
To understand the supply of restaurants in a particular area of a city, we can use various methods.
Collect data from online directories like Yelp, Zomato, etc.
Conduct surveys to gather information about the number of restaurants in the area.
Analyze the population density and demographics of the area to estimate the demand for restaurants.
Check the number of restaurant permits issued by the local government.
Use GIS mapp...
Interview Preparation Tips
I applied via LinkedIn and was interviewed before May 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Questions were from SQL, Python, Statistics & Business Case Studies/Metrics in the form of 4-5 rounds.
Interview Preparation Tips
I appeared for an interview in Nov 2020.
Interview Questionnaire
1 Question
- Q1. Mainly about sql, previous job role
govind goel
I applied via Internshala and was interviewed in Sep 2023. There were 3 interview rounds.
Medium difficultty on pandas SQL
(1 Question)
- Q1. Coding interview python pandas medium difficulty
- Ans. Solved it and had to discuss with manager
Interview Preparation Tips
- Python
I applied via Campus Placement and was interviewed in Nov 2024. There were 4 interview rounds.
Questions from arrays and strings and some aptitude questions
(2 Questions)
- Q1. How to merge 2 csv files
- Ans.
To merge two CSV files, you can use software like Microsoft Excel or programming languages like Python.
Open both CSV files in a software like Microsoft Excel.
Copy the data from one CSV file and paste it into the other CSV file.
Save the merged CSV file with a new name.
Alternatively, you can use programming languages like Python to merge CSV files by reading both files, combining the data, and writing to a new file.
- Q2. Basic questions on arrays
(1 Question)
- Q1. 3 reasons why u choose this company
- Ans.
I applied to this company because of its reputation in the industry, opportunities for growth, and company culture.
Reputation in the industry - I have heard great things about the company's innovative projects and successful track record.
Opportunities for growth - The company offers various training programs and career advancement opportunities for employees.
Company culture - I value a positive work environment and the...
(1 Question)
- Q1. Questions on python
Skills evaluated in this interview
Selected
I applied via Naukri.com and was interviewed in Mar 2024. There were 2 interview rounds.
(1 Question)
- Q1. More about your role and insurance based questions
(1 Question)
- Q1. More about insurance based and brd, requirements gathering, sdlc
I applied via Recruitment Consulltant and was interviewed in Jan 2024. There was 1 interview round.
(2 Questions)
- Q1. Explain about your work as BA in the insurance project
- Ans.
As a BA in the insurance project, I analyzed business requirements, facilitated communication between stakeholders, and ensured project goals were met.
Analyzed business requirements to identify gaps and opportunities for improvement
Facilitated communication between stakeholders including business users, IT teams, and management
Ensured project goals were met by tracking progress, identifying risks, and proposing solutio...
- Q2. Agile methodologies, SQL knowledge , Insurance domain knowledge
Interview Preparation Tips
I applied via LinkedIn and was interviewed in Sep 2022. There were 4 interview rounds.
(2 Questions)
- Q1. The hr scheduled a call with the analytics manager ,who asked about my experience and general details ,some background about projects and previous work ,why this job etc .30-40 minutes conversation.
- Q2. Just a casual brief conversation
(2 Questions)
- Q1. Second round was with a senior analyst ,who asked 5-6 sql related questions , problems to solve etc ,tables to create ,joins ,window functions etc basic sql
- Q2. Very friendly interviewer , you are allowed to google the syntax
(1 Question)
- Q1. Another round with the analytics head , case study ,problem solving ,logical reasoning etc.
Interview Preparation Tips
Basic stats and mental math
I applied via LinkedIn and was interviewed in May 2023. There were 3 interview rounds.
4 challenges on coderbyte
(1 Question)
- Q1. Joins, windowed function and basic sql queries
Meesho Interview FAQs
Tell us how to improve this page.
Meesho Interviews By Designations
- Meesho Business Analyst Interview Questions
- Meesho Key Account Manager Interview Questions
- Meesho Software Developer Interview Questions
- Meesho Data Analyst Interview Questions
- Meesho Product Manager Interview Questions
- Meesho Sales Officer Interview Questions
- Meesho Team Lead Interview Questions
- Meesho Software Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
- Business Intelligence Developer Interview Questions
- Business Intelligence Consultant Interview Questions
- Senior Business Intelligence Analyst Interview Questions
- Manager - Business Intelligence Interview Questions
- Artificial Intelligence Intern Interview Questions
- Artificial Intelligence Developer Interview Questions
- Data Scientist Interview Questions
- Lead - Business Intelligence Interview Questions
- Show more
Meesho Business Intelligence Analyst Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
|
Key Account Manager
756
salaries
|  ₹2.8 L/yr - ₹6.9 L/yr |
|
City Manager
205
salaries
| ₹4 L/yr - ₹10 L/yr |
|
Business Analyst
194
salaries
| ₹8 L/yr - ₹22.8 L/yr |
|
Business Development Manager
169
salaries
| ₹3.5 L/yr - ₹7.5 L/yr |
|
Team Lead
164
salaries
| ₹1.6 L/yr - ₹9 L/yr |
Amazon
Flipkart
Myntra
GlowRoad
- Home >
- Interviews >
- Meesho Interview Questions >
- Meesho Business Intelligence Analyst Interview Questions
