PolicyBazaar Business Analyst Interview Questions and Answers

Q1. Question around pivot table, lookups, aggregate function
Add your answer
Q2. Asked to write nested query based on order by and max clause.
Ans. 
A nested query using ORDER BY and MAX retrieves the highest value while sorting results based on specific criteria.
• A nested query allows you to use the result of one query as input for another.

• Example: SELECT * FROM Orders WHERE OrderID = (SELECT MAX(OrderID) FROM Orders);

• The outer query retrieves all details of the order with the maximum OrderID.

• You can also use ORDER BY in the outer query to sort results based on oth...read more
Answered by AI
Add your answer
Q3. Question on windows function
Add your answer

Question regarding convergence rate

Q1. Sql triggers code
Add your answer
Q2. Vlookup, hlookup, match and indexing
Add your answer

Q1. Details about yourself
Add your answer
Q2. Personal information
Add your answer

They asked question from sql from join group by and from excel they asked about xlookup, vlookup, sumif,countif etc