Turing Business Analyst and Team Lead Interview Questions and Answers for Experienced

Q1. Solving Excel problems 1
Add your answer
Q2. Solving Excel problems 2
Add your answer

Q1. Question based on sql joints and windows function.
Add your answer
Q2. Question on Advanced excel formula
Add your answer

Q1. SQL related from basic to advanced
Add your answer

Q1. SQL, basic python , case study , puzzles
Add your answer

Q1. Managerial questions
Add your answer

There were total 20 questions .the level of aptitude was easy ,most asked topics probability ,time distance , relationship and direction based questions.

SQL basic queries,joins , subqueries and MySQL instr function related questions asked .

Q1. Interviewer will discuss about your technical knowleBdge about the same.
Add your answer
Q2. Python libraries,bumpy,pandas ,matplotlib asked.
Add your answer

Q1. Difference between rank and dense rank
Ans. 
Rank assigns unique ranks to each distinct value, while dense rank does not leave gaps between ranks.
• Rank assigns unique ranks to each distinct value in a dataset

• Dense rank does not leave gaps between ranks, assigning consecutive ranks to values with the same rank

• For example, if values are 10, 20, 20, 30, then rank would be 1, 2, 2, 4 and dense rank would be 1, 2, 2, 3
Answered by AI
Add your answer
Q2. How will merge multiple file in python
Ans. 
Merge multiple files in Python using pandas.concat() or pd.merge() functions.
• Use pandas.concat() function to merge multiple files vertically (row-wise).

• Use pd.merge() function to merge multiple files horizontally (column-wise) based on a common column.

• Ensure that the files have compatible column names and data types before merging.

• Handle any missing or duplicate values appropriately during the merging process.

• Consider ...read more
Answered by AI
Add your answer
Q3. Data frame explain in detail
Ans. 
A data frame is a two-dimensional data structure in which data is stored in rows and columns.
• Data frames are commonly used in programming languages like R and Python for data analysis.

• Each column in a data frame represents a variable, while each row represents an observation.

• Data frames can contain different types of data, such as numeric, character, and factor.

• Data frames can be created from various sources like CSV f
Answered by AI
Add your answer

Q1. Sql questions mostly about windows function, aggregate, using having clause in group, union vs union all, mostly basics about sql.
Add your answer
Q2. Power Bi questions - measures in powerbi, calculate, dashboard, excel vs powerbi.
Add your answer
Q3. Assesment 5 question based on sql and excel. Easy questions like second highest salary, manager salary, count a's.
Add your answer

Q1. SQL join types and outputs
Ans. 
SQL join types include inner join, left join, right join, and full outer join, each producing different outputs.
• Inner join: returns rows that have matching values 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 all rows when there is a match in either
Answered by AI
Add your answer
Q2. Excel functions and formula
Add your answer

Q1. Guesstimates related to Uber
Add your answer
Q2. Puzzles related to shapes
Add your answer