NEW
Font size
WorksheetsModern Business Intelligence with Power BI
Total questions: 25
Worksheet time: 13mins
Where do you go in Power BI Desktop to clean, shape, and transform your raw data before loading it into the data model?
The Data View
The Report View
The Model View
Power Query Editor
What is the primary purpose of the 'Applied Steps' pane in the Power Query Editor?
To change the visual appearance of the columns and cells.
To list all available transformation functions.
To create new DAX measures and calculated columns.
To list all transformation actions applied to the data in order, acting as an audit trail.
Which data type in Power BI is best suited for columns representing money values that require precise decimal calculations and accuracy?
Whole Number
Text
Decimal Number
Fixed Decimal Number
When you use the 'Remove Other Columns' option in Power Query, what happens to the columns you had selected?
The selected columns are deleted, and all other unselected columns are kept.
The columns are merged into a single text column.
The selected columns are kept, and all other unselected columns are deleted.
A new query is created containing only the selected columns.
If you have a column named 'Region' that contains repetitive values, which operation should you perform in Power Query to ensure only the unique values are retained?
Pivot Column
Group By the 'Region' column.
Sort the column in ascending order.
Remove Duplicates on the 'Region' column.
In a Star Schema, which type of table holds descriptive attributes like Product Name, Customer Name, and Category?
Transaction Table
Fact Table
Bridge Table
Dimension Table
In a Star Schema, which type of table holds the business metrics or quantitative facts, such as Sales Amount or Quantity Sold?
Date Table
Fact Table
Attribute Table
Lookup Table
The preferred and most efficient type of relationship for a Power BI Star Schema model is:
Many-to-Many
One-to-One
One-to-Many
Many-to-One
What is the key identifier used to create a relationship between a Fact table and a Dimension table?
Primary Key in the Fact table.
Unique Index in the Dimension table.
Foreign Key (in the Fact table) and Primary Key (in the Dimension table).
Any column with the same name in both tables.
In Power BI Desktop, what is the dedicated view for visually organizing tables and defining how they relate to each other?
Report view
Data view
Power Query Editor
Model view (or Diagram view)
What is the primary function of a Measure in Power BI?
To store static text that is displayed on the report title.
To perform calculations on data and store the result as a new column in the table.
To link two tables together to establish a relationship.
To perform dynamic calculations (e.g., sums, averages) based on the visuals and filters applied.
A Calculated Column is computed and stored in the data model's memory at which time?
When the data model is refreshed.
Every time the user clicks a filter or slicer on the report page.
Only when the report is published to the Power BI Service.
In the Power Query Editor before the data is loaded.
When you drop a Measure into a card visual, the calculation is performed on the data that is currently visible or selected by filters. This specific filtering environment is known as:
Visual Context
Row Context
Filter Context
Aggregation Context
Which DAX function would you use to find the count of unique values in a customer ID column?
COUNT()
SUM()
DISTINCTCOUNT()
AVERAGE()
If you want to display the total number of records (rows) in a table, the best DAX function to use in a Measure is:
COUNT( 'Table'[Column] )
SUM( 'Table'[Column] )
COUNTROWS( 'Table Name' )
CALCULATE( COUNT() )
Which visual type is best suited for comparing numerical values across different, distinct categories (e.g., Patients by Department or Revenue per Hospital Branch)?
Pie Chart
Line Chart
Bar Chart or Column Chart
Table Visual
What is the primary function of a Slicer visual on a Power BI report page?
To perform advanced calculations using DAX.
To display the grand total of a single metric.
To allow users to interactively filter the data displayed in the other visuals on the page.
To show the historical trend of data over time.
When a user clicks on a segment of a Pie Chart, and another visual (like a Bar Chart) shows only the data corresponding to that selected segment, this interaction is called:
Highlighting
Drilling Down
Filtering
Formatting
To display a single, non-aggregated value, like a grand total, a key metric, or a calculation result prominently on the report, which visual type is most appropriate?
KPI visual
Line chart
Card visual
Gauges
To modify the title, change the color, or adjust the data label formatting of a selected visual, you would use which panel in Power BI Desktop?
The Fields pane
The Data pane
The Filter pane
The Format visual pane
What happens to a visual when another visual on the same page is selected, and they are set to Highlight interactions?
The visual is completely removed from the report page.
The visual disappears, and a blank space is left on the report.
The visual is completely filtered to show only the selected data points.
The visual remains visible, but only the data points related to the selection are emphasized, with others faded.
After creating a report in Power BI Desktop, what is the action you take to make it available for others to view online?
Email the .pbix file to the intended viewers.
Save the file to a shared network drive.
Create a new Measure in DAX to enable sharing.
Publish the report to the Power BI Service.
In the Power BI Service, what is the term for the cloud-based container where a team collaborates to organize and share related reports, dashboards, and datasets?
A Premium Capacity
A Dataflow
A Dashboard
Workspace
Which component in the Power BI Service manages the connection settings, source credentials, and refresh schedule for the data model?
The Report component
The Dashboard component
The Dataset component
The Gateway component
If you are a single user who only needs to connect to and explore data on your local machine and create reports for your own use (not sharing), what is the license requirement?
A Power BI Pro license is mandatory for all uses.
Only a paid Power BI Premium license will allow this.
Only the free Power BI Desktop application is needed, and no cloud license is required.
A cloud-based Power BI Free license is required for authentication.
