IndusInd Bank Data Analyst Interview Questions and Answers

Basic python ,sql questions

Q1. What is list,tuple,set,dict comprehension
Ans. 
List, tuple, set, and dict comprehensions are concise ways to create these data structures in Python.
• List comprehension: [x for x in range(10)]

• Tuple comprehension does not exist in Python, as tuples are immutable.

• Set comprehension: {x for x in range(10)}

• Dict comprehension: {x: x**2 for x in range(10)}
Answered by AI
Add your answer
Q2. What is Dax query
Ans. 
DAX (Data Analysis Expressions) is a formula language used in Power BI, Excel, and other Microsoft tools for data analysis.
• DAX is used to create custom calculations, measures, and columns in data models.

• It is similar to Excel formulas but optimized for data analysis.

• DAX functions can be used to manipulate and analyze data in Power BI reports.

• Examples of DAX functions include SUM, AVERAGE, CALCULATE, and RELATED.
Answered by AI
Add your answer

Q1. Base on SQL and tableau
Add your answer
Q2. How join work share in detail with examples
Add your answer
Q3. How to get nth salary
Add your answer
Q4. How to delete duplicates
Ans. 
To delete duplicates, use SQL query with DISTINCT keyword or remove duplicates programmatically in Python using sets.
• Use SQL query with DISTINCT keyword to remove duplicates from a database table

• In Python, remove duplicates from a list using sets: list(set(original_list))

• For pandas DataFrame, drop duplicates using df.drop_duplicates()
Answered by AI
Add your answer

Q1. Live coding on the platform
Add your answer

An easy coding round was conducted that involved SQL questions.

An easy one-hour discussion based on the resume.

Q1. Asked regarding sql to make a table and given some queries to solve over the table
Add your answer
Q2. Given easy code to solve before them very easy
Add your answer

Q1. Regarding place
Add your answer
Q2. Regarding night shifts
Add your answer

Easy on cyber security

Q1. Introduce yourself this is
Add your answer
Q2. What is your work experience
Add your answer