Annapurna Finance Data Analyst Interview Questions and Answers for Experienced

Q1. Questions mainly involved window function, recursion, some puzzels
Add your answer

Q1. Tell me about your self
Add your answer
Q2. SQL basics
Add your answer
Q3. Banking terms
Add your answer

Q1. What is data analyst
Ans. 
A data analyst is a professional who collects, processes, and analyzes data to provide insights and support decision-making.
• Collects data from various sources

• Cleans and processes data to ensure accuracy

• Analyzes data using statistical methods and tools

• Interprets data to identify trends and patterns

• Presents findings and recommendations to stakeholders
Answered by AI
Add your answer
Q2. Asked question regarding project mention
Add your answer

Q1. Proficiency in data analytics tool level?
Add your answer

Q1. Tell me about the types of join sql.
Ans. 
Types of join SQL include inner join, left join, right join, and full outer join.
• Inner join: Returns rows when there is a match in both tables.

• 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 outer join: Returns rows when there is a match in either table.
Answered by AI
Add your answer
Q2. Tell about the dax function
Ans. 
DAX (Data Analysis Expressions) is a collection of functions, operators, and constants that can be used in Power BI, Excel, and other data analysis tools.
• DAX functions are used to create calculated columns, measures, and calculated tables in Power BI and Excel.

• DAX functions include mathematical, logical, statistical, and text functions.

• Examples of DAX functions are SUM, AVERAGE, IF, RELATED, CALCULATE, etc.
Answered by AI
Add your answer

Basic aptitude test

Q1. Related to data science
Add your answer

Basic aptitude test . quantivative

Nbfc . in india and its performance