KPMG India Power BI Developer Interview Questions, Process, and Tips for Experienced

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

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...read more

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...read more

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...read more

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 ...read more

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 ...read more

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...read more

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

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...read more