Gartner Data Analyst Interview Questions and Answers

Q1. Questions on SQL, C++
Add your answer

Q1. Power BI Difference between ALL() and ALLSELECTED()
Ans. 
ALL() ignores all filters in the query context, while ALLSELECTED() ignores only filters on columns in the visual.
• ALL() removes all filters from the specified column or table.

• ALLSELECTED() removes filters from the specified column or table, but keeps filters on other columns in the visual.

• Example: ALL('Table') would remove all filters on the 'Table' in the query context.

• Example: ALLSELECTED('Column') would remove filte...read more
Answered by AI
Add your answer
Q2. Excel Difference between COUNT() and COUNTA()
Ans. 
COUNT() counts only numeric values, while COUNTA() counts all non-empty cells.
• COUNT() counts only cells with numerical values.

• COUNTA() counts all non-empty cells, including text and errors.

• Example: COUNT(A1:A5) will count only cells with numbers, while COUNTA(A1:A5) will count all non-empty cells.
Answered by AI
Add your answer

Q1. Resume based questions like explain the projects that you have done.
Add your answer
Q2. Sample dataset questions
Add your answer

Basic quant questions with some questions on ML. 2 python questions based on data processing.

Q1. Difference between list and set
Ans. 
List is an ordered collection of elements with duplicates allowed, while set is an unordered collection of unique elements.
• List maintains the order of elements, while set does not guarantee any specific order.

• List allows duplicate elements, while set does not allow duplicates.

• List is accessed by index, while set is accessed by value.

• Example: List - [1, 2, 3, 1], Set - {1, 2, 3}
Answered by AI
Add your answer
Q2. Difference between concat and merge
Ans. 
Concat is used to combine data along a particular axis, while merge is used to combine data based on a common key.
• Concatenation is done along an axis (rows or columns) in pandas, while merging is done based on common columns or indices.

• Concatenation is a simple operation that just appends data, while merging involves combining data based on a key.

• Concatenation can be done even if the data does not have common columns, ...read more
Answered by AI
Add your answer