Upload Button Icon Add office photos

Filter interviews by

KPMG Global Services Data Analyst Interview Questions and Answers

Updated 23 Feb 2024

KPMG Global Services Data Analyst Interview Experiences

2 interviews found

Data Analyst Interview Questions & Answers

user image Gyanesh Vaibhav

posted on 23 Feb 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Feb 2023. There were 2 interview rounds.

Round 1 - Coding Test 

Sql question will be asked basics

Round 2 - One-on-one 

(1 Question)

  • Q1. Team lead will take interview and ask about your previous experience

Interview Preparation Tips

Interview preparation tips for other job seekers - Be calm and truthful

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 17 Oct 2023

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - 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 tips
Round 2 - Technical 

(2 Questions)

  • Q1. A little about Alteryx.
  • Ans. SQL queries writing -join , like, limit, group by . Alteryx: basic join , transpose, Alteryx scheduler.
  • Answered Anonymously
  • Q2. Sql related queries.
  • Ans. Sql queries writing join like group by
  • Answered Anonymously

Interview Preparation Tips

Interview preparation tips for other job seekers - Just be confident and learn basics of excel, SQL Alteryx or powerBI.

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 ProblemGiven an array/list of integer numbers 'CHOCOLAT ... read more
asked in Wipro
Q3. Ninja and substringsNinja has been given a string 'STR' containin ... read more
Q4. Maximum In Sliding Windows Of Size KGiven an array/list of intege ... read more
asked in Tredence
Q5. First Repeated CharacterYou are given a string 'STR' of lowercase ... read more

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
6-8 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Dec 2024. There were 4 interview rounds.

Round 1 - Aptitude Test 

Set of questions on english , aptitude , all are at easy level

Round 2 - Coding Test 

Sql basics and some query questions

Round 3 - HR 

(2 Questions)

  • Q1. Why do u want to join zs ; what do u know about zs; where do u see urself after 5 years ; question on real life scenarios ;
  • Q2. Question on real life scenarios
Round 4 - HR 

(2 Questions)

  • Q1. Salary expectation
  • Q2. When can u join

Interview Preparation Tips

Interview preparation tips for other job seekers - prepare all topics thorougly and general scenario questions and be confident and able to provide justice to ur approach
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Newspaper Ad and was interviewed in Aug 2024. There were 3 interview rounds.

Round 1 - Aptitude Test 

Three sections are there 1) Aptitude Test 2) SQL 3) DSA

Round 2 - Technical 

(2 Questions)

  • Q1. What is DSA , sorting , difference between array and linked list
  • Ans. 

    DSA stands for Data Structures and Algorithms. Sorting is the process of arranging data in a particular order. Array is a data structure that stores elements of the same data type in contiguous memory locations, while linked list is a data structure that stores elements in nodes with pointers to the next node.

    • DSA stands for Data Structures and Algorithms

    • Sorting is the process of arranging data in a particular order

    • Arra...

  • Answered by AI
  • Q2. Written a SQL query
Round 3 - HR 

(2 Questions)

  • Q1. Coding question like add numbers
  • Q2. Experience on your project
  • Ans. 

    I have experience working on various data analysis projects, including market research, customer segmentation, and predictive modeling.

    • Developed predictive models to forecast customer behavior and optimize marketing strategies

    • Conducted market research to identify trends and opportunities for growth

    • Performed customer segmentation analysis to target specific demographics with personalized marketing campaigns

  • Answered by AI

Skills evaluated in this interview

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 Naukri.com and was interviewed in Sep 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Tableau, SQL related question
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Indeed and was interviewed in Jan 2024. There were 2 interview rounds.

Round 1 - HR 

(3 Questions)

  • Q1. Basics of power bi and sql
  • Q2. What are joins and types of join
  • 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 JOIN...

  • Answered by AI
  • Q3. How to add date table in power bi
  • Ans. 

    To add a date table in Power BI, you can create a new table with a list of dates and relationships with other tables.

    • Create a new table in Power BI with a list of dates

    • Add columns for day, month, year, etc. for additional analysis

    • Establish relationships between the date table and other tables in the data model

  • Answered by AI
Round 2 - Technical 

(4 Questions)

  • Q1. Sql scenario based question on joins
  • Q2. Window function questions
  • Q3. Performance tuning
  • Q4. Power bi dax question

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
Easy
Process Duration
-
Result
Selected Selected
Round 1 - HR 

(1 Question)

  • Q1. How good are you with numbers
Round 2 - Technical 

(1 Question)

  • Q1. Vlookup, pivot table, sumif, average, graphs
Round 3 - Behavioral 

(1 Question)

  • Q1. Do you know the role and responsibility of this position
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Mar 2024. There were 3 interview rounds.

Round 1 - Aptitude Test 

Basic aptitude questions liek tiem distance, percentage , ratio, work and hour

Round 2 - Coding Test 

Excel, Numpy, Pandas, basic ML

Round 3 - Case Study 

Case study talking about how to optimise the supply chain using data analytics

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

(1 Question)

  • Q1. Hard DP level DSA question

KPMG Global Services Interview FAQs

How many rounds are there in KPMG Global Services Data Analyst interview?
KPMG Global Services interview process usually has 2 rounds. The most common rounds in the KPMG Global Services interview process are Resume Shortlist, Technical and Coding Test.
What are the top questions asked in KPMG Global Services Data Analyst interview?

Some of the top questions asked at the KPMG Global Services Data Analyst interview -

  1. Team lead will take interview and ask about your previous experie...read more
  2. a little about Alter...read more
  3. Sql related queri...read more

Tell us how to improve this page.

People are getting interviews through

based on 1 KPMG Global Services interview
Referral
100%
Low Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.

Data Analyst Interview Questions from Similar Companies

ZS Data Analyst Interview Questions
3.4
 • 14 Interviews
View all
KPMG Global Services Data Analyst Salary
based on 84 salaries
₹4.2 L/yr - ₹12.5 L/yr
17% more than the average Data Analyst Salary in India
View more details

KPMG Global Services Data Analyst Reviews and Ratings

based on 11 reviews

4.3/5

Rating in categories

4.1

Skill development

3.6

Work-Life balance

3.5

Salary & Benefits

3.6

Job Security

3.9

Company culture

3.1

Promotions/Appraisal

3.5

Work Satisfaction

Explore 11 Reviews and Ratings
Assistant Manager
2.7k salaries
unlock blur

₹10.7 L/yr - ₹39 L/yr

Consultant
2.6k salaries
unlock blur

₹8 L/yr - ₹28 L/yr

Associate Consultant
2.3k salaries
unlock blur

₹4.5 L/yr - ₹17.5 L/yr

Analyst
981 salaries
unlock blur

₹1.5 L/yr - ₹10 L/yr

Senior Analyst
877 salaries
unlock blur

₹3.6 L/yr - ₹13 L/yr

Explore more salaries
Compare KPMG Global Services with

Deloitte

3.8
Compare

EY Global Delivery Services ( EY GDS)

3.6
Compare

PwC

3.4
Compare

Accenture

3.9
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview