Chapter 1 of 4 - Getting Started with Power BI Flashcards

1
Q

What is Power BI and what does it enable you to do?

A

Power BI is a tool that lets you interactively explore data to gain insights. Power BI enables you to report insights effectively through easy-to-use customizable visualizations.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Why choose Power BI specifically?

A

Power BI is the leading BI tool. Over 97% of Fortune 500 companies use Power BI. In total, Power BI has over six million customers.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What are the two components that make up Power BI?

A

Desktop and Service

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is Power BI Desktop?

A

Power BI Desktop is a data analysis and report creation tool available on your local computer. It includes powerful features, like the Query Editor, and it’s free

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is Power BI Service?

A

Reports can be edited in Power BI service, but not to the full extent as desktop. Instead, the main purpose of Power BI service is to share and distribute reports.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What are the common uses of both Power BI Desktop and Service?

A

You will commonly use Power BI Desktop to create a report and Power BI service to share that report.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What does the paid version of Power BI (Power BI Pro) allow you to do?

A

Power BI Pro allows you to publish work on the Power BI cloud platform, including their mobile app. Power BI Pro also allows you to collaborate with other Power BI users.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

When you open Power BI Desktop, what are the 3 view options on the left hand side?

A

Report, Data and Model

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Which view if the default view?

A

Report

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What can you do in the report view?

A

You can create reports and visuals.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What can you do in the data view?

A

You can see the data used in the data model associated with your report.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What can you do in the model view?

A

You can see and manage the relationships among tables in your data model.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

When you are in the report view, what do you call the middle area where visualisations are created and arranged?

A

Canvas

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What does the filters pane allow you to do?

A

In the Filters pane you can filter data visualizations.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What does the visualisations pane allow you to do?

A

In the Visualizations pane you can add, change, or customize visualizations.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What does the fields pane do?

A

The Fields pane shows the available fields. You can drag these fields onto the canvas, the Filters pane, or the Visualizations pane to create or modify visualizations.

17
Q

What is the common database structure that Power BI is designed to work with?

A

Star schema

18
Q

What are the two things a star schema structure uses?

A

Fact and dimension tables

19
Q

What do key columns allow you to do?

A

Create a relationship between fact and dimension tables

20
Q
A