Power BI Quizzes

Practice Quizzes
Thanks!
Thanks!

Power BI Quizzes

Accelerate your Career and Get Certified

Data analysis in Power BI

Friday, June 25th, 2021

Welcome to your Data analysis in Power BI

Which of the following visuals can be used to create a histogram?

histogram chart

bar chart

clustered column chart

area chart

A histogram visualizes

A dimension and measure

A dimension only

A measure only

If the number of clusters field is left blank, Power BI will

Power BI will determine how many clusters make the most sense given your data

not allow you to do cluster analysis. Number of clusters is a required field

3 clusters is the default

The lightbulb icon is used to

perform an AI split

highlight / light up a region of a decomposition tree

mark and insight

Which method for identifying outliers would be static until you refresh your data?

DAX functions

calculated columns

To create a bin, start in the Fields pane by right-clicking the field you'd like to create bins for, and then select ______.

Create Bin

Group data

New Group

New Bin

Add Bin

AI splits work by

determining how to bin a continuous field to get the maximum variation of the measure being analyzed

determining which of all the available fields to drill into to get the highest/lowest value of the measure that is being analyzed

creating a random forest to split your data on all the available fields to get maximum separation on a measure

The Review Quick Insights feature works with [select all that apply]

Power BI web service

DirectQuery

Power BI desktop

data imported into Power BI

What differences are there between the play axis in Microsoft AppSource and the play axis in the scatter plot? [select all that apply]

The play axis in the AppSource can animate multiple visuals, while the one in the scatter plot cannot

The play axis in AppSource is less likely to be permitted for use by your organization

The play axis in the scatter plot is less likely to be permitted for use by your organization

The play axis in the scatter plot can animate multiple visuals, while the one in AppSource cannot

In the Q&A visual, a red underline means

Power BI does not understand the underline term

There is a spelling error

Invalid syntax

The expression is has more terms that allowed by the Q&A visual

When you select the Analyze option, what further options might you see presented [select all that apply]

Find where the distribution is different

Statistical Summary

Explain the increase

The AI Insights options are found here

In the Analyze menu

In the Analysis pane

In the AI pane

In the Power Query editor

Clicking this icon will turn a Q&A visual into a standard visual

To get the top 10 Products by total sales, what function should be used?

Top 10 Products = SUMX (  ( 10, Product, Product[Product Name], ASC ), [Total Sales] )

Advanced Analytics visualizations can be added

Using Advanced Analytics category at the Microsoft AppSource

By right clicking on the visualization, selecting analyze, then advanced analytics

By combining standard visualizations using the merge option - for example line chart + bar chart

The Play Axis option is available [select all that apply]

For line chart visualizations within Power BI Desktop

Microsoft AppSource

For KPI visualizations within Power BI Desktop

For scatter chart visualizations within Power BI Desktop

Which is the best visual for identify outliers?

decomposition tree

scatter chart

bar chart

key influences

If the Q&A feature is not understanding terms that the users are entering, you can go to the field pane and set aliases for those terms.

False

True

Quick Insights can be run from

a report

the datasets + dataflows tab

the content tab

a dashboard

Binning is used for this type of data

category

hierarchical

continuous

All clusters will contain the same number of items.

False

True

The reason you might not see the AI Insights options showing

The AI Insights function browser option is turned off

Your data doesn't include text or graphics required as inputs to AI Insights

You don't have premium capacity

Power BI's cluster analysis uses all the measures available in the fields section

False

True

Which option offers better performance in calculating descriptive statistics such as mean, median, and standard deviation

DAX functions

Right-clicking the Values field in the Visualizations pane and selecting the desired statistic

performance is similar

Time is Up!

Time's up

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Comment

Name *

Email *

Website

Δ

About the Author: Lukas Halim

I earned a Masters in Analytics from NC State in 2013 and now work as a data analyst in the health insurance industry. Using tools such as SAS, Tableau, and Teradata, I conduct analysis to help my company improve healthcare affordability and customer engagement.

Learn More

4.6 Instructor Rating
53,604 Students

14,612 Reviews
2 courses

© Learning Tableau. All rights reserved.
Privacy Policy | Design by Liscio Apps, LLC