AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
i
PolicyBazaar
Compare
Filter interviews by
Clear (1)
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
I applied via Company Website and was interviewed in May 2019. There were 5 interview rounds.
Interview Questionnaire
1 Question
- Q1. SQL, Business cases
Interview Preparation Tips
I applied via Referral and was interviewed before Apr 2021. There were 3 interview rounds.
(3 Questions)
- Q1. Why are you looking for a change?
- Q2. Tell me about yourself.
- Q3. Why should we hire you?
Basic sql
(1 Question)
- Q1. Project manager round
Interview Preparation Tips
Business Analyst Interview Questions & Answers
Square Yards
Siddhartha Upadhyay
posted on 13 Nov 2024
(1 Question)
- Q1. Tell me about yourself
I applied via Company Website and was interviewed before Oct 2021. There were 4 interview rounds.
There is one OA after your interview shortlisted based on your domain or profile.
(1 Question)
- Q1. 2 technical interview will be there both are elimination round.interview related to your field.
(1 Question)
- Q1. Before HR there is team round for which you are going to be hired after that there is final HR round.
Interview Preparation Tips
PolicyBazaar Interview FAQs
Recently Viewed
INTERVIEWS
PolicyBazaar
No Interviews
INTERVIEWS
Saint-Gobain
No Interviews
INTERVIEWS
PolicyBazaar
No Interviews
COMPANY BENEFITS
Business Octane Solutions
No Benefits
SALARIES
Business Octane Solutions
No Salaries
LIST OF COMPANIES
Business Octane Solutions
Overview
INTERVIEWS
Bharat Petroleum
No Interviews
LIST OF COMPANIES
Bharat Petroleum
Locations
INTERVIEWS
Bharat Petroleum
No Interviews
SALARIES
Alstom Transportation
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 Customer Service Associate Interview Questions
- PolicyBazaar Business Analyst Interview Questions
- PolicyBazaar Associate Service Consultant 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
|  ₹0 L/yr - ₹0 L/yr |
|
Associate Sales Consultant
1.1k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Relationship Manager
608
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Sales Associate
381
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Team Lead
380
salaries
| ₹0 L/yr - ₹0 L/yr |
Coverfox
BankBazaar
Paytm Money
Easypolicy.com
- Home >
- Interviews >
- PolicyBazaar Interview Questions >
- PolicyBazaar Business Analyst Interview Questions
