Power BI Training - 1.0

Which step in creating a report in Power BI is considered the most important because it directly affects the report?

• Discovery

• Modeling

• Visualization

• Sharing

In order to view a report or report in Power BI Mobile, it is required that the report first be published in

• Excel

• Power Point

• Power BI Desktop

• Power BI Service

Which of the following is NOT a business analytics tool?

• Data Mart

• Qlik

• Power BI

• Tableau

Which two types of fields can DAX be used to create?

• Calculated Column & Calculated Fields

• Calculated Fields & Measures

• Measures & Calculated Items

• Calculated Column & Measures

Which of the following formulas would make the most sense as a calculated column?

• =SUM(Sales[quantity])

• =AVERAGE(Products[RetailsPrice])

• =DISTINCOUNT(Customer[CustomerName])

• =Products[RetailsPrices] * 0.75

When would it be most appropriate to use the && operator?

• To concatenate two text strings

• To create an AND condition between two expressions

• To create an AND condition between more than two expressions

• To concatenate more than two text strings

What is the purpose of the following function:

=CALCULATE([Profit],Territories[Country]="UAE")

• Calculate a measure named "Profit" across the entire Territories table

• Sums the "Profit" column for rows where Country = "UAE"

• Creates a new column named "Profit" which is calculated for all rows where country = "UAE"

• Evaluates the "Profits" measure for rows where Country = "UAE" in the Territories table

Which term best describes the process of transforming a table from a horizontal orientation to a vertical orientation by turning distinct column values into rows?

• Transposing

• Unpivoting

• Pivoting

• Hinging