Power BI Essentials

What does "BI" stand for in "Power BI"?

• Business Integration

• Basic Intelligence

• Business Intelligence

• Building Information

Which Power BI component is used primarily for creating and publishing reports and dashboards for others to view online?

• Power BI Desktop

• Power BI Service

• Power BI Mobile

• Power BI Report Builder

To support administration and security, Power BI is built on which Microsoft service?

• Microsoft SharePoint

• Microsoft .NET Framework

• Microsoft Dynamics 365

• Microsoft Azure

When you connect to a data source in Power BI Desktop and need to clean or transform the data, which tool do you use?

• Power Query Editor

• Excel

• Power Pivot

• Data view

You must manually write code (M-language) in Power Query Editor to transform data.

• True

• False

What is the typical first step when starting a new project in Power BI Desktop?

• Getting Data and connecting to a data source

• Creating a measure

• Publishing the report to the Power BI Service

• Formatting the report layout

Which view in Power BI Desktop is used to create and manage relationships between tables?

• Report view

• Table view

• Model view

• Dax query view

Creating relationships between tables (Model view) is essential for filtering data across different tables in a report?

• True

• False

Which pane is used to change the type of chart (from a Bar chart to a Line chart) & customize its appearance (colors)?

• Fields pane

• Visualisation pane

• Report view

• Filters pane

What type of visual should you use to display a single, key performance indicator (KPI)?

• Bar chart

• Line chart

• Card visual

• Pie chart