Add office photos
Filter interviews by
KPMG India Power BI Developer Interview Questions, Process, and Tips
KPMG India Power BI Developer Interview Experiences
1 interview found
Anonymous
Interview Questionnaire
9 Questions
- Q1. Types of joins in power Bi & SQL and how it works?
- Ans.
There are four types of joins in Power BI and SQL: inner join, left join, right join, and full outer join.
Inner join returns only the matching records from both tables.
Left join returns all records from the left table and the matching records from the right table.
Right join returns all records from the right table and the matching records from the left table.
Full outer join returns all records when there is a match in
- Q2. Types of filters in power Bi and difference?
- Ans.
There are three types of filters in Power BI: visual-level filters, page-level filters, and report-level filters.
Visual-level filters apply to a specific visual or chart in a report.
Page-level filters apply to all visuals on a specific page in a report.
Report-level filters apply to all visuals and pages in a report.
Filters can be applied to columns, measures, or hierarchies.
Filters can be used to include or exclude spe...
- Q3. What is Book marks in PBI?
- Ans.
Bookmarks in Power BI are a feature that allows users to save and organize specific views of a report or dashboard.
Bookmarks help users to easily navigate and switch between different report views.
They can be used to save filters, slicer selections, visualizations, and other report settings.
Bookmarks can be created manually or through Power BI's recording feature.
They can be accessed and managed through the Bookmarks p...
- Q4. Difference between Sum and Sumx? And also Summerize vs Summerized column?
- Ans.
Sum calculates the sum of a column, while Sumx calculates the sum of an expression. Summarize creates a new table with summarized data, while Summarized column adds a calculated column to an existing table.
Sum is used to calculate the sum of a column in a table.
Sumx is used to calculate the sum of an expression over a table or a group of rows.
Summarize creates a new table by grouping and summarizing data from an existi...
- Q5. How to implement the row level security?
- Ans.
Row level security in Power BI allows you to restrict data access based on user roles or filters.
Row level security can be implemented by defining roles and filters in Power BI Desktop.
Roles can be created and assigned to users or groups.
Filters can be applied to tables or columns to limit data visibility.
Row level security can be based on user attributes, such as department or region.
Dynamic row level security can be ...
- Q6. Difference between slicer and filter?
- Ans.
Slicers and filters are both used to control data visibility in Power BI, but slicers are visual elements while filters can be applied programmatically.
Slicers are visual controls that allow users to select values from a predefined list, which filters the data accordingly.
Filters can be applied programmatically using DAX formulas or Power Query M language.
Slicers are typically used for interactive data exploration and ...
- Q7. Difference between calculate and calculate table ?
- Ans.
Calculate is used to modify the filter context of a single expression, while Calculate Table is used to modify the filter context of an entire table.
Calculate is used to modify the filter context of a single expression.
Calculate Table is used to modify the filter context of an entire table.
Calculate can be used to create new measures or modify existing ones.
Calculate Table can be used to create new tables or modify exi...
- Q8. Recently faced challenges in power Bi?
- Ans.
Yes
Dealing with complex data transformations
Handling large datasets and optimizing performance
Creating dynamic and interactive visualizations
Integrating Power BI with other data sources
Implementing security and access controls
- Q9. Which types of reports developed?
- Ans.
Various types of reports can be developed in Power BI.
Power BI allows the development of interactive dashboards.
Tabular reports can be created to display data in a structured format.
Matrix reports are useful for summarizing data in a grid-like format.
Charts and graphs can be used to visualize data trends and patterns.
KPI reports can be developed to track key performance indicators.
Paginated reports are suitable for pri...
Skills evaluated in this interview
Power BI Developer Jobs at KPMG India
Interview questions from similar companies
(3 Questions)
- Q1. Scenario based on filter table
- Q2. Find rolling total without reset
- Ans.
Calculate rolling total without resetting at specified interval
Use DAX formula with functions like CALCULATE, FILTER, and EARLIER
Create a measure that calculates the running total based on the current and previous rows
Consider using variables to store intermediate results for efficiency
- Q3. Shift one cell Down in table using dax
- Ans.
Use DAX function to shift one cell down in a table
Use the LAG function in DAX to shift values down in a column
Specify the number of rows to shift as a parameter in the LAG function
Example: LAG([Column], 1) will shift values in 'Column' down by one row
Skills evaluated in this interview
I applied via Walk-in and was interviewed in Jul 2024. There were 4 interview rounds.
(1 Question)
- Q1. Online technical round for 20 mins MCQs (Moderate level)
Power BI Report Development - Hands on for 1 hour (Intermediate to Advance level)
(1 Question)
- Q1. Technical F2F for 30-40 mins (Intermediate level)
(1 Question)
- Q1. Technical F2F for 30 mins (Advance level)
Interview Preparation Tips
After all the rounds I received a shortlisted email from HR but after that they said that my application is on Hold.
It was a good experience overall.
Manjushree K
I was interviewed in Oct 2024.
(2 Questions)
- Q1. What is the need of inactive relationship?
- Q2. Explain various roles in power BI service
I applied via Company Website and was interviewed in Sep 2024. There was 1 interview round.
(3 Questions)
- Q1. What is calculated col and measure
- Ans.
Calculated columns are columns created in Power BI by using DAX formulas, while measures are calculations based on the data model.
Calculated columns are static and stored in the data model, while measures are dynamic and calculated on the fly.
Calculated columns are used for adding new data to a table, while measures are used for aggregating data or performing calculations.
Examples of calculated columns include adding a...
- Q2. What is numerical range parameter
- Ans.
Numerical range parameter is a parameter that defines a range of numerical values for a specific variable or function.
It is used to specify a range of numerical values that a parameter can take.
It helps in filtering data based on a specific numerical range.
For example, a numerical range parameter can be used to filter sales data for products with prices between $50 and $100.
- Q3. What is field parameter
- Ans.
A field parameter is a variable that is used to pass values to a function or method.
Field parameters are used to customize the behavior of functions or methods.
They can be used to filter, sort, or group data in Power BI reports.
Examples include filtering data based on a specific date range or sorting data by revenue.
Interview Preparation Tips
Skills evaluated in this interview
I applied via Walk-in and was interviewed in Jul 2024. There were 4 interview rounds.
(1 Question)
- Q1. Online technical round for 20 mins MCQs (Moderate level)
Power BI Report Development - Hands on for 1 hour (Intermediate to Advance level)
(1 Question)
- Q1. Technical F2F for 30-40 mins (Intermediate level)
(1 Question)
- Q1. Technical F2F for 30 mins (Advance level)
Interview Preparation Tips
After all the rounds I received a shortlisted email from HR but after that they said that my application is on Hold.
It was a good experience overall.
(1 Question)
- Q1. Sumx difference between sum
- Ans.
SUMX calculates the total of an expression evaluated for each row in a table, while SUM calculates the total of a column.
SUMX is an iterator function in DAX that allows you to iterate over a table and perform calculations on each row.
SUMX is commonly used to calculate a total based on a formula or expression applied to each row.
SUM, on the other hand, simply calculates the total of a column without any iteration over r...
Selected
I applied via LinkedIn and was interviewed in Apr 2024. There was 1 interview round.
(2 Questions)
- Q1. DAX ? WHAT ARE TIME INTELLIGENCE FNCS
- Ans.
Time intelligence functions in DAX are used to perform calculations based on dates and times.
Time intelligence functions help in comparing data over different time periods.
Functions like TOTALYTD, SAMEPERIODLASTYEAR, and DATESBETWEEN are commonly used for time intelligence.
They can be used to calculate year-to-date totals, compare values with previous periods, and more.
- Q2. FOCUS ON SQL AND DAX
Interview Preparation Tips
I was interviewed in Oct 2024.
(2 Questions)
- Q1. What is the need of inactive relationship?
- Q2. Explain various roles in power BI service
(2 Questions)
- Q1. Introduction questions
- Q2. Technical questions
(2 Questions)
- Q1. Introduction questions
- Q2. Salary description
KPMG India Interview FAQs
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
- Senior Power BI Developer Interview Questions
- Power Programmer Interview Questions
- Power Plant Engineer Interview Questions
- MSBI and Power BI Developer Interview Questions
- Power Electronics Engineer Interview Questions
- Backup Administrator Interview Questions
- Power Apps Developer Interview Questions
- Senior Infra Developer Interview Questions
- Show more
Power BI Developer Interview Questions from Similar Companies
Fast track your campus placements
KPMG India Power BI Developer Reviews and Ratings
based on 2 reviews
Rating in categories
|
Consultant
7.5k
salaries
|  ₹6.9 L/yr - ₹27 L/yr |
|
Assistant Manager
6.8k
salaries
| ₹10.5 L/yr - ₹32 L/yr |
|
Associate Consultant
4.5k
salaries
| ₹4.4 L/yr - ₹15.5 L/yr |
|
Analyst
3.4k
salaries
| ₹1 L/yr - ₹10 L/yr |
|
Manager
2.8k
salaries
| ₹12 L/yr - ₹46 L/yr |
Cognizant
PwC
Capgemini
Calculate your in-hand salary
- Home >
- Interviews >
- KPMG India Interview Questions >
- KPMG India Power BI Developer Interview Questions
