Power BI Desktop & PowerBI.com

Welcome to your free Power BI Desktop & PowerBI.com test

To join tables together:

Drag the matching field from one table to the other in Power Pivot

Drag the matching field from one table to the other in Power Query

Use the Power Query JOIN function

Use the Power Pivot CROSS-JOIN button

Which of the following is NOT a valid data source for Power BI to open automatically:

XLSM Macro-enabled Excel Workbook

PDF document

A table on an HTML web page

Microsoft Exchange

Which of the following statements about Power BI Desktop is FALSE?

Query Editor & the Relationships view in Power BI Desktop are based on the same technology as Power Query and Power Pivot in Excel

Power BI Desktop can handle larger volumes of data than the Excel (64 bit) data model

Power Pivot DAX expressions in Power BI Desktop are called Measures

Data tables can be manually entered in Power BI Desktop

To create drill down reports in Power BI Desktop:

The data needs to be exported to Excel

Click the “Add Drilldown” function for each measure

Add more than one field to the Axis section of a chart

Right-click on one part of a chart then choose the desired drilldown

To calculate the percentage of total sales that each product’s sales comprises, you could use the following 2 DAX expressions:

(i) Sales All Products = CALCULATE( SUM( [Sales] ), ALL( tblProducts[Products] ) ) (ii) Pct of Total = DIVIDE( SUM( [Sales] ) / [Sales All Products] ) * 100

(i) Sales All Products = CALCULATE( SUM( [Sales] ), ALLEXCEPT( tblProducts[Products] ) ) (ii) Pct of Total = DIVIDE( SUM( [Sales] ) , [Sales All Products] )

(i) Sales All Products = CALCULATE( SUM( [Sales] ), ALL( tblProducts[Products] ) ) (ii) Pct of Total = DIVIDE( SUM( [Sales] ) , [Sales All Products] )

(i) Sales All Products = CALCULATE( SUM( [Sales] ), ALL( tblProducts[Products] ) ) (ii) Pct of Total = DIVIDE( SUM( [Sales] ) , HASONEVALUE( [Sales All Products] ) )

Dashboards published to PowerBI.com:

Can only be shared with users who share the same domain

Can be shared with anyone by copying the page’s URL

Can be shared with anyone by clicking the Share button

Can be shared with anyone by going to File > Publish to Web

Which of the following statements is FALSE regarding publishing data on PowerBI.com:

Data can be refreshed at any time via a manual refresh

Data can be refreshed at scheduled times via a data gateway

Data can be refreshed via Power Update

Data can be refreshed via Power Query

To re-use a custom function in another Power Query custom function:

Invoke the function from the Advanced Editor

Copy and Paste the function from one Advanced Editor pane to the other Advanced Editor pane

Invoke the function from Power Pivot

Call the function via a macro

Which of the following statements is FALSE regarding maps:

Maps are only available in Power BI Desktop

Custom maps can be created e.g. to show a shopping mall floor plan

Maps can be used to show a concentration of data

Power BI Desktop can calculate map locations using latitude and longitude

10.

Which of the following statements is TRUE regarding Power BI Desktop drilldowns?

Measures can be used as drilldown categories

There is a maximum of 10 levels of drilldown available

Drilldown layers must be defined at the time of designing the report

Tooltips can only be displayed at the top drilldown level

Be sure to click the button below to check your answers! By checking your answers, you agree to receive communications from Access Analytic. You can unsubscribe at any time. Click here to review our Privacy Policy.

First Name

Time's up

How to Get your Free Power BI Account
Navigating the New Normal: Why CFOs are embracing Data…
Wordle for Power BI Fans
SquareWars – A Fun Way to Learn Excel 365
Build Wordle using Dynamic Array Functions
Power Query Challenge

Related Posts:

Share This Story, Choose Your Platform!