Turing Data Analyst Interview Questions and Answers

Q1. Introduction of yourself
Add your answer

Assignment of Google sheets

Q1. Self introduction
Add your answer
Q2. What do you know about analysis and logical reasoning
Ans. 
Analysis and logical reasoning involve examining data, identifying patterns, and drawing conclusions based on evidence.
• Analysis involves breaking down complex information into smaller components for better understanding.

• Logical reasoning is the process of using rational thinking to make sense of information and draw valid conclusions.

• Analytical skills are essential for interpreting data accurately and making informed d...read more
Answered by AI
Add your answer

Q1. First was Hr round, where he asked about myself, my experience, salary expectations, current salary.
Add your answer

Q1. Then the second round was with Arun Sir, who has asked advanced excel formulas, advanced google sheets formulas, SQL basics. And later told that will let you know, but haven't updated yet.
Add your answer
Q2. Dcount function ABS function Excel remove minus sign from integer using a formula.
Ans. 
Dcount function counts the number of unique values in a dataset. ABS function returns the absolute value of a number. To remove minus sign from an integer in Excel, use a formula like =ABS(A1).
• Dcount function counts unique values in a dataset

• ABS function returns absolute value of a number

• To remove minus sign from an integer in Excel, use formula like =ABS(A1)
Answered by AI
Add your answer
Q3. Filters Transfer data from 1 sheet to other Join , inner, outer, self, left right Along with the syntax Colene function in SQL Show top value show values between a date range Sumifs countifs
Ans. 
Answering questions related to data filtering, transferring, joining, and SQL functions for a Data Analyst role.
• To transfer data from one sheet to another, you can use functions like VLOOKUP or INDEX/MATCH in Excel.

• Different types of joins in SQL include INNER JOIN, OUTER JOIN, LEFT JOIN, RIGHT JOIN, and SELF JOIN.

• Syntax for INNER JOIN: SELECT columns FROM table1 INNER JOIN table2 ON table1.column = table2.column;

• Synta...read more
Answered by AI
Add your answer