FREE Power BI Test

[insert_php]if($_GET[‘testname’] == ‘power-bi’) {print ‘

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

‘;} elseif ($_GET[‘testname’] == ‘power-query’) {print ‘

Welcome to your free Power Query & Power Pivot in Excel test

A Calendar table can be created from:

PowerBI.com

Power Query

Power Pivot

Either Power Query or Power Pivot

To reduce the risk of Excel crashing when using Power Query and Power Pivot:

Close all other applications

Upgrade to 64 bit Office

Add extra memory

All of the above

To retain the formatting you apply in an Excel Pivot Table:

Use Conditional Formatting to automatically re-format cells

On the Analyze Pivot Table Ribbon, check the “Preserve cell formatting on update” checkbox

Under Pivot Table Options, check the “Preserve cell formatting on update” checkbox

Check the “Retain cell formatting” button within Power Query

Selecting the “Only Create Connection” option when creating a data connection to a table will:

Only load the table’s data into the data model

Create a connection to the table, but do nothing else

Only load the table’s data into the spreadsheet

Create an encrypted connection to the target data source

To calculate a year-to-date Sales value from your data, you could use the following DAX expression:

=TOTALYTD( [Sales], tblCalendar[Date] )

=SUM( [Sales] * 365)

=SUM( [Sales], YTD)

=SUMYTD( [Sales], tblCalendar[Date] )

The data in the Excel data model is stored:

On hidden Excel sheets

In the Power BI data model, within Excel

On Microsoft Azure servers

All of the above

The values in an Excel Pivot Table are calculated by:

Applying a series of filters that depend on the row and column the value sits in

Applying a series of iterative calculations to derive each value

Applying CUBE formulas to calculate each value

Applying GETPIVOTDATA formulas to calculate each value

To transfer parameters from Excel into Power Query:

Use a Range Name in Excel

Use a Named Query

Use a custom function

Use the Power Query “Connect Parameter” function

To create an Excel CUBEVALUE formula:

Click inside a Pivot Table then go to “OLAP Tools” > “Convert to Formulas”

Type the CUBE formula directly into any blank Excel cell

Use Excel’s Function Wizard

Any of the above

10.

To comment out a line of code in the Power Query Advanced Editor:

Use #

Use \\

Use /*

Use //

First Name

Time's up

‘;} else { ?>

How well do you know Power BI?

Take a challenging Power BI test and find out! For your own benefit, try to complete the exam with Power BI and Excel closed (including the online help).

At the end, you’ll also get a beautiful certificate you can print! Perfect for employment competency tests!

Looking for more in-depth training? Visit our other training courses, online financial modelling training, or online Excel training.

Choose your test:

Power BI Desktop
Power Query & Power Pivot