i
PolicyBazaar
Compare
Filter interviews by
PolicyBazaar Business Analyst Interview Questions and Answers
PolicyBazaar Business Analyst Interview Experiences
6 interviews found
Anonymous
I applied via LinkedIn and was interviewed in Sep 2024. There was 1 interview round.
(2 Questions)
- Q1. Joins and their output
- Ans.
Joins are used in SQL to combine rows from two or more tables based on a related column between them.
Joins are used to retrieve data from multiple tables based on a related column
Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
INNER JOIN returns rows when there is at least one match in both tables
LEFT JOIN returns all rows from the left table and the matched rows from the right table
RIGHT JOIN re...
- Q2. Employees who earn more than their manager
Skills evaluated in this interview
(2 Questions)
- Q1. Sumifs Functions
- Q2. Vlookup Function
Interview Preparation Tips
Advance Excel -
Sumifs formula may be they will ask a commission payout question in which you have to find the commission payout value then in Sheet 1 you have the master data, sheet 2 you have Commission percentage in sheet 3 you have to do work
Then use the sumifs formula for just reference i am writing the formula here
=sumifs for the total & join the formula with vlookup for % calculation
in SQL they might ask the questions
-DDL & DML
-Group query etc.
(2 Questions)
- Q1. Basic Sql questions
- Q2. Basic python questions
I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.
(2 Questions)
- Q1. What analysis you have done in your previous organization
- Q2. Find third manager for an employee on sql
- Ans.
Use SQL query to find the third manager for an employee
Join the employee table with the manager table on the manager_id
Use a subquery to count the number of managers for the employee
Filter the results to only include the third manager
Skills evaluated in this interview
PolicyBazaar interview questions for designations
I applied via Approached by Company and was interviewed in Mar 2024. There were 2 interview rounds.
Question regarding convergence rate
(2 Questions)
- Q1. Sql triggers code
- Q2. Vlookup, hlookup, match and indexing
I applied via Referral and was interviewed in Aug 2023. There were 3 interview rounds.
(2 Questions)
- Q1. Details about yourself
- Q2. Personal information
They asked question from sql from join group by and from excel they asked about xlookup, vlookup, sumif,countif etc
Interview Preparation Tips
- SQL
- Advanced Excel
- guestimate
- communication
Top trending discussions
Interview questions from similar companies
Rahul Kiroriwal
Basis CAT like aptitude with 2 simple python coding question
(1 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...
I was interviewed in Oct 2023.
Python, SQL, Quant, Statistics, Numpy
(2 Questions)
- Q1. SQL, Python, Puzzle total 9Q
- Q2. Table, Query, 2 puzzle, Python 1 code (4 Sub code)
(1 Question)
- Q1. Yet to declare result for the round 2 i feel +ve for round 2 result lets se
MCQ Mostly - Aptitude and Time Distance
RCA - Drop in Metrics
(1 Question)
- Q1. SQL & Pythonassad
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Jan 2023. There was 1 interview round.
(2 Questions)
- Q1. What is your opinion about business?
- Ans.
Business is the backbone of the economy, driving innovation, growth, and prosperity.
Business plays a crucial role in creating jobs and generating income for individuals and communities.
It fosters competition, which leads to improved products and services for consumers.
Businesses contribute to economic development by investing in infrastructure and technology.
They provide opportunities for entrepreneurship and innovatio...
- Q2. Why business is important
- Ans.
Business is important because it drives economic growth, creates jobs, and fosters innovation.
Business drives economic growth by producing goods and services that meet the needs and wants of consumers.
Businesses create jobs by hiring employees and providing them with income and opportunities for career growth.
Businesses foster innovation by investing in research and development, driving technological advancements.
Busin...
Interview Preparation Tips
PolicyBazaar Interview FAQs
Tell us how to improve this page.
PolicyBazaar Interviews By Designations
- PolicyBazaar Sales Executive Interview Questions
- PolicyBazaar Associate Sales Consultant Interview Questions
- PolicyBazaar Relationship Manager Interview Questions
- PolicyBazaar Sales Associate Interview Questions
- PolicyBazaar Sales Consultant Interview Questions
- PolicyBazaar Associate Service Consultant Interview Questions
- PolicyBazaar Business Analyst Interview Questions
- PolicyBazaar Customer Service Associate Interview Questions
- Show more
PolicyBazaar Business Analyst Interview Process
based on 7 interviews
1 Interview rounds
- Technical Round
Business Analyst Interview Questions from Similar Companies
Fast track your campus placements
PolicyBazaar Business Analyst Reviews and Ratings
based on 6 reviews
Rating in categories
|
Sales Executive
1.2k
salaries
|  ₹1.8 L/yr - ₹5.5 L/yr |
|
Associate Sales Consultant
1.2k
salaries
| ₹1.5 L/yr - ₹5.5 L/yr |
|
Relationship Manager
593
salaries
| ₹1.6 L/yr - ₹6 L/yr |
|
Team Lead
381
salaries
| ₹3.1 L/yr - ₹12.2 L/yr |
|
Sales Associate
355
salaries
| ₹1.8 L/yr - ₹4.8 L/yr |
Coverfox
BankBazaar
Paytm Money
Easypolicy.com
- Home >
- Interviews >
- PolicyBazaar Interview Questions >
- PolicyBazaar Business Analyst Interview Questions
