wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Introduction Power BI

Total questions: 11

Worksheet time: 8mins

Name
Class
Date
1.

Which of the following data sources is not supported by Power BI Desktop?

(Select one or more correct answers)

a)

R Script

b)

SQL Server Database

c)

Web

d)

Facebook

e)

None (all of them are supported)

2.

If you want to create a Dashboard, which of the following applications should you use?

a)

Power BI Desktop

b)

Power BI Service

c)

Power Query

d)

Microsoft Azure

3.

"__________ is a formula expression language used in Analysis Services, Power BI, and Power Pivot in Excel."

a)

M Formula Language

b)

Visual Basic

c)

Data Analysis Expressions (DAX)

d)

Structured query language

4.

What is the primary benefit of using visualizations such as line charts, bar charts, and column charts in Power BI?

a)

They require fewer resources than more complex visualizations.

b)

Users are used to them

c)

They are simple

d)

You can visualize trends, identify outliers, and have a better understanding of the data.

5.

What is the name of the following view?

a)

Report View

b)

Connection View

c)

Model View

d)

Data View

6.

What type of relationship exists between these tables?

a)

One to One

b)

One to Many

c)

Many to Many

d)
  • * to *

7.

If the company wants a visualization that is useful in displaying a series of positive and negative changes, from one value to another. Which visualization you would recommend?

a)

Bar Chart

b)

Waterfall Chart

c)

Line Chart

d)

Scatter Chart

8.

What type of measure is the following DAX expression: SALES = SUM(ReportSales[Sales])SALES\ =\ SUM\left(ReportSales\left[Sales\right]\right)

a)

DAX Formula

b)

Explicit Measure

c)

Implicit Measure

d)

Time Intelligence

9.

If you want to show trends in data over time, what visualization should you use?

a)

Ribbon chart

b)

Bar chart

c)

Scatter plot

d)

Line Graph

10.

Which of the following are not examples or cardinality?

a)

One to Many

b)

North to South

c)

Dimension Table

d)

Many to Many

11.

What does this image represent?

a)

A chart of the sales of a company

b)

A pie chart

c)

A pyramid

d)

The participation of a company in a specific segment or market.