Senior Business Intelligence Consultant Interview Questions and Answers

Bookmarks in Power BI are a way to save the current view of a report and return to it later.

• Bookmarks capture the current state of visuals, filters, and slicers in a report.

• They can be used to create custom navigation experiences for users.

• Bookmarks can also be used to create interactive storytelling experiences.

• They can be accessed and managed through the Bookmarks pane in Power BI Desktop.

• Bookmarks can be exported and imported between reports.

Parameters in Power BI are user-defined values that can be used to filter data in reports and dashboards.

• Parameters allow users to interact with the report and customize the data they see.

• They can be used to filter data, set default values, and control the behavior of visuals.

• Parameters can be created for various data types, such as text, numbers, dates, and lists.

• They can also be used in DAX expressions to create dynamic calculations.

• Examples of parameters include date range...read more

Calculate function is used to create new calculated columns or measures in Power BI.

• Allows users to create custom calculations based on existing data

• Can be used to create new columns or measures

• Syntax: CALCULATE(, )

• Example: CALCULATE(SUM(Sales[Revenue]), FILTER(Sales, Sales[Year] = 2021))

Storage mode in Power BI determines how data is stored and processed in memory.

• There are two storage modes in Power BI: Import and DirectQuery.

• Import mode loads data into Power BI's internal memory for faster processing.

• DirectQuery mode connects to the data source in real-time and queries the data on demand.

• Import mode is recommended for smaller datasets, while DirectQuery is better for larger datasets.

• Choosing the right storage mode depends on the size and complexity of the ...read more