Dailyhunt Senior Data Analyst Interview Questions and Answers

Q1. What is Vlookup and Hlookup
Add your answer

Questions related to logical thinking

Common topics related to AI & other stuffs

Q1. Excel basic questions such as conditional formatting
Add your answer
Q2. Sql questions such as Types of Joints etc
Add your answer

Q1. Asked about Sql window functions
Add your answer
Q2. Precison, Recall, Auc
Add your answer

Q1. Linear regresssion assumptions
Add your answer
Q2. Trees bagging vs boosting
Ans. 
Trees bagging and boosting are ensemble learning techniques that use multiple decision trees, but with different approaches.
• Bagging (Bootstrap Aggregating) involves training multiple decision trees independently on different subsets of the training data and then averaging the predictions. Examples include Random Forest.

• Boosting involves training multiple decision trees sequentially, with each tree correcting the errors...read more
Answered by AI
Add your answer

Q1. General personal background questions
Add your answer

Sql based test.. question on python

Sql based coding test

Send assignment doings MS Excel

Q1. Asked about the previous project
Add your answer
Q2. What about your roles in previous company
Add your answer

Q1. Details about the projects in your resume
Add your answer
Q2. MYSQL codes in window function
Ans. 
MYSQL window functions allow for calculations across rows in a result set.
• Window functions are used to perform calculations across rows in a result set

• They are used with the OVER() clause

• Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE()

• They can be used to calculate running totals, moving averages, and more
Answered by AI
Add your answer
Q3. Mostly questions related to cricket tables which was told to be assumed
Add your answer

Q1. Questions on SQL Puzzles Guesstimates
Add your answer

Puzzles
Case Study