Premium Employer

i

This company page is being actively managed by Gartner Team. If you also belong to the team, you can get access from here

Gartner Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Gartner Data Analyst Interview Questions and Answers

Updated 22 Aug 2024

Gartner Data Analyst Interview Experiences

2 interviews found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 22 Aug 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Hard DP level DSA question

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 10 Jun 2024

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via Company Website and was interviewed in Dec 2023. There was 1 interview round.

Round 1 - HR 

(2 Questions)

  • Q1. What projects are you working on?
  • Q2. Tell me about a time you struggled.

Data Analyst Interview Questions Asked at Other Companies

asked in Deloitte
Q1. Suppose there is a room in the office and X people enter room thr ... read more
asked in Wipro
Q2. Chocolate Distribution Problem You are given an array/list CHOCOL ... read more
asked in Wipro
Q3. Ninja and Substrings Problem Statement Ninja has to determine all ... read more
asked in Capgemini
Q4. Ninja and His Secret Information Encoding Problem Ninja, a new me ... read more
Q5. Sliding Window Maximum Problem Statement You are given an array/l ... read more

Interview questions from similar companies

I applied via Job Portal and was interviewed before Jan 2021. There were 2 interview rounds.

Round 1 - Aptitude Test 
Round 2 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips

Interview Preparation Tips

Topics to prepare for Deloitte Data Analyst interview:
  • Procurement
  • Marketing
  • Career goal
Interview preparation tips for other job seekers - Location should be Delhi NCR,Monday would be good

I applied via Walk-in and was interviewed in Apr 2020. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. Cut Cake in 3 cut to maximum pieces
  • Q2. Basic SQL queries

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident even you don’t have experience in the relevant skill set.

You can be absorbed to much related profile of your interests.

They only check how better you represent yourself and your problem solving approach.

Interview Questionnaire 

1 Question

  • Q1. SQL, Power Bi, Python, Azure

Interview Preparation Tips

Interview preparation tips for other job seekers - Read the Job Description properly. Clear you basics and prepare according to the JD

I applied via Naukri.com and was interviewed in Jun 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. About SAP BODS

Interview Preparation Tips

Interview preparation tips for other job seekers - Be strong and concentrate on basics.

I applied via Naukri.com and was interviewed before Oct 2020. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Write a query where all the customer name start with A
  • Ans. 

    Query to retrieve all customer names starting with A.

    • Use the SELECT statement to retrieve customer names.

    • Use the LIKE operator with the pattern 'A%' to match names starting with A.

    • Specify the table and column name where the customer names are stored.

    • Example: SELECT customer_name FROM customers WHERE customer_name LIKE 'A%';

  • Answered by AI
  • Q2. Write a query where we'll get state wise sales summary report. Actually in this query we have to join multiple table and finding the rank .

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview was extremely easy and smooth.

Skills evaluated in this interview

I applied via Campus Placement and was interviewed before Jun 2021. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Questions on SQL, C++

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare SQL, Python and ETL well along with great communication skills.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • 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...

  • Answered by AI
  • 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
Round 2 - Technical 

(2 Questions)

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

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Approached by Company and was interviewed in May 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

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

Round 2 - Technical 

(2 Questions)

  • 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
  • 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, ...

  • Answered by AI

Skills evaluated in this interview

Contribute & help others!
anonymous
You can choose to be anonymous

Gartner Interview FAQs

How many rounds are there in Gartner Data Analyst interview?
Gartner interview process usually has 1 rounds. The most common rounds in the Gartner interview process are HR and Technical.
How to prepare for Gartner Data Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Gartner. The most common topics and skills that interviewers at Gartner expect are Recruitment, SQL, Data Analysis, Python and Analytics.

Recently Viewed

INTERVIEWS

o9 Solutions

No Interviews

INTERVIEWS

Godfrey Phillips India

No Interviews

JOBS

o9 Solutions

No Jobs

SALARIES

Gartner

LIST OF COMPANIES

Deutsche Telekom Digital Labs

Overview

INTERVIEWS

Gartner

No Interviews

INTERVIEWS

Nestle

No Interviews

SALARIES

Gartner

SALARIES

Colgate Palmolive

INTERVIEWS

Emami

No Interviews

Tell us how to improve this page.

Gartner Data Analyst Interview Process

based on 2 interviews

Interview experience

3.5
  
Good
View more
Join Gartner We guide the leaders who shape the world.​
Gartner Data Analyst Salary
based on 66 salaries
₹5.6 L/yr - ₹18 L/yr
92% more than the average Data Analyst Salary in India
View more details

Gartner Data Analyst Reviews and Ratings

based on 9 reviews

4.8/5

Rating in categories

4.2

Skill development

4.5

Work-life balance

4.1

Salary

4.9

Job security

5.0

Company culture

4.1

Promotions

4.3

Work satisfaction

Explore 9 Reviews and Ratings
Business Analyst
238 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
214 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Software Engineer
171 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Business Analyst
159 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Research Specialist
149 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Gartner with

Forrester

3.7
Compare

International Data Corporation

3.9
Compare

Frost & Sullivan

3.1
Compare

McKinsey & Company

3.8
Compare
Did you find this page helpful?
Yes No
write
Share an Interview