Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Microsoft Data Analysis and Visualization with Power BI > Specialist Visualizations (Including Drill Down) > Flashcards

Specialist Visualizations (Including Drill Down) Flashcards

1
Q

How are KPI’s different from regular charts and metrics?

A

They align directly with strategic business objectives

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

What does a well designed KPI do?

A
  • Helps stakeholders clearly understand organizational or departmental goals
  • Provide metrics that show progress
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

How do KPI’s help stakeholders?

A

Makes it easy to comprehend
1. Overall business performance/health of the business
2. Progress toward business goals
3. Key Metrics

  • To make Data-Driven decisions
  • To Implement data driven strategies to promote successful business performance
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What are examples of visualizations that can be used for KPI’s?

A
  1. Cards
  2. Multi-Row Cards
  3. Guages
  4. The KPI Visual
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

When would it be good to use a Card?

A

To represent essential statistics you want to track. For example, Sales Revenue

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

What is a radial guage?

A

A circular arc that displays a single value, measuring progress toward a goal or target, or indicates the health of a single measure.

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

What is a downside of a radial guage?

A

They take up a lot of space while portraying a small amount of insight

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

What three components of a KPI Visual?

A
  • Indicator: Primary measure
  • Trend Axis: How the Indicator is performing over time
  • Target Goals: The benchmarks you are trying to achieve
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Decomposition Tree Icon

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

Decomposition Tree Chart Example

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

What is an example of when Ribbon and Waterfall charts are useful?

A

Analyzing sales trends and financial performance across regions

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

What is a Ribbon chart?

A
  • A form of stacked chart for visualizing data and changes over time that has a clear ranking order
  • A chart that stacks the highest ranked series at the top of the chart, making it easy to track shifts in the rankings over time.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What does the Ribbon chart show?

A

Rankings and their shifts over time.

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

How is a Ribbon Chart a form of a Stacked Chart?

A
  • It looks like a continuous ribbon from left to right
  • Look closer at the shading and you will see distinct stacked columns that are shaded a little darker
  • The connecting part of the ribbon is shaded a little lighter
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Example of what goes in the Data Well for a Ribbon Chart

A
  • X-Axis: Month
  • Y-Axis: Order Total
  • Legend: Product Region
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What does a Waterfall Chart show?

A
  • A running total as Power BI adds and subtracts values
  • Useful for showing cumulative effects over time
  • Can show where the contribution is coming from. For example, the region that contributed to the increase or decrease of Total Sales
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

When should you use a funnel chart?

A
  • Ideal for data that moves through at least four stages
  • Ideal for scenarios where you expect a greater number of items in the first stage than the final stage
18
Q

What is a funnel chart good for?

A
  • Showing connected stages where items flow sequentially from one stage to the next
  • Funnel charts can help reveal bottlenecks, such as where a significant number of items are being lost or not moving forward in linear processes
19
Q

Examples of good use for funnel chart

A
  • Representing the progression of data through different stages like a sales workflow.
  • Show how many potential customers move through each stage of the sales process, and stay in the process.
  • Track the progress and success of click through advertising campaigns.
20
Q

How to read the funnel chart

A
  • Each stage shows how many of the leads in the initial stage flow through to each of the next stages.
  • For example, in this chart only 7.6% of leads resulted in actual sales.
21
Q

Example of stages in a funnel chart

A
  1. Lead: Customers interested in a product or service
  2. Qualify: Does the customer qualify for the product or service
  3. Solution: Tailored solution presented to customer
  4. Proposal: Sales terms presented to the customer
  5. Finalized: Customer approves the terms and signs the contract
22
Q

What do you put in the Data Wells for a funnel chart?

A
  • Category: The various stages for the funnel
  • Values: For example, the number of applications in each stage
23
Q

Can the color of the bars in a funnel chart be changed?

A

Yes. They can be changed individually to fully customize the chart

24
Q

Where does the highest category display for a funnel chart? The top or the bottom?

A

You can customize this simply through sorting. It can show at the top or the bottom

25
Q

What do scatter plots do?

A

Represent how one factor is affected by another, their correlation

26
Q

What are the three ways the relationships between the variables can present?

A
  • Linear follows a straight line
  • Nonlinear follows a curved line
  • Random
27
Q

What can scatter plots help identify?

A
  1. Trends
  2. Patterns
  3. Anomalies Deviation from the pattern of the data
28
Q

What are some characteristics of Outliers, a type of anomaly, in a scatter plot?

A
  • Valid data points significantly differ from other observations deviating from the general data trend.
  • They tend to lie far away from other data points in a scatter chart.
29
Q

Outlier example

A
  • You might expect a scatter chart representing the relationship between sales revenue and advertising spend to show a positive correlation where higher advertising spend is associated with more sales.
  • An outlier would be a data point representing unusually high sales revenue and low marketing spend.
  • This data point is worth investigating as it may indicate an effective marketing strategy able to generate revenue beyond what is expected based on the amount of money spent on marketing.
30
Q

Why is it important to identify outliers?

A
  • A keen eye for outliers is essential because they can dramatically skew statistical measures and data distributions.
  • Though they might seem problematic at first, outliers often carry vital information about the process under investigation or the data gathering mechanism.
  • They can help businesses gain valuable insight into potential issues or areas for improvement and optimization
31
Q

Can you change the size of the dots on a scatter plot?

A

Yes

32
Q

What does the size field in the Data Well do?

A

You can put a field in the Size data well, for example, advertising spend, and the dots will change size based on the size of the advertizing at that point

33
Q

What does the Play Axis field in the data well do?

A

It animates the chart. This is good for presentations to engage audiences. It plots the points one by one and shows a value for each.

34
Q

What is important to know about a Matrix?

A

You can have totals and subtotals that don’t make sense.
Totals and Subtotals are based on the underlying data. They are not simply an addition of the values visible in the rows. Therefore, they may not add up correctly.

35
Q

What happens when you add multiple fields to the rows section of the Data Well?

A

You enable drill-down actions on the rows of the matrix visual

36
Q

How can you tell if your visual has a hierarchy?

A

The drill control options appear for your visual

37
Q

What does the double down arrow do?

A

Drills down all fields at once
- Takes you to the next level in the hierarchy.
- For example, if you are at the category level you can drill down to the manufacturer level, then the segment level and finally the product level.

38
Q

What does the single arrow down do?

A

Drill down one field at a time.

For example, say your data is a date hierarchy of Quarter, Month and then day.
1. Click on the single arrow so it has a circle around it
2. Click the Qtr 2 bar and it will show you the Sales Amount broken out by the Months for Qtr 2.
2. If you click on one of the Month bars it will show you the Sales Amount for each day of that month.

39
Q

What does the double down arrow with a fork do?

A

Expands all fields at once
In our example of Qtr, Month, Day
- If you click Expand, you will see all months broken out by each Qtr.
- If you click Expand again, you will see all days broken out by month, broken out by Qtr

40
Q

What happens if you have more than one row or column field in a Matrix?

A

Next to the drill control you will see a drop down that you can change to rows or columns. This allows you to determine what you want to drill down on.

41
Q

How can you drill up or drill down on Columns?

A

The drill-down and drill-up icons only apply to rows. To drill down on columns you must right-click to use the context menu

Microsoft Data Analysis and Visualization with Power BI (11 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions