Droom Senior Data Analyst Interview Questions and Answers

Q1. Excel and SQL based questions
Add your answer

Q1. Python and project based questions
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. 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. Understanding of Basic SQL was checked. Writing Basic SQL queries with where condition. SQL query question using Analytical function. ( 2nd most revenue-generating country) Difference between Rank and Dens...read more
Add your answer

Guestimate the number of people travelling in Metro at 6:30pm on weekday.
Case Study- Funnel Drop in a value chain( customer journey)
find out the reasons, and give the ideas to overcome and rank the ideas based on priority.

Q1. Business Round with Project Manager: Basically, tell about yourself more(not about work), what kind of person you are, future plans, expectations from the company, what you know about spinny, are you rea...read more
Add your answer

Round duration - 45 minutes
Round difficulty - Easy

Technical round with questions on DBMS, SQL , Tableu etc.

Q1. What is the difference between a dimension and a measure in Tableau?
Ans. 
Dimensions are categorical fields used for grouping and filtering data, while measures are numerical fields used for calculations and aggregation.
• Dimensions are qualitative data like names, dates, or categories.

• Measures are quantitative data like sales, profit, or quantity.

• Dimensions are used for slicing and dicing data, while measures are used for calculations and aggregations.

• Example: In a sales dataset, 'Product Cat...read more
Answered by AI
Add your answer
Q2. What are parameters in Tableau?
Ans. 
Parameters in Tableau are dynamic values that can replace constant values in calculations, filters, and reference lines.
• Parameters allow users to change the value of a calculation without modifying the calculation itself.

• They can be used in filters to allow users to dynamically control which data is displayed.

• Parameters can also be used in reference lines to dynamically set thresholds or targets.

• For example, a paramete...read more
Answered by AI
Add your answer
Q3. What is a subquery in SQL?
Ans. 
A subquery in SQL is a query nested within another query, used to return a subset of data from a larger dataset.
• A subquery is enclosed within parentheses and can be used in SELECT, INSERT, UPDATE, or DELETE statements.

• It can be used to filter results based on a condition, retrieve data from multiple tables, or perform calculations.

• Example: SELECT * FROM table1 WHERE column1 IN (SELECT column2 FROM table2 WHERE conditio
Answered by AI
Add your answer

Round duration - 30 minutes
Round difficulty - Easy

HR round with typical behavioral problems.