ABB Junior Data Analyst Interview Questions and Answers

Product life cycle refers to the stages a product goes through from introduction to decline. Product hierarchy is the arrangement of products into categories based on their attributes.

• Product life cycle includes introduction, growth, maturity, and decline stages

• Product hierarchy involves categorizing products based on their attributes such as size, color, and features

• Product hierarchy can also involve grouping products...read more

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

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