FREE Power BI Test

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


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


1)

To join tables together:



2)

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



3)

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



4)

To create drill down reports in Power BI Desktop:



5)

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



6)

Dashboards published to PowerBI.com:



7)

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



8)

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



9)

Which of the following statements is FALSE regarding maps:



10)

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




Be sure to click the button below to check your answers!




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

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


1)

A Calendar table can be created from:



2)

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



3)

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



4)

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



5)

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



6)

The data in the Excel data model is stored:



7)

The values in an Excel Pivot Table are calculated by:



8)

To transfer parameters from Excel into Power Query:



9)

To create an Excel CUBEVALUE formula:



10)

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




Be sure to click the button below to check your answers




‘;} 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: