wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Power BI Quiz Pre

Total questions: 10

Worksheet time: 6mins

Name
Class
Date
1.

What is the right sequence of the tasks of a data analyst?

a)

Model – Prepare – Visualize – Analyze – Manage

b)

Prepare – Model – Visualize – Analyze – Manage

c)

Manage – Prepare – Model – Visualize – Analyze

d)

Visualize – Prepare – Model –Analyze – Manage

2.

1.       Which among the following Power BI tool is used for the development of data models and reports?

a)

Power BI Service

b)

Power BI Desktop

c)

  Power BI Mobile

d)

Power BI Report Builder

3.

  An analyst has the yearly sales data for the years 2021, 2022 and 2023 as three different tables. In order to consolidate these into a single table, which among the following functions should be used in Power Query Editor?

a)

Merge

b)

Append

c)

Replace

d)

Fill

4.

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

a)

Excel workbook.

b)

SQL Server database.

c)

Oracle Database

d)

Adobe Photoshop

5.

You have 3 categories of Products. If you want to see the percentage share of sales of these categories. Which is the visual you will choose?

a)

Pie

b)

Bar

c)

Line

d)

Tree Map

6.

A Power BI analyst wants to visualize the profit across 12 months in a year. Which among the following is the best visualization for this comparison?

a)

Pie Chart

b)

Funnel Chart

c)

Line Chart

d)

Table

7.

In which tool inside Power BI do you transform the data?

a)

Power Query Editor

b)

Power Pivot

c)

Model View

d)

Table View

8.

Which among the below combination is false?

a)

Data View – Transforming Data

b)

Report View – Creating Reports

c)

Model View – Creating Data Model

d)

Table View – Viewing Tables

9.

What is the common flow of activity in Power BI?

a)

Create report in the Power BI service, share it to Power BI Desktop, and interact with it in Power BI Mobile.

b)

Create reports in Power BI Desktop, share it Power BI Service and view reports in Power BI Service and Mobile.

c)

Share the data model to Power BI service and create the reports on the Power BI Mobile

d)

Create report in Power BI Mobile and Share it Power BI Desktop

10.

1.       Which among the data analyst task will impact the report performance directly?

a)

Visualize

b)

Manage

c)

Model

d)

Prepare