Saras Analytics Data Analyst Interview Questions, Process, and Tips

Q1. 1. Puzzle 2. Self join question
Add your answer

Q1. Where and having clause difference
Ans. 
The difference between WHERE and HAVING clauses in SQL.
• WHERE clause is used to filter rows based on a condition before the data is grouped or aggregated.

• HAVING clause is used to filter groups based on a condition after the data is grouped or aggregated.

• WHERE clause is used with SELECT, UPDATE, DELETE statements, while HAVING clause is used with SELECT statements that include GROUP BY clause.

• WHERE clause filters individ...read more
Answered by AI
Add your answer

Q1. All kinda SQL questions, covering basic to advanced.
Add your answer

Q1. It was with director who tries to understand your analytical thoughts
Add your answer

Q1. Salary discussion
Add your answer

There were two parts ,One is theoretical and another one is practical.
In theoretical round questions on SQL and ETL tools (MCQs).
In practical round, mystery puzzle was given, in which we have to solve the puzzle using SQL ( Different tables were given and few conditions were given)

Q1. Difference between Having and where clause?
Ans. 
HAVING clause is used with GROUP BY to filter the results based on aggregate functions, while WHERE clause is used to filter individual rows.
• HAVING clause is used after GROUP BY clause.

• HAVING clause is used to filter the results based on aggregate functions like SUM, COUNT, AVG, etc.

• WHERE clause is used before GROUP BY clause.

• WHERE clause is used to filter individual rows based on conditions.

• HAVING clause cannot be use...read more
Answered by AI
Add your answer
Q2. Some questions on online e commerce business
Add your answer
Q3. What is LOD in Tableau?
Ans. 
LOD stands for Level of Detail. It is a technique used in Tableau to perform complex calculations on aggregated data.
• LOD expressions allow users to compute values at different levels of detail in a visualization

• They can be used to create custom aggregations, filters, and calculations

• There are three types of LOD expressions: FIXED, INCLUDE, and EXCLUDE

• FIXED LOD expressions define a level of detail that is independent of...read more
Answered by AI
Add your answer
Q4. Difference between Rank and Dense rank function?
Ans. 
Rank function assigns unique rank to each distinct row, while Dense rank function assigns same rank to rows with same values.
• Rank function is used to assign a unique rank to each distinct row based on the order specified in the ORDER BY clause.

• Dense rank function is used to assign the same rank to rows with the same values, skipping the next rank if there are ties.

• Rank function returns consecutive ranks, while dense ra...read more
Answered by AI
Add your answer
Q5. Some questions on Excel
Add your answer

2 questions on Aptitude test asked by Hiring manager and 1 SQL question

SQL test comprises of Warehouse Theoretical question and one SQL Murder Mystery Practical question.

Q1. Difference between Group by Where clause. LOD in Tableau Questions Regarding Projects.
Add your answer