ABB Motors Data Analyst Interview Questions and Answers

Q1. Can you tell me about yourself?
Add your answer
Q2. Can you provide details about your city?
Add your answer

Q1. Tell me about yourself.
Add your answer
Q2. What is your previous work experience?
Add your answer

Q1. Some computer tasks
Add your answer
Q2. Reading test
Add your answer

Q1. How do you gain experience in data analysis?
Add your answer
Q2. What are your thoughts on the matter?
Add your answer
Q3. What is algorithm
Add your answer

Q1. What is a data structure?
Add your answer
Q2. What are the different types of data structures available?
Add your answer

Aptitude test for selection.

Q1. What is your understanding of data analytics?
Ans. 
Data analytics involves analyzing raw data to draw conclusions and make informed decisions.
• Data analytics involves collecting, processing, and analyzing data to identify trends and patterns.

• It helps businesses make data-driven decisions and improve performance.

• Techniques used in data analytics include data mining, machine learning, and statistical analysis.

• Examples of data analytics in action include predicting custome...read more
Answered by AI
Add your answer
Q2. What is the significance of data analytics in analyzing and visualizing data?
Ans. 
Data analytics is crucial for extracting insights and patterns from data, and visualizing them in a meaningful way.
• Data analytics helps in identifying trends, patterns, and correlations within large datasets.

• It enables businesses to make informed decisions based on data-driven insights.

• Visualizations such as charts, graphs, and dashboards make complex data easier to understand and interpret.

• Data analytics can uncover h...read more
Answered by AI
Add your answer

Q1. Python string is changable or not
Ans. 
Python strings are immutable, meaning they cannot be changed once created.
• Python strings are immutable, so any operation that appears to modify a string actually creates a new string object.

• For example, when you use string concatenation or slicing, a new string is created instead of modifying the original string.

• To modify a string in Python, you would need to create a new string with the desired changes.
Answered by AI
Add your answer
Q2. Sql window function ?
Add your answer
Q3. Difference between having and where cause
Ans. 
HAVING is used with GROUP BY to filter groups, WHERE is used to filter rows
• HAVING is used with GROUP BY clause to filter the groups based on aggregate functions

• WHERE is used to filter rows based on conditions

• HAVING is applied after the GROUP BY clause, WHERE is applied before

• HAVING can only be used with SELECT statement that contains a GROUP BY clause

• Example: SELECT department, AVG(salary) FROM employees GROUP BY depar...read more
Answered by AI
Add your answer
Q4. Sql union and union all
Add your answer
Q5. Python using remove duplicate value
Ans. 
Use Python's set() function to remove duplicate values from an array of strings.
• Convert the array to a set to automatically remove duplicates

• Convert the set back to a list if needed
Answered by AI
Add your answer

Q1. Difference between Sum and Sumx
Ans. 
Sum calculates the total of a column, while Sumx calculates the total of an expression evaluated for each row.
• Sum is used to calculate the total of a column in a table.

• Sumx is used to calculate the total of an expression evaluated for each row in a table.

• Sum: SUM('Table'[Column])

• Sumx: SUMX('Table', 'Table'[Column] * 2)
Answered by AI
Add your answer
Q2. How do u make groups and how bins are different from groups
Ans. 
Groups are created by categorizing data based on certain criteria, while bins are specific ranges used to group continuous data.
• Groups are created by categorizing data based on certain criteria, such as age groups or product categories.

• Bins are specific ranges used to group continuous data, such as age ranges or income brackets.

• Groups can be created based on qualitative data, while bins are used for quantitative data.

• E...read more
Answered by AI
Add your answer
Q3. Why do you prefer power bi over tableau
Ans. 
Power BI is preferred over Tableau for its seamless integration with Microsoft products and user-friendly interface.
• Seamless integration with Microsoft products like Excel, SharePoint, and Teams

• User-friendly interface with drag-and-drop functionality for easy data visualization

• Cost-effective solution for organizations already using Microsoft products

• Faster data processing and refreshing capabilities compared to Tableau

• ...read more
Answered by AI
Add your answer
Q4. Tell me about your roles and responsibilities
Ans. 
I have experience in data collection, analysis, and visualization to support decision-making.
• Collecting and cleaning data from various sources

• Analyzing data to identify trends and patterns

• Creating visualizations and reports to communicate findings

• Collaborating with stakeholders to understand business needs

• Using statistical tools and techniques to draw insights

• Presenting findings to non-technical audiences
Answered by AI
Add your answer

Basic questions can be attempted easily

2 coding questions edge cases were hard to find

Q1. Resume based questions and project idea breifing
Add your answer
Q2. Have any questions for interviewer
Add your answer

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

Q1. Difference between joins
Ans. 
Joins are used to combine rows from two or more tables based on a related column between them.
• 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 one of the tables.

• Cross Join:
Answered by AI
Add your answer
Q2. Window function
Add your answer

Q1. Write sql query in pythons
Ans. 
Writing SQL queries in Python allows for seamless integration of data analysis and manipulation.
• Use libraries like pandas or sqlalchemy to execute SQL queries in Python

• Remember to establish a connection to the database before executing queries

• Utilize Python's flexibility to manipulate and analyze data retrieved from SQL queries
Answered by AI
Add your answer