Power BI part 2 Flashcards

1
Q

How can Power BI users collaborate on content?

A

Using shared workspaces.

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

What does the “Transform Data” button in Power BI Desktop do?

A

Opens Power Query Editor.

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

What are the benefits of using a semantic model in Power BI?

A

Ensures consistency.

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

How does Power BI integrate with Excel?

A

Imports data and uses Power Query.

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

What is the purpose of Power BI Template Apps?

A

Provide prebuilt apps for quick deployment.

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

What are the two viewing modes for reports in Power BI?

A

Reading and Editing views.

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

How do notifications work in Power BI Insights?

A

Alert users to trends, anomalies, or KPI updates.

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

What is the role of tiles on a Power BI dashboard?

A

Display individual visualizations.

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

What does pinning a report visual to a dashboard achieve?

A

Adds visual to a dashboard.

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

How can Power BI help with resource allocation in a business?

A

Analyzes trends and makes predictions.

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

What is the Power BI Report Server?

A

On-premises solution for sharing and managing Power BI reports.

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

What are Power BI Workspaces used for?

A

Collaborating on reports and dashboards.

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

What is the Power BI Service interface?

A

Web-based interface for creating, sharing, and managing reports.

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

What is DAX in Power BI?

A

A formula language used for calculations.

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

How does Power BI help in decision making?

A

Provides insights through data analysis.

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

What is Power BI’s Query Editor used for?

A

Modifying and shaping data.

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

What are Power BI visuals?

A

Graphical representations of data.

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

Can Power BI integrate with other Microsoft tools?

A

Yes, it integrates with tools like Excel and SharePoint.

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

What is Power BI Premium?

A

A paid version with more features and better performance.

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

What is a dataflow in Power BI?

A

A collection of data transformation steps.

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

What is Power BI’s DirectQuery mode?

A

Real-time querying without importing data.

22
Q

What is the difference between Power BI Desktop and Power BI Service?

A

Desktop is for creating reports, Service is for sharing and collaborating.

23
Q

What does “Pin to Dashboard” mean in Power BI?

A

Adds a visual to a dashboard.

24
Q

What are the advantages of using Power BI?

A

Interactive reports, easy data integration, cloud-based sharing.

25
Q

What is a Power BI Embedded solution?

A

Embedding Power BI reports in apps.

26
Q

What is Power BI Q&A?

A

Natural language query tool for reports.

27
Q

What is the purpose of the Power BI Mobile app?

A

Access reports and dashboards on the go.

28
Q

What is Power BI’s Visualizations pane?

A

A pane where you choose the type of visual for your data.

29
Q

How does Power BI connect to databases?

A

Using connectors and queries.

30
Q

What is a Power BI workspace used for?

A

Organizing and sharing content within a team.

31
Q

What is a dataset in Power BI?

A

A collection of data used to create reports and dashboards.

32
Q

How do you refresh data in Power BI?

A

Through scheduled or manual data refresh options.

33
Q

What is a live connection in Power BI?

A

Real-time data access without importing data.

34
Q

What is the “Publish” button in Power BI Desktop?

A

It uploads reports to Power BI Service.

35
Q

What is a KPI visualization in Power BI?

A

A visual that tracks key performance indicators.

36
Q

What is the role of the Power BI administrator?

A

Manages users, permissions, and workspace settings.

37
Q

What are Power BI slicers?

A

Filters for report visuals.

38
Q

How can Power BI handle large datasets?

A

By optimizing performance and using aggregation.

39
Q

What type of chart is best used to show the relationship of parts to a whole?

A

Pie chart

40
Q

In Power BI, what aggregation should be used for text fields when creating visuals?

A

Count

41
Q

Where can you create a relationship between two tables in Power BI Desktop?

A

Modeling view

42
Q

Where should you collaborate with others to build visualizations in Power BI?

A

Workspace

43
Q

What is the correct way to add a calculated column in a Power BI report?

A

use Power BI Desktop, Data tab, choose New column

44
Q

Which feature can only be created in Power BI Service?

A

Dashboards

45
Q

What type of calculation is a ‘Measure’ in Power BI?

A

An equation created on the dataset

46
Q

When creating a Power BI report which visualization should you use to present last year’s revenue?

A

Bar Chart or Line chart

47
Q

Which tool should you use to add a calculated column in a Power BI report?

A

New column option in Power BI Desktop

48
Q

What should you recommend to allow users to reuse the same dataset to build their own reports and dashboards?

A

Share the dataset

49
Q

To which field well should you add the row count measure in order to show the count of rows in the table as columns of a clustered column chart?

A

Y-axis

50
Q

Which chart type should you use to display month-by-month revenue comparisons for the current and previous years?

A

Bar