4. Build Power BI Visuals and report OK Flashcards
Play axxis well -custom visual what it is
- Down load from MS appstore
- Animate changes with time
- 1,2 correct
- You have download premium
- 1,2 correct
A decomposition tree is a standard AI visual, it requires Premium subscription
- true
- false
False
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
Yes
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
Yes
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
False
If you pin a line chart report visual as a tile to the dashboard, you will Not see any option to Manage alerts .
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
3
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
True
What are the components of the KPI formula in Power BI
- Indicator,
2.Trend axis
3.Target goals - None of the above
5 1,2,3
5
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
C
Data alerts are created to notify you when the data in the dashboard is changed beyond the limits set by you.
yes or not
Yes
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.
D
binning allows you to group data into specific ranges or categories, in this case, the three regions.
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
A
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
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
How can you identify outliers in a dataset?
1.Use box plots
2.Use scatter plots
3.Use histograms
4.Use bar charts
1
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
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
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
To transform and clean data
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
D. Dual-axis chart
How can you create a custom visual in Power BI?
- By importing a custom visual from the marketplace
- By using the Power BI Developer Tools to create a custom visual
- By using the built-in visualizations and customizing them
- By creating a new report page and adding visuals to it
- 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.
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
False
You are allowed to create multiple bookmarks.
Which two field options are available when creating a waterfall chart?
- X Axis
- Category
- Y Axis
- Size
- Category
- Y Axis
The steps to the performance analyzer tool are:
- Create a blank report page
- Restart Power BI
- Open performance analyzer and press start recording
- Interact with the visuals
- Press stop and review results
Yes or not
Yes
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.
- Funnel charts.
2.Bubble maps.
3 Breadcrumbs.
4 Custom visuals.
5 R visuals.
1,2,4
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
Line chart
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
Yes
A report-level filter in Power BI affects all data in a report, regardless of which page is being viewed
Yes or not
Yes
