PowerBI Quiz

Power BI was first developed as an extension of...

• MS Word

• MS Excel

• MS Powerpoint

• All of the others

You plan to use Power BI Desktop to analyze sales data of your company.

You need to identify two types of data you will be able to use for creating bins that group the sales data.

Which two data types should you identify? Each correct answer presents a complete solution.

• Date/time

• Numeric

• Text

• True/False

What type of chart is it ?

• Tree map

• Donut chart

• Pie chart

What are the differences between Tableau and PowerBI?

You are analyzing query data by using Power Query Editor.

You need to ensure that the Column statistics are based on an analysis of the entire dataset.

What should you do?

• Change the query connection type from Import to DirectQuery.

• From the status bar, change profiling status to entire dataset.

• In Power Query Editor, enable column profiling from the View ribbon.

• Load the data into the data model.

  Next

In PowerBI you can import the following files.

• SQL files

• CSV files

• Excel file

• PDF files

PowerBI can be directly installed on a MacBook

• True

• False

In Power BI it is possible to...

• Work with SQL Data

• Work with CSV Data

• Create Reports

• Publish Reports

The "Applied Steps" panel helps you to keep tracking of any changes

• True

• False

What type of chart is this?

• A KPI

• A trend line

• An area chart

• A card