INDIUM Junior Data Analyst Interview Questions, Process, and Tips for Freshers

2 sql questions 30 mins duration mostly focused on joins

Impacts of social media 20 min duration

Q1. Window functions query on rank.
Ans. 
Window functions in SQL are used to perform calculations across a set of table rows related to the current row.
• Use the RANK() function to assign a unique rank to each row within a partition of a result set.

• You can use the PARTITION BY clause to divide the result set into partitions to rank separately within each partition.

• Example: SELECT column1, column2, RANK() OVER (PARTITION BY column1 ORDER BY column2) AS rank_colu
Answered by AI
Add your answer
Q2. Window function query on lead.
Ans. 
Window function query on lead is used to retrieve the next row in a result set.
• Lead() function is used to access data from the next row in a result set.

• It is commonly used in scenarios where you need to compare data from the current row with data from the next row.

• Example: SELECT column_name, LEAD(column_name, 1) OVER (ORDER BY column_name) AS next_value FROM table_name;
Answered by AI
Add your answer
Q3. Palindrome or not in python
Ans. 
Check if a given string is a palindrome in Python.
• Use string slicing to reverse the string and compare it with the original string.

• Remove any spaces and convert all characters to lowercase for accurate comparison.

• Example: 'radar' is a palindrome, 'hello' is not.
Answered by AI
Add your answer

Q1. Project overview and project related questions
Add your answer
Q2. One business understanding problem
Ans. 
One business understanding problem is identifying customer churn reasons in a subscription-based service.
• Analyze customer data to identify patterns or trends leading to churn

• Utilize predictive modeling to forecast potential churn

• Implement targeted retention strategies based on findings

• Monitor and track the effectiveness of retention efforts
Answered by AI
Add your answer
Q3. Other than resume
Add your answer

Q1. Basic attitude checking quetions
Add your answer