KPMG India Interview Questions, Process, and Tips

Q1. Question on sas sql and credit risk
Add your answer

Q1. Similar as round 1 but with manager
Add your answer

Q1. Partner round with technical sas questions
Add your answer

GD TOPIC - AI is Bane or Boon

Q1. What is internal Audit and tell me its complete process
Add your answer
Q2. What is Change Management and Access Control Management in details with example
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. Why you want to join kpmg?
Add your answer
Q3. What you understand about the job?
Add your answer
Q4. What is your work experience?
Add your answer
Q5. How will you see yourself within 5 years?
Add your answer

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
Add your answer
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...read more
Answered by AI
Add your answer
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
Add your answer
Q4. Performance Optimization
Add your answer

Q1. Project Overview and Size
Add your answer
Q2. Performance Optimization
Add your answer
Q3. Open for work in different technologies
Add your answer

Q1. Introduction and Role
Add your answer
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...read more
Answered by AI
Add your answer
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
Add your answer

Q1. What is Linear regression
Add your answer
Q2. What li list and tuple
Add your answer
Q3. Previous company project experience
Add your answer