Dashboards Flashcards

1
Q

What does Microsoft Power BI consider a dashboard?

A
  • A summary or highlight reel of one or more reports.
  • It’s a one page overview of the most important metrics or KPIs, selected from the various pages of one or more reports.

Think in depth news article vs high level news bulletin. If a particular news bulletin catches your attention, you can read the full news article or report for a more detailed understanding.

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

What does Microsoft consider a report in Power BI?

A
  • A report in Microsoft Power BI is highly interactive.
  • Users can slice and dice the data, drill down into details, apply filters, and explore various facets of the data within the report itself.
  • In essence, a Power Bi report provides an in depth, interactive, multi perspective view of a specific data set or topic. It’s like an exploratory journey through your data.

Think in depth news article vs high level news bulletin. If a particular news bulletin catches your attention, you can read the full news article or report for a more detailed understanding.

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

Where do you go to create a Dashboard?

A
  1. Go to Microsoft Power BI Service
  2. Navigate to the desired workspace
  3. Click on New
  4. Select Dashboard
  5. Name the Dashboard and click ok
  6. Make sure the Power Bi Report you want to pin from is saved to the same workspace
  7. Go to the Power BI Report that has the visuals you want to pin
  8. Click the pin icon at the top right of the visual you want to pin
  9. Select the dashboard you want to pin it to
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

How can you change the theme of your dashboard?

A

From inside your dashboard on the workspace, click on Edit->Dashboard Theme and select a theme

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

What else can you do inside a dashboard?

A
  • You can choose to make it mobile friendly by going to Edit->Mobile Layout
  • Once you click Mobile Layout you can choose the order of the visuals and their size.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What does Quick Insights in Power BI do?

A
  • Quick insights is a feature in Power BI that automatically searches datasets to discover and visualize potential insights.
  • Applies machine learning algorithms and statistical functions to your data.
  • It identifies patterns, trends, outliers, and other useful insights that may not be immediately obvious.
  • For example, uncovering sales patterns to help the marketing team at AdventureWorks target their campaigns more effectively.
  • Quick Insights not only presents the insights in an easy to understand format, but also explains how it arrived at these insights.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

How do you generate Quick Insights?

A
  1. In the Power BI Service click on the three dots next to the dataset you are interested in analyzing and select View Insights
    OR
  2. Open a Power BI Report in Power BI Service and click Get Insights at the top of the screen
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

How can you share an insight with Team Members if you find it helpful?

A

Pin it to a dashboard.

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

What does the Q&A feature in Power BI Service do?

A
  • The Q&A feature is a natural language processing tool in Power BI.
  • It allows you to ask questions about your data in plain English and provides answers in the form of charts, graphs, or simple numeric results.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What is a key advantage of the Q&A feature?

A
  • Its flexibility.
  • You ask questions ranging from simple questions like what was the total revenue last quarter? To more complex ones such as which product had the highest sales growth rate last year?
  • The more you use the Q&A feature, the more it learns and adapts to your question style, offering even more relevant and precise answers over time.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Where do you find the Q&A feature?

A

There is a question box at the top of your dashboard

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

How do you use the Power BI Q&A feature?

A

Type a question in normal conversational language

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

How can you pin a visual that is a result of Q&A?

A

Look for the Pin Visual icon in the top right corner of the Q&A page

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

What are limitations of pinned visuals?

A
  • A pinned visual is a snapshot of a specific piece of data or chart from a report that is attached or pinned to a dashboard.
  • They don’t interact or update
  • No data drilling
  • No cross-filtering
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What is a solution to the limitations of pinned visuals?

A
  • Pinning a live report to the dashboard instead
  • They will maintain their original interactivity
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

How do you pin a live report to a dashboard?

A

Open the report you want to pin. Instead of selecting a specific visual to pin, click the three dots at the top of the page and select Pin to Dashboard