NEW
Font size
WorksheetsPower BI : Pre-Test
Total questions: 10
Worksheet time: 5mins
What is the main function of Power BI Desktop?
To type SQL code
To create reports, data models, and interactive visualizations
To design websites
To manage users and security
In Power BI, what does 'Query Editor' mean?
A place to design charts
An area to build relationships between tables
A tool to shape and clean data before modeling
A special function to create slicers
The type of relationship commonly used between two tables in Power BI is:
One-to-One
Many-to-Many
One-to-Many
Cross-Join
The DAX function is used in Power BI to:
Import data from the web
Build 3D visuals
Write formulas and custom calculations in the data model
Change the theme colors of Power BI
The 'Measure' function in DAX is typically used to:
Add new columns to the original data
Determine relationships between two tables
Perform calculations like sum, average, maximum, etc.
Delete unnecessary data
What is the best visual to show time trends in Power BI?
Pie chart
Card visual
Line chart
Matrix
What is the role of 'Slicer' in Power BI reports?
Change file format
Filter report content interactively
Add new data to the model
Analyze table relationships
What is meant by 'Data Model' in Power BI?
A chart showing sales results
The structure of relationships between tables and formulas in reports
A visual diagram for users
A report filtering function
In Power BI, how can users view the raw data used in a visual?
Right-click and select 'Show Table'
Click the 'Drillthrough' icon
Right-click and select 'Show as a Table'
Open in Excel
What are the advantages of using a star schema model in Power BI?
Easier to manage and high performance
Only suitable for small data
Does not require DAX
Supports multiple Excel files simultaneously
