OLX Business Analyst Interview Questions and Answers

There is one OA after your interview shortlisted based on your domain or profile.

Q1. 2 technical interview will be there both are elimination round.interview related to your field.
Add your answer

Q1. Before HR there is team round for which you are going to be hired after that there is final HR round.
Add your answer

Q1. Explain group by clause with used cases
Ans. 
Group by clause is used to group data based on a specific column in a table.
• Used with aggregate functions like SUM, COUNT, AVG, etc.

• Helps in analyzing data by grouping it based on a common attribute.

• Can be used with multiple columns to create nested groups.

• Example: GROUP BY department in a table of employees to get the total salary for each department.
Answered by AI
Add your answer
Q2. CountA,CountB,Countif used case in Google sheet
Ans. 
CountA, CountB, Countif are functions used in Google Sheets to count cells based on certain criteria.
• CountA counts the number of cells in a range that are not empty.

• CountB counts the number of cells in a range that are not blank.

• Countif counts the number of cells in a range that meet a certain condition.

• Countif can be used with operators like >, <, =, and functions like AND, OR.

• Countif can also be used with wildcards l
Answered by AI
Add your answer

Q1. Where have stayed...why want to switch...what will be your priority ..job or family
View 3 more answers

Q1. What are your salary expectations?
Add your answer
Q2. Share details of your previous job.
Add your answer
Q3. Why are you looking for a change?
Add your answer
Q4. Tell me about yourself.
Add your answer

Q1. Sql, tableau, excel relates questions asked, it difficult but i focused on basics
Add your answer

Q1. Share details of your previous job.
Add your answer
Q2. What is your family background?
Add your answer
Q3. What are your salary expectations?
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

Simple python related and sql based question

Q1. How to incentivise regular customer
Ans. 
Regular customers can be incentivized through loyalty programs, personalized discounts, exclusive offers, and rewards points.
• Implement a loyalty program where customers earn points for each purchase, which can be redeemed for discounts or free items.

• Offer personalized discounts based on the customer's purchase history or preferences.

• Provide exclusive offers or early access to new products/services for regular customers...read more
Answered by AI
Add your answer
Q2. Why discounting is way to incentivise inactive customer
Ans. 
Discounting is a way to incentivize inactive customers by offering them reduced prices or special deals to encourage them to make a purchase.
• Discounting can help attract the attention of inactive customers who may have lost interest in the product or service.

• It can create a sense of urgency and motivate customers to take action before the discount expires.

• Discounting can also help clear out excess inventory or generate...read more
Answered by AI
Add your answer