Perform Analytics in Power BI Exam
Questions & Answers (Grade A+)
How does statistics play into data analytics? -
correct answer ✅Statistics show you the distribution of your data
and help you to identify key takeaways and trends and determine
whether outliers exist.
What is a Histogram? -
correct answer ✅Histograms and bell curves are the most
common way to display statistics about your datasets. In Power BI
terms, you can represent a histogram with one of the bar or column
chart visuals and represent a bell curve with an area chart visual, as
illustrated in the following image. You can also use the Q&A visual
to ask a direct question about the top or bottom items in a list.
What is Top N Analysis? -
correct answer ✅The TOPN DAX function returns the top N rows
of a specified table. The Top N analysis is a great way to present
data that might be important, such as the top 10 selling products,
top 10 performers in an organization, or top 10 customers.
Explain the Power BI built-in Q&A Visual -
correct answer ✅allows users to ask their own questions and get
answers so you don't have to address each individual question. The
Q&A visual is an effective tool because it allows users to quickly get
answers about the data independently, which saves time for
, Perform Analytics in Power BI Exam
Questions & Answers (Grade A+)
everyone involved. The Q&A visual is unique in that it does not
require knowledge of Power BI to use the visual; users can ask their
question and they, too, can create insightful visuals.
Where can you find the Top N filter? -
correct answer ✅Top N is a filtering option that is available on the
Filters pane. Select the field that you want to analyze on your
report page. In the Filters pane, expand the Filter type list and
select Top N. In the Show items settings, select Top and 10. Then,
select Cost of Sales as the value that you want to filter the field by.
The visual updates accordingly.
What is an outlier? -
correct answer ✅An outlier is a type of anomaly in your data,
something that you didn't expect or that surprised you, based on
historical averages or results.
Why would you want to identify outliers? -
correct answer ✅You will want to identify outliers to isolate data
points that significantly differ from other data points, and then take
action to investigate the reasons for the differences. The results of
this analysis can make a significant impact on business decision
making.
Questions & Answers (Grade A+)
How does statistics play into data analytics? -
correct answer ✅Statistics show you the distribution of your data
and help you to identify key takeaways and trends and determine
whether outliers exist.
What is a Histogram? -
correct answer ✅Histograms and bell curves are the most
common way to display statistics about your datasets. In Power BI
terms, you can represent a histogram with one of the bar or column
chart visuals and represent a bell curve with an area chart visual, as
illustrated in the following image. You can also use the Q&A visual
to ask a direct question about the top or bottom items in a list.
What is Top N Analysis? -
correct answer ✅The TOPN DAX function returns the top N rows
of a specified table. The Top N analysis is a great way to present
data that might be important, such as the top 10 selling products,
top 10 performers in an organization, or top 10 customers.
Explain the Power BI built-in Q&A Visual -
correct answer ✅allows users to ask their own questions and get
answers so you don't have to address each individual question. The
Q&A visual is an effective tool because it allows users to quickly get
answers about the data independently, which saves time for
, Perform Analytics in Power BI Exam
Questions & Answers (Grade A+)
everyone involved. The Q&A visual is unique in that it does not
require knowledge of Power BI to use the visual; users can ask their
question and they, too, can create insightful visuals.
Where can you find the Top N filter? -
correct answer ✅Top N is a filtering option that is available on the
Filters pane. Select the field that you want to analyze on your
report page. In the Filters pane, expand the Filter type list and
select Top N. In the Show items settings, select Top and 10. Then,
select Cost of Sales as the value that you want to filter the field by.
The visual updates accordingly.
What is an outlier? -
correct answer ✅An outlier is a type of anomaly in your data,
something that you didn't expect or that surprised you, based on
historical averages or results.
Why would you want to identify outliers? -
correct answer ✅You will want to identify outliers to isolate data
points that significantly differ from other data points, and then take
action to investigate the reasons for the differences. The results of
this analysis can make a significant impact on business decision
making.
