Soalan Aneka Pilihan Power BI

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