Indiamart Intermesh Business Analyst Interview Questions and Answers

The questions were related to Data Interpretation/Logical Reasoning and general aptitude.

Q1. Questions related to SQL queries, window functions, 2-3 sql queries had to write
Add your answer
Q2. Statistics related questions, left skewed, right skewed etc.
Add your answer
Q3. Questions related to basics of ML
Add your answer

A company wants to open a new store, what would the factors you would consider.
A ride sharing company wants dynamic pricing in place of flat pricing, what factors you would consider.

Q1. General Project and HR related questions.
Add your answer
Q2. Things you want to improve in swiggy and metrics to measure and evaluate them.
Add your answer

Q1. Tell me about a project you faced difficulties?
Add your answer
Q2. Given a table ..asked some SQL questions
Add your answer

Q1. Shared a table ...asked to write some SQL queries
Add your answer
Q2. Sman queries result how to derive in excel
Ans. 
Use Excel functions like VLOOKUP or INDEX/MATCH to derive results from SQL queries in Excel.
• Use VLOOKUP function to search for a value in a table and return a corresponding value from another column.

• Use INDEX/MATCH function to perform a two-way lookup by matching values in two different ranges.

• Import SQL query results into Excel using data connection or copy-paste method.
Answered by AI
Add your answer

Q1. Cohort Analysis in google analytics
Ans. 
Cohort analysis in Google Analytics helps track the behavior of specific groups of users over time.
• Cohort analysis groups users based on a common characteristic or behavior, such as sign-up date or acquisition channel.

• It helps in understanding user retention, engagement, and conversion rates for different cohorts.

• Example: Analyzing the retention rate of users who signed up in a particular month compared to users who si
Answered by AI
Add your answer
Q2. Types of join in sql and their differences
Ans. 
Types of joins in SQL include inner join, outer join, left join, right join, and full join.
• Inner join: returns rows when there is a match in both tables

• Outer join: returns all rows from both tables, filling in NULLs for missing matches

• Left join: returns all rows from the left table and the matched rows from the right table

• Right join: returns all rows from the right table and the matched rows from the left table

• Full joi...read more
Answered by AI
Add your answer

Q1. Sql Medium Level questions
Add your answer
Q2. Easy guesstimates were asked
Add your answer

Q1. Caee Study was asked
Add your answer
Q2. Resume grilling was done
Add your answer

Q1. Why you want to join Ola ?
Ans. 
I want to join Ola because of its innovative technology, market leadership, and potential for growth.
• Ola is a market leader in the ride-sharing industry, which presents exciting challenges and opportunities for a business analyst.

• I am impressed by Ola's focus on innovation and technology, which aligns with my passion for leveraging data and analytics to drive business decisions.

• I believe Ola's fast-paced environment an...read more
Answered by AI
Add your answer
Q2. Salary Negotiation was done
Add your answer

Basis CAT like aptitude with 2 simple python coding question

Q1. What Central limit theorem
Ans. 
The Central Limit Theorem states that the sampling distribution of the sample mean approaches a normal distribution as the sample size increases.
• States that the sampling distribution of the sample mean will be approximately normally distributed regardless of the shape of the population distribution

• Helps in making inferences about the population mean based on the sample mean

• Important concept in statistics and hypothesis...read more
Answered by AI
Add your answer

Python, SQL, Quant, Statistics, Numpy

Q1. SQL, Python, Puzzle total 9Q
Add your answer
Q2. Table, Query, 2 puzzle, Python 1 code (4 Sub code)
Add your answer

Q1. Yet to declare result for the round 2 i feel +ve for round 2 result lets se
Add your answer

Q1. Find 3rd highest salary using SQL
Ans. 
Use SQL query with ORDER BY and LIMIT to find 3rd highest salary.
• Use SELECT statement to retrieve salary column

• Use ORDER BY clause to sort salaries in descending order

• Use LIMIT 2,1 to skip first two highest salaries and retrieve the third highest salary
Answered by AI
Add your answer
Q2. Queries on self join
Add your answer

Q1. Questions on Power B, DAX etc.,
Add your answer