PolicyBazaar Data Analyst Interview Questions and Answers

Q1. Pivot Table Based questions for a Sales data set
Add your answer

Basic Apititude Questions

Q1. Difference between WHERE and HAVING??
Ans. 
WHERE is used to filter rows before grouping, HAVING is used to filter groups after grouping.
• WHERE is used with SELECT statement to filter rows based on a condition

• HAVING is used with GROUP BY statement to filter groups based on a condition

• WHERE is applied before data is grouped, HAVING is applied after data is grouped

• Example: SELECT * FROM table WHERE column = 'value'

• Example: SELECT column, COUNT(*) FROM table GROUP B
Answered by AI
Add your answer
Q2. Where- Row Level Filters Having-Aggregate Filters
Ans. 
Row level filters are applied before aggregations, while aggregate filters are applied after aggregations.
• Row level filters are used to filter individual rows of data before any aggregations are performed.

• Aggregate filters are used to filter the aggregated results after the data has been grouped and summarized.

• Row level filters are typically applied using WHERE clause in SQL, while aggregate filters are applied using H...read more
Answered by AI
Add your answer

Q1. Why do you wanna join Uber?
Add your answer
Q2. Best Company Ever
Add your answer

Q1. Projects Worked
Ans. 
I have worked on various projects involving data analysis, visualization, and interpretation.
• Developed predictive models using machine learning algorithms

• Performed data cleaning and preprocessing to ensure accuracy

• Created interactive dashboards for stakeholders to easily understand insights
Answered by AI
Add your answer
Q2. SQL functions used in the projects
Ans. 
Common SQL functions used in projects include COUNT, SUM, AVG, MAX, MIN, and GROUP BY.
• COUNT: Used to count the number of rows in a table.

• SUM: Used to calculate the sum of a column.

• AVG: Used to calculate the average value of a column.

• MAX: Used to find the maximum value in a column.

• MIN: Used to find the minimum value in a column.

• GROUP BY: Used to group rows that have the same values into summary rows.
Answered by AI
Add your answer
Q3. Machine learning alogriths
Add your answer

Q1. Tell me about yourself
Add your answer

Q1. Difference between treemap and heat map in tableau
Ans. 
Treemaps display hierarchical data using nested rectangles, while heat maps show data values using color intensity.
• Treemaps visually represent hierarchical data with nested rectangles of varying sizes, where the size of each rectangle represents a quantitative value.

• Heat maps use color intensity to represent data values, with darker colors indicating higher values and lighter colors indicating lower values.

• Treemaps are...read more
Answered by AI
Add your answer

Basic questions based on Sql

Aptitude test is a way for employers to assess a candidate's abilities through a variety of different testing formats. Aptitude tests will test your ability to perform tasks and react to situations at work. This includes: problem-solving.

Q1. Tell me something about yourself. How did you hear about this position? Why do you want to work here?
Ans. Hi thank you for giving me this opportunity to introduce my self lakshmi r am basically from doddballapur i graduate in b. Com from banglore north university
Answered Anonymously
View 1 more answer
Q2. What is your greatest strength? What are your strengths and weaknesses? What do you know about this company/organization?
Add your answer

Some coding question about optimization algorthim