Droom Senior Data Analyst Interview Questions and Answers

Q1. What are your salary expectations?
Add your answer
Q2. Share details of your previous job.
Add your answer
Q3. Why are you looking for a change?
Add your answer
Q4. Tell me about yourself.
Add your answer

Q1. Sql, tableau, excel relates questions asked, it difficult but i focused on basics
Add your answer

Q1. Share details of your previous job.
Add your answer
Q2. What is your family background?
Add your answer
Q3. What are your salary expectations?
Add your answer

Q1. Cohort Analysis in google analytics
Ans. 
Cohort analysis in Google Analytics helps track the behavior of specific groups of users over time.
• Cohort analysis groups users based on a common characteristic or behavior, such as sign-up date or acquisition channel.

• It helps in understanding user retention, engagement, and conversion rates for different cohorts.

• Example: Analyzing the retention rate of users who signed up in a particular month compared to users who si
Answered by AI
Add your answer
Q2. Types of join in sql and their differences
Ans. 
Types of joins in SQL include inner join, outer join, left join, right join, and full join.
• Inner join: returns rows when there is a match in both tables

• Outer join: returns all rows from both tables, filling in NULLs for missing matches

• Left join: returns all rows from the left table and the matched rows from the right table

• Right join: returns all rows from the right table and the matched rows from the left table

• Full joi...read more
Answered by AI
Add your answer

Q1. Explain group by clause with used cases
Ans. 
Group by clause is used to group data based on a specific column in a table.
• Used with aggregate functions like SUM, COUNT, AVG, etc.

• Helps in analyzing data by grouping it based on a common attribute.

• Can be used with multiple columns to create nested groups.

• Example: GROUP BY department in a table of employees to get the total salary for each department.
Answered by AI
Add your answer
Q2. CountA,CountB,Countif used case in Google sheet
Ans. 
CountA, CountB, Countif are functions used in Google Sheets to count cells based on certain criteria.
• CountA counts the number of cells in a range that are not empty.

• CountB counts the number of cells in a range that are not blank.

• Countif counts the number of cells in a range that meet a certain condition.

• Countif can be used with operators like >, <, =, and functions like AND, OR.

• Countif can also be used with wildcards l
Answered by AI
Add your answer

Q1. Where have stayed...why want to switch...what will be your priority ..job or family
View 3 more answers

Q1. Excel, SQL, Pandas
Add your answer

Round 2,3,4 are Business round

Q1. Excel based questions in , vlookup, xlookup, index , match
Add your answer
Q2. SQL questions using queries based on concepts like subqueries, CTE & windows functions
Add your answer
Q3. Scenerio-based question, table 1 & table 2 with 5 & 3 liter if water, assuming the flow of water is unlimited & we need to get 4 liter of it
Add your answer

Q1. Basic Excel, Regression, Anova model, CHAID model etc
Add your answer
Q2. Previous experience
Add your answer

Q1. SQL joins , previous experience
Add your answer
Q2. Guesstimate, probability questions
Add your answer

Q1. SQL Question using window functions
Add your answer
Q2. Guesstimate on Number of McD orders
Ans. 
The number of McDonald's orders can be estimated based on factors like location, time of day, and day of the week.
• Consider the population density of the area where the McDonald's is located

• Take into account the time of day - more orders during meal times

• Factor in the day of the week - weekends may have higher order volumes

• Look at historical data or industry averages for similar locations

• Consider any promotions or speci
Answered by AI
Add your answer

How many cars in this world