wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Power BI Pre-Test

Total questions: 15

Worksheet time: 7mins

Name
Class
Date
1.

Referring to the picture given, what is the name of this view mode in Power BI Desktop?

a)

Dashboard view

b)

Report view

c)

Charts view

d)

Analytics view

2.

The selected view mode in the given picture is called "Model view". What is the main activity involved in this view mode?

a)

Get data from multiple sources

b)

Data massaging to fit analysis purpose

c)

Define relationships between tables

d)

Tables arrangement based on logical needs

3.

What is the meaning of the symbol shown beside the "EDU_ID"?

a)

Data error existed in the column

b)

Invalid column name

c)

Column is imported from external data sources

d)

The column is a Calculated Column

4.

What is the meaning of the symbol shown beside the "BAD HIRES"?

a)

The column is a Measure

b)

Calculator

c)

Invalid column name

d)

Invalid data

5.

Which of the following is TRUE ?

a)

With FREE subscription, you can share your report to all users

b)

DAX is a formula used in Power BI

c)

Power BI Desktop is a software on the cloud

d)

You cannot use logical expression in DAX

6.

What are the three Power BI applications designed to let people create, share, and consume business insights in the way that serves them, or their role, most effectively?

a)

Desktop, service, and Mobile apps.

b)

Tiles, visualizations, and dashboards.

c)

Reports, dashboards, and tiles.

7.

What is one method for creating a visual?

a)

Drag a field from the Data Pane onto the Report view canvas.

b)

Drag a field from the Data Pane onto the Visualizations Pane.

c)

Drag a field from the Data Pane onto the Model view canvas.

8.

It is the process of analyzing and defining all the different data your business collects and produces, as well as the relationships between those bits of data.

a)

Data Ingestion

b)

Data Modeling

c)

Data Warehousing

d)

Data Transformation

9.

IDs or other key values that are used to uniquely identify instances of each entity

a)

Foreign keys

b)

Fact Tables

c)

Primary keys

d)

Dimension Tables

10.

Refer to the given picture. What is the name of this visual?

a)

Column chart

b)

Donut chart

c)

Filter

d)

Slicer

11.

What is the name of the highlighted function in the given picture?

a)

Focus mode

b)

Fit to screen

c)

Enlarge

d)

Maximize

12.

What happens to your visuals if you activate this mode?

a)

Cross filter between visuals

b)

Cross highlight between visuals

c)

No interactions between visuals

d)

Nothing happens

13.

What happens to your visuals if you activate this mode?

a)

Cross filter between visuals

b)

Cross highlight between visuals

c)

No interactions between visuals

d)

Nothing happens

14.

What happens to your visuals if you activate this mode?

a)

Cross filter between visuals

b)

Cross highlight between visuals

c)

No interactions between visuals

d)

Nothing happens

15.

In Power BI, what is this visual called?

a)

Power Meter

b)

KPI

c)

Thermometer

d)

Gauge