Power BI Quiz

What is the primary purpose of Power BI?

• Spreadsheet calculations

• Data visualization and analytics

• Word processing

• Graphic design

Which tool is more specialized for business intelligence and data visualization compared to Excel?

•  Excel

• PowerPoint

• Power BI

• Word

What is the primary function of Power Query in Power BI?

• Create charts

• Data transformation and preparation

• Write DAX formulas

• Share reports

In Power BI, what are relationships used for?

• Formatting visuals

• Connecting tables based on common fields

• Sorting data

• Creating calculated columns

How can you create a calculated column in Power BI?

• By using Power Query

• By using relationships

• By writing DAX formulas

• By using conditional formatting

What does DAX stand for in Power BI?

• Database Access Expressions

• Data Analysis Expressions

• Dynamic Axis Expressions

• • Data Analytics XML

How can you compare this year's sales to last year's in Power BI using DAX?

• Using Power Query

• Using relationships

• Using measures and DAX functions

• Using conditional formatting

Why is data visualization important in Power BI?

• To complicate data analysis

• To simplify data communication

• To reduce data accuracy

• To slow down report generation

What is the purpose of using slicers in Power BI?

• To create calculated columns

• To filter data interactively

• To write DAX formulas

• To connect tables

How can you share a Power BI report with others?

• Print and share a hard copy

• Save it as a PDF and email it

• Publish it to the Power BI service

• Export it to Excel