What is the main role of Power BI?

• Create dynamic websites
• Clean data only
• Prepare, explore, visualize, and share data
• Replace Excel for all uses

Which built-in Power BI tool allows data cleaning and transformation?

• Power Query
• Power Pivot
• Excel Connect
• Query Wizard

Which function is used to combine two tables by rows in Power BI?

• Merge
• Append
• Pivot
• Join

Which Power BI visualization is most appropriate for time variation?

• Treemap
• Bar chart
• Pie chart
• Line chart

Why use slicers in a Power BI dashboard?

• To add graphic styles
• To let the user filter data dynamically
• To export visuals
• To speed up loading

Which feature allows you to explore a chart by different hierarchy levels?

• Split
• Drill-down
• Tooltips
• Bookmarks

Which element allows saving a filtered view in Power BI?

• Bookmark
• Theme
• Matrix
• Slicer

Which chart type is useful to visually compare a hierarchy?

• Line chart
• Table
• Treemap
• Pie chart

When should the ‘Merge’ feature in Power BI be used?

• When changing data types
• When displaying geographic maps
• When joining two tables by a common key
• When creating a KPI

What is the benefit of creating a relational model in Power BI?

• Reduce the number of displayed rows
• Improve visual style
• Avoid data duplication and simplify multi-table analysis
• Increase file sizes