Connecting & Shaping Data with Power BI

Which tool in Power BI Desktop is used to connect and transform data?

• DAX Editor

• Power Query Editor

• Data View

• Report View

What is the first step when loading a new data source into Power BI?

• Create a visualization

• Apply filters

• Connect to the data source

• Write DAX measures

What does “shaping” data typically involve in Power BI?

• Designing dashboards

• Modifying the data structure and format

• Adding new tables

• Changing background colors

TRUE / FALSE: You can combine data from multiple sources in Power BI Desktop.

Which of the following actions is part of data transformation in Power BI?

• Creating slicers

• Changing column types

• Exporting dashboards

• Inserting animations

What does the “Applied Steps” pane in Power Query show?

• List of visualizations

• Order of DAX expressions

• All modifications made to the data

• Error logs

What is the use of the 'Remove Rows' feature in Power Query?

• To delete charts

• To eliminate unwanted rows like blanks or errors

• To hide fields

• To change data types

Which view allows you to see relationships between tables in Power BI?

• Report View

• Data View

• Model View (Relationships View)

• Query View

What is the purpose of promoting headers in Power Query?

• To add page titles

• To convert the first row of data into column names

• To create a summary

• To export tables

When merging queries, what is required between two tables?

• Same number of rows

• At least one matching column

• Same data types in all fields

• Same table name