Mastering Power BI Essentials

What is the primary purpose of data modeling in Power BI?

• To improve the performance of reports by reducing file size

• To create a collection of tables and relationships to simplify report design

• To increase the complexity of reports for better detail

• To convert raw data into visualizations directly

Which of the following is NOT a type of visualization in Power BI?

• Pie chart

• Histogram

• Radar chart

• Gantt chart

In Power Query, what is the purpose of the 'Merge Queries' feature?

• To combine data from different sources

• To duplicate existing queries

• To filter out unwanted data

• To create a backup of your queries

Which DAX function in Power BI is used to calculate the sum of a column in a table?

• AVERAGE

• COUNT

• SUM

• TOTAL

What is the benefit of using slicers in a Power BI report?

• To add more data to the report

• To allow users to filter the data displayed in the report

• To slice the data into more columns

• To create a pie chart

Which of the following is NOT a best practice for Power BI dashboard design?

• Use a consistent color scheme

• Overload the dashboard with visuals

• Keep it simple and focused on key metrics

• Use high contrast for better readability

In Power BI, what is a 'Calculated Column'?

• A column that is imported from the data source

• A column that is manually entered by the user

• A column that is created using DAX formulas based on other columns in the model

• A column that is used to calculate the total number of rows in a table

What is the purpose of the 'Relationships' view in Power BI Desktop?

• To set up connections between different data sources

• To manage the relationships between tables in the data model

• To view the relationships between different visualizations

• To create a hierarchy of data fields

Which of the following is a key feature of Power Query in Power BI?

• Creating complex DAX formulas

• Designing interactive dashboards

• Transforming and cleaning data

• Assigning user roles and permissions

What is the main function of the 'Data' view in Power BI Desktop?

• To visualize data in the form of charts and graphs

• To write and test DAX formulas

• To import new data into the model

• To view and edit the data in each table