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 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
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
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
I applied via LinkedIn and was interviewed in Sep 2024. There was 1 interview round.
SQL queries - 3. Was asked to write on notepad using the table structure given by interviewer
Interview Preparation Tips
- Hackerrank
- Stratascratch
- Leetcode
(2 Questions)
- Q1. Tell me about a project you faced difficulties?
- Q2. Given a table ..asked some SQL questions
(2 Questions)
- Q1. Shared a table ...asked to write some SQL queries
- 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.
Interview Preparation Tips
Skills evaluated in this interview
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...
Selected
I applied via Referral and was interviewed in Feb 2024. There were 3 interview rounds.
(1 Question)
- Q1. SQL QUERY QUESTIONS ON JOINS
(1 Question)
- Q1. Excel basic formulas like lookup
(1 Question)
- Q1. About Yourself, resume grilling
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 Customer Service Associate Interview Questions
- PolicyBazaar Sales Consultant Interview Questions
- PolicyBazaar Associate Service Consultant Interview Questions
- PolicyBazaar Business Analyst 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
353
salaries
| ₹1.5 L/yr - ₹4.8 L/yr |
Coverfox
BankBazaar
Paytm Money
Easypolicy.com
- Home >
- Interviews >
- PolicyBazaar Interview Questions >
- PolicyBazaar Business Analyst Interview Questions
