4. Build Power BI Visuals and report OK

Question 1

Play axxis well -custom visual what it is

1. Down load from MS appstore
2. Animate changes with time
3. 1,2 correct
4. You have download premium

Answer 1

3. 1,2 correct

Question 2

A decomposition tree is a standard AI visual, it requires Premium subscription

1. true
2. false

Answer 2

False

Question 3

Small multiples split a visual into multiple visuals side-by-side by a chosen dimension

To do so, move the Year field from the Axis well to the small multiples well.

Yes or not

Answer 3

Yes

Question 4

Using data bars, we can replace column values with color-coded bars that communicate both the magnitude (length of the bar) and the direction of the change (positive/negative).

Yes or not

Answer 4

Yes

Question 5

You can set an alert only on Gauges, KPIs, and Card visuals. If you pin a line chart report visual as a tile to the dashboard, you will see any option to Manage alerts .

True or false

Answer 5

False

If you pin a line chart report visual as a tile to the dashboard, you will Not see any option to Manage alerts .

Question 6

Cross filtering and crosshighlight

1.Cross-filtering removes data that doesn’t apply.
2Cross-highlighting retains all the original data points but dims the portion that doesn’t apply to your selection.
3, 1 and 2 correct
4. 1 and 2 incorrect

Answer 6

3

Question 7

100% stacked are chart

we display the percentage values rather than real values. Use this chart when visualizing the cumulative total is not important, and you only need to show percentages (proportions).

True or false

Answer 7

True

Question 8

What are the components of the KPI formula in Power BI

1. Indicator,
   2.Trend axis
   3.Target goals
2. None of the above
   5 1,2,3

Answer 8

5

Question 9

While creating visuals for your Power BI dashboards, there is an opportunity to break down your visuals into slices called small multiples.
Which of the following options cover the full list of visuals supporting small multiples?

A. Bar, column and line
B. Doughnut, bar, area and line
C. Bar, column, area and line
D. Pie, doughnut, bar, line

Answer 9

C

Question 10

Data alerts are created to notify you when the data in the dashboard is changed beyond the limits set by you.

yes or not

Answer 10

Yes

Question 11

Your company has employees in 10 states.The company recently decided to associate each state to one of the following three regions: East, West, and North.You have a data model that contains employee information by state. The model does NOT include region information.You have a report that shows the employees by state.You need to view the employees by region as quickly as possible.What should you do?

A. Create a new aggregation that summarizes by state.
B. Create a new aggregation that summarizes by employee
C. Create a new group on the state column and set the Group type to List.
D. Create a new group on the state column and set the Group type to Bin.

Answer 11

D
binning allows you to group data into specific ranges or categories, in this case, the three regions.

Question 12

You want to show the distribution of customer ratings for a product. Which chart type would be best to use?

A. Box plot
B. Line chart
C. Pie chart
D. Scatter chart

Answer 12

A

Question 13

You are building a Power BI report to analyze customer segments. You need to identify customer segments dynamically based on the Bounce Rate across dimensions such as source, geography, and demographics. The solution must minimize analysis effort. Which type of visualization should you use?

A. decomposition tree
B. funnel chart
C. Q&A
D. key influencers

Answer 13

A
A decomposition tree is a type of visualization that allows you to break down a measure (in this case, bounce rate) across different dimensions (such as source, geography, and demographics) in a hierarchical manner

Question 14

How can you identify outliers in a dataset?

1.Use box plots
2.Use scatter plots
3.Use histograms
4.Use bar charts

Answer 14

1

Question 15

You are creating a Power BI report by using Power BI Desktop.You need to include a visual that shows trends and other useful information automatically. The visual must update based on selections in other visuals.Which type of visual should you use?

A. Q&A
B. smart narrative
C. key influencers
D. decomposition tree

Answer 15

D

A decomposition tree is a visual in Power BI that shows how a measure is broken down across different dimensions. It automatically updates based on selections in other visuals, making it a suitable choice for showing trends and other useful information automatically

Question 16

What is the purpose of a dataflow in Power BI?

To transform and clean data
To create visualizations
To share data with other users
To manage data sources

Answer 16

To transform and clean data

Question 17

You want to compare the sales performance of two different regions. Which chart type would be best to use?

A. Stacked bar chart
B. Line chart
C. Scatter chart
D. Dual-axis chart

Answer 17

D. Dual-axis chart

Question 18

How can you create a custom visual in Power BI?

1. By importing a custom visual from the marketplace
2. By using the Power BI Developer Tools to create a custom visual
3. By using the built-in visualizations and customizing them
4. By creating a new report page and adding visuals to it

Answer 18

2. By using the Power BI Developer Tools to create a custom visual

the only way to create a truly custom visual in Power BI is to use the Power BI Developer Tools. This involves writing code using technologies like HTML, CSS, and JavaScript to define the visual’s appearance, behavior, and interactions with data.

Question 19

Using the bookmarking features in the report designer in Power BI Desktop, there is a limitation of creating only one bookmark per page in a report.
Is this statement correct?

TRUE
FALSE

Answer 19

False

You are allowed to create multiple bookmarks.

Question 20

Which two field options are available when creating a waterfall chart?

1. X Axis
2. Category
3. Y Axis
4. Size

Answer 20

2. Category
3. Y Axis

Question 21

The steps to the performance analyzer tool are:

1. Create a blank report page
2. Restart Power BI
3. Open performance analyzer and press start recording
4. Interact with the visuals
5. Press stop and review results

Yes or not

Answer 21

Yes

Question 22

You are using Power BI Desktop optimized for Power BI Report Server to create a report.
Select three types of visualizations that will work correctly when you will publish the report to the PowerBI Report Server.

1. Funnel charts.
   2.Bubble maps.
   3 Breadcrumbs.
   4 Custom visuals.
   5 R visuals.

Answer 22

1,2,4

Question 23

You need to create a visualization that compares revenue and cost over time. Which type of visualization should you use?

waterfall chart
stacked area chart
line chart
pi chart

Answer 23

Line chart

Question 24

When you pin an entire page, the tiles are live. You can interact with the visuals directly on the dashboard. Changes you make to any of the visualizations back in the report editor, like adding a filter or changing the fields used in the chart, are reflected in the dashboard tile.

Yes or not

Answer 24

Yes

Question 25

A report-level filter in Power BI affects all data in a report, regardless of which page is being viewed

Yes or not

Answer 25

Yes