AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Clear (1)
KPMG India Business Intelligence Analyst and Tableau Developer Interview Questions, Process, and Tips
KPMG India Business Intelligence Analyst and Tableau Developer Interview Experiences
1 interview found
Business Intelligence Analyst and Tableau Developer Interview Questions & Answers
Bhavik Chawla
posted on 8 Oct 2024
I applied via LinkedIn and was interviewed in Sep 2024. There were 3 interview rounds.
(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
- 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...
- 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.
- Q4. Performance Optimization
(3 Questions)
- Q1. Project Overview and Size
- Q2. Performance Optimization
- Q3. Open for work in different technologies
(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...
- 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
Interview Preparation Tips
Interview questions from similar companies
Anonymous
Selected
I applied via Campus Placement and was interviewed before Dec 2022. There were 4 interview rounds.
It consists of the Quant, LRDI, Verbal reasoning & Email Writing.
Effect of Social Media and Internet in our Daily Life
(1 Question)
- Q1. Gone through my resume and ask the stuff from my resume itself, including my projects, certificates etc.
(1 Question)
- Q1. Do you know about EY? What is EY? How you can aligned yourself with EY
Interview Preparation Tips
Was normal SQL query
(2 Questions)
- Q1. Power bi questions
- Q2. SQL questions basic theoretical questions
I applied via Company Website and was interviewed in Sep 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Mostly regarding projects
- Q2. Questions realed to Azure services
(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
- 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
Interview Preparation Tips
- Azure
Selected
I was interviewed before Feb 2024.
One hour allocated for the non-technical test.
(1 Question)
- Q1. Why do you want to join Accenture?
Selected
I was interviewed before Mar 2024.
(2 Questions)
- Q1. Difference between bank confirmation and bank statement
- Q2. Tell me something about yourself
1 hour long, average questions, elimination round
1 hour long, 2 questions, you will qualify if you can solve one
(1 Question)
- Q1. Resume based questions only
PRIYANKA AGARWAL
I was interviewed in Jan 2025.
Request to provide an introduction using shorter sentences.
Selected
(1 Question)
- Q1. Asked about my prior work experience and reason to change.
Selected
I was interviewed before Feb 2024.
(1 Question)
- Q1. Self introduction and experience details
(1 Question)
- Q1. Technical and professional questions
KPMG India Interview FAQs
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 Interviews By Designations
- KPMG India Consultant Interview Questions
- KPMG India Analyst Interview Questions
- KPMG India Associate Consultant Interview Questions
- KPMG India Assistant Manager Interview Questions
- KPMG India Associate Interview Questions
- KPMG India Senior Consultant Interview Questions
- KPMG India Audit Associate Interview Questions
- KPMG India Manager Interview Questions
- Show more
Interview Questions for Popular Designations
- Tableau Developer Interview Questions
- Tableau Developer and Business Analyst Interview Questions
- Power BI and Tableau Developer Interview Questions
- Senior Tableau Developer Interview Questions
- Acquisition Manager Interview Questions
- Production Incharge Interview Questions
- Accounts Payable Specialist Interview Questions
- Junior Content Writer Interview Questions
- Show more
KPMG India Business Intelligence Analyst and Tableau Developer Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
|
Consultant
7.7k
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Assistant Manager
6.9k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Associate Consultant
4.6k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Analyst
3.5k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Manager
2.9k
salaries
| ₹0 L/yr - ₹0 L/yr |
Cognizant
PwC
Capgemini
- Home >
- Interviews >
- KPMG India Interview Questions >
- KPMG India Business Intelligence Analyst and Tableau Developer Interview Questions
