ABB Data Analyst Interview Questions and Answers

Around 50 Data science questions in the MCQ format, it was conducted on hacker earth platform, wnough time was available to answer all of them

Q1. 1.Machine learning questions based on different models, kernal functions, decision trees.
Add your answer
Q2. 2, They asked SQL queries and python outputs and basic definitions and differences
Add your answer

Q1. Basic SQL , Joins , Stored procedures ,functions
Add your answer

Predictive modeling project

Q1. Explain the project and that related questions only.
Add your answer

Q1. Tell me a project you did in school that shows innovation?
Add your answer

Q1. What is the difference between AI, deep learning and machine learning
Ans. 
AI is the broader concept of machines being able to carry out tasks in a way that we would consider smart. Machine learning is a subset of AI that allows machines to learn from data. Deep learning is a subset of machine learning that uses neural networks with many layers to model and solve complex problems.
• AI is the broader concept of machines being able to carry out tasks in a way that we would consider smart.

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

Q1. He ask about of your previous company and all
Add your answer

Q1. It totals depends upon for which profile you are giving interview. Mine was Data Analyst so the interviewer ask me about excel,sql,power bi and some part of statistics
Add your answer

Q1. He just asked my about my profile briefly and then questioned me about my profile ony then he told me about the work culture and the requiremnt of the profile.
Add your answer

30 questions and time was approx. 45 min to 60 min

There were some basic as well as some high level questions

Q1. What are joins and its types?
Ans. 
Joins are used to combine rows from two or more tables based on a related column between them.
• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• INNER JOIN returns rows when there is at least one 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 ...read more
Answered by AI
Add your answer
Q2. What are aggregate functions?
Ans. 
Aggregate functions are functions in databases that perform a calculation on a set of values and return a single value.
• Aggregate functions are used to perform operations on a group of rows and return a single result.

• Common aggregate functions include SUM, AVG, COUNT, MIN, and MAX.

• For example, SUM function calculates the total of a column, AVG calculates the average, COUNT counts the number of rows, MIN finds the minimu
Answered by AI
Add your answer

Q1. Coding questions in python eda part
Add your answer

Q1. Where do u see in next 5 years
Add your answer