Upload Button Icon Add office photos

Filter interviews by

Clear (1)

KPMG India Business Intelligence Analyst and Tableau Developer Interview Questions, Process, and Tips

Updated 8 Oct 2024

KPMG India Business Intelligence Analyst and Tableau Developer Interview Experiences

1 interview found

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

I applied via LinkedIn and was interviewed in Sep 2024. There were 3 interview rounds.

Round 1 - Technical 

(4 Questions)

  • Q1. Top and Bottom in one sheet
  • Ans. 

    Use LOD calculations to display top and bottom values in one sheet in Tableau.

    • Use Level of Detail (LOD) calculations to create separate calculated fields for top and bottom values.

    • Use these calculated fields in the same sheet to display both top and bottom values.

    • For example, create a calculated field for top values using {FIXED [Dimension]: MAX([Measure])} and another for bottom values using {FIXED [Dimension]: MIN([M

  • Answered by AI
  • Q2. Usage of parameter and filters
  • Ans. 

    Parameters and filters are key features in Tableau for dynamic data analysis and visualization.

    • Parameters allow users to input values that can be used in calculations, filters, and reference lines.

    • Filters are used to limit the data displayed in a visualization based on specified criteria.

    • Parameters can be used to create dynamic filters that allow users to interact with the data in real-time.

    • Combining parameters and fil...

  • Answered by AI
  • Q3. Types of LOD and its use case
  • Ans. 

    Types of LOD include Fixed, Include, and Exclude LOD calculations for different use cases.

    • Fixed LOD: Used to ignore the level of detail in the view and compute an aggregate value.

    • Include LOD: Used to compute an aggregate value at a higher level of detail than the view.

    • Exclude LOD: Used to compute an aggregate value at a lower level of detail than the view.

  • Answered by AI
  • Q4. Performance Optimization
Round 2 - Technical 

(3 Questions)

  • Q1. Project Overview and Size
  • Q2. Performance Optimization
  • Q3. Open for work in different technologies
Round 3 - Behavioral 

(3 Questions)

  • Q1. Introduction and Role
  • Q2. Tableau Prep and its usage
  • Ans. 

    Tableau Prep is a data preparation tool that allows users to clean, combine, and shape data for analysis in Tableau.

    • Tableau Prep helps in cleaning and transforming data before visualizing it in Tableau Desktop.

    • It allows users to easily combine multiple data sources and perform data cleaning tasks like removing duplicates, splitting columns, and aggregating data.

    • Tableau Prep also provides a visual interface for creating...

  • Answered by AI
  • Q3. Snowflake vs Star Schema
  • Ans. 

    Snowflake schema is a normalized form of Star schema with multiple levels of dimension tables.

    • Snowflake schema has normalized dimension tables, while Star schema has denormalized dimension tables.

    • Snowflake schema is more complex and requires more joins compared to Star schema.

    • Star schema is easier to understand and query, making it more suitable for smaller datasets.

    • Snowflake schema is more suitable for larger datasets

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - First round was purely technical, rest two were combined of technical and managerial.

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
6-8 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before Dec 2022. There were 4 interview rounds.

Round 1 - Aptitude Test 

It consists of the Quant, LRDI, Verbal reasoning & Email Writing.

Round 2 - Group Discussion 

Effect of Social Media and Internet in our Daily Life

Round 3 - Technical 

(1 Question)

  • Q1. Gone through my resume and ask the stuff from my resume itself, including my projects, certificates etc.
Round 4 - HR 

(1 Question)

  • Q1. Do you know about EY? What is EY? How you can aligned yourself with EY

Interview Preparation Tips

Interview preparation tips for other job seekers - Be Confident and good to interviewer.
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Was normal SQL query

Round 2 - One-on-one 

(2 Questions)

  • Q1. Power bi questions
  • Q2. SQL questions basic theoretical questions
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
-

I applied via Company Website and was interviewed in Sep 2024. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Mostly regarding projects
  • Q2. Questions realed to Azure services
Round 2 - Behavioral 

(3 Questions)

  • Q1. Senerio based questions - which azure services could be used in this case
  • Q2. Where do you see yourself in next 5 years
  • Ans. 

    In the next 5 years, I see myself advancing to a managerial role within the company, leading a team and contributing to the organization's growth.

    • Continuing to excel in my current role and taking on additional responsibilities

    • Participating in leadership development programs to enhance my skills

    • Building strong relationships with colleagues and mentors for guidance and support

    • Setting clear career goals and regularly revi

  • Answered by AI
  • Q3. What you expect from your employer
  • Ans. 

    I expect my employer to provide opportunities for growth, a supportive work environment, fair compensation, and open communication.

    • Opportunities for professional development and advancement

    • A positive and inclusive work culture

    • Competitive salary and benefits

    • Transparent communication and feedback

    • Work-life balance support

  • Answered by AI

Interview Preparation Tips

Topics to prepare for PwC Senior Associate interview:
  • Azure
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Selected Selected

I was interviewed before Feb 2024.

Round 1 - Aptitude Test 

One hour allocated for the non-technical test.

Round 2 - HR 

(1 Question)

  • Q1. Why do you want to join Accenture?
Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I was interviewed before Mar 2024.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Difference between bank confirmation and bank statement
  • Q2. Tell me something about yourself
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

1 hour long, average questions, elimination round

Round 2 - Coding Test 

1 hour long, 2 questions, you will qualify if you can solve one

Round 3 - Technical 

(1 Question)

  • Q1. Resume based questions only
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I was interviewed in Jan 2025.

Round 1 - Group Discussion 

Request to provide an introduction using shorter sentences.

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected
Round 1 - HR 

(1 Question)

  • Q1. Asked about my prior work experience and reason to change.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I was interviewed before Feb 2024.

Round 1 - HR 

(1 Question)

  • Q1. Self introduction and experience details
Round 2 - One-on-one 

(1 Question)

  • Q1. Technical and professional questions
Contribute & help others!
anonymous
You can choose to be anonymous

KPMG India Interview FAQs

How many rounds are there in KPMG India Business Intelligence Analyst and Tableau Developer interview?
KPMG India interview process usually has 3 rounds. The most common rounds in the KPMG India interview process are Technical and Behavioral.
What are the top questions asked in KPMG India Business Intelligence Analyst and Tableau Developer interview?

Some of the top questions asked at the KPMG India Business Intelligence Analyst and Tableau Developer interview -

  1. Top and Bottom in one sh...read more
  2. Types of LOD and its use c...read more
  3. Usage of parameter and filt...read more

Recently Viewed

PHOTOS

InsuranceDekho

3 office photos

LIST OF COMPANIES

Credit Bajaar

Overview

INTERVIEWS

SSTECH SYSTEM PVT.LTD

No Interviews

JOBS

Axis Max Life Insurance

No Jobs

INTERVIEWS

SSTECH SYSTEM PVT.LTD

No Interviews

SALARIES

Axis Max Life Insurance

SALARIES

Axis Max Life Insurance

SALARIES

Axis Max Life Insurance

SALARIES

Axis Max Life Insurance

INTERVIEWS

Bix Bytes Solutions GmbH

No Interviews

Tell us how to improve this page.

KPMG India Business Intelligence Analyst and Tableau Developer Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.5k Interviews
Accenture Interview Questions
3.8
 • 8.2k Interviews
Capgemini Interview Questions
3.7
 • 4.8k Interviews
Deloitte Interview Questions
3.8
 • 2.9k Interviews
IBM Interview Questions
4.0
 • 2.4k Interviews
PwC Interview Questions
3.4
 • 1.4k Interviews
Ernst & Young Interview Questions
3.4
 • 1.1k Interviews
ZS Interview Questions
3.4
 • 484 Interviews
View all
Consultant
7.7k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Assistant Manager
6.9k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Consultant
4.6k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Analyst
3.5k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Manager
2.9k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare KPMG India with

Cognizant

3.7
Compare

PwC

3.4
Compare

Capgemini

3.7
Compare

Google

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