Scenario Based Questions

on
Power Bi

Power Query
A) What are the different types of modes in Power BI?

Scenario: You are working on a Power BI project where you need to connect to multiple data sources.
Explain the different modes available in Power BI and how you would decide which mode to use for
each data source.

B) What are the different types of Merge?

Scenario: You have two tables, Sales and Customers, and you need to combine them to create a
comprehensive report. Describe the different types of merge operations available in Power Query and
which one you would use in this scenario.

C) What is append and the criteria?

Scenario: You have monthly sales data stored in separate CSV files for each month. Explain how you
would use the append operation in Power Query to combine these files into a single table.

D) Parameters in Power Query

Scenario: You need to create a report that allows users to filter data based on a specific date range.
Describe how you would use parameters in Power Query to achieve this.

E) How to check column quality and profile for Every Record?

Scenario: You suspect there are data quality issues in your dataset. Explain how you would use Power
Query to check the column quality and profile for every record in your dataset.

F) Fuzzy match.

Scenario: You have two datasets with customer names that may have slight variations (e.g., "John
Doe" vs. "Jon Doe"). Describe how you would use the fuzzy match feature in Power Query to match
these records.

G) What is the M query?

H) Efficient way to change the data source from CSV to SQL

Scenario: Your data source has changed from CSV files to a SQL database. Describe the most
efficient way to update your Power Query queries to reflect this change.

Power Pivot
A) Types of cardinality

Scenario: You are designing a data model and need to establish relationships between tables. Explain
the different types of cardinality and provide an example of when you would use each type.

B) When you should use a Bi-directional filter flow? How to manage without opening the Bi-
directional filter flow?

Scenario: You have a complex data model with multiple relationships. Describe a scenario where you
would use a bi-directional filter flow and how you would manage it without opening the bi-directional
filter flow.

C) Difference between Star, Snowflake, and Galaxy Schema

Scenario: You are tasked with designing a data warehouse for a retail company. Explain the differences
between Star, Snowflake, and Galaxy schemas and which one you would recommend for this project.

D) Why do you need a disconnected table?

Scenario: You need to create a report that includes a custom calculation not directly related to the main
data model. Explain why you would use a disconnected table in this scenario.

E) Why do you need an inactive relationship?

F) Could you explain a scenario in which you would need to use 1-to-1 cardinality?

Scenario: You are designing a data model for a small business. Explain a scenario where you would
use 1-to-1 cardinality and why it is necessary.

G) Types of dimension tables.

Scenario: You are building a data model for a sales report. Describe the different types of dimension
tables and how you would use them in your model.

H) How do you manage SCD?

Scenario: You need to track changes in customer information over time. Explain how you would
manage Slowly Changing Dimensions (SCD) in Power BI.

Power BI Reports
A) Different types of filters?

Scenario: You need to create a report that allows users to filter data by region, product, and date.
Explain the different types of filters available in Power BI and how you would use them in this report.

B) Bookmarks

Scenario: You want to create a report with multiple views that users can switch between easily.
Describe how you would use bookmarks to achieve this.

C) Field parameters

Scenario: You need to create a dynamic report that allows users to select different measures to display.
Explain how you would use field parameters to accomplish this.
D) Custom tooltips

Scenario: You want to provide additional context to users when they hover over data points in a report.
Describe how you would create custom tooltips in Power BI.

E) Drill Down

Scenario: You have a hierarchical dataset and want to allow users to explore data at different levels of
detail. Explain how you would implement drill down functionality in your report.

F) Drill Through

Scenario: You need to create a report that allows users to navigate to a detailed view of the data.
Describe how you would use drill through functionality to achieve this.

G) Questions related to charts and graphs and when to use what.

Scenario: You need to present sales data in a way that highlights trends and comparisons. Explain
which charts and graphs you would use and why.

H) Difference between Report and Dashboard.

Scenario: Your manager asks you to create a Power BI dashboard. Explain the difference between a
report and a dashboard and how you would approach creating each.

I) Edit Interaction

Scenario: You have multiple visuals on a report page and need to control how they interact with each
other. Describe how you would use the edit interaction feature to manage this.
Power BI Service
A) How do schedule a refresh

Scenario: You need to ensure that your Power BI report is updated with the latest data every morning.
Explain how you would schedule a refresh in Power BI Service.

B) RLS and Dynamic RLS

Scenario: You need to restrict data access based on user roles. Describe how you would implement
Row-Level Security (RLS) and Dynamic RLS in Power BI.

C) Difference between My Workspace vs. App Workspace

Scenario: You are collaborating with a team on a Power BI project. Explain the difference between My
Workspace and App Workspace and how you would use each.

D) Pin to the dashboard

Scenario: You want to highlight key metrics on a dashboard for quick access. Describe how you would
pin visuals from a report to a dashboard in Power BI Service.