Question 1

There are Revenue and Cost columns in an Adventure Works Sales dataset. The profit is defined as Revenue – Cost. Which DAX function should you use to calculate the average profit of the dataset?

Accepted Answer

AVERAGEX(Sales, Sales[Revenue] - Sales[Cost])   (CORRECT)

Question 2

What are the different ways a Top N analysis can be applied to a Power BI Report? Select all that apply.

Accepted Answer

By applying a Top N filter on the Filter pane. By utilizing TOP N function in DAX. By typing it into a Q&A visualization. (CORRECT)

Question 3

When grouping data in Power BI, what happens to the original dataset?

Accepted Answer

The original dataset remains unchanged. (CORRECT)

Question 4

What is the primary goal of applying clustering techniques in Power BI?

Accepted Answer

To group similar data points together. (CORRECT)

Question 5

What are the main differences between a histogram bar chart and a standard bar chart in Power BI? Select all that apply.

Accepted Answer

Histogram bar charts display data distribution within bins, while standard bar charts show individual categories. Standard bar charts contain separate fields in their x and y axis, while histograms contain the same field for both axes. Histogram bar chart represents continuous numerical data, while a standard bar chart represents categorical data.   (CORRECT)

Question 6

Which of the following features available for analytics in Power BI groups data points together? Select all that apply.

Accepted Answer

Clustering technique, Groups and bins (CORRECT)

Question 7

Which statistical function in Power BI calculates the middle value of a dataset when arranged in ascending order?

Accepted Answer

Median (CORRECT)

Question 8

Which of the following statements about groups and bins in Power BI are true? Select all that apply.

Accepted Answer

Both groups and bins use existing columns to create new ones with a lower number of distinct values. Groups combine data fields in categories while bin into predefined intervals. Bins automatically label data fields with the predefined. (CORRECT)

Question 9

Which of the following graphs are the optimal visualizations to represent histograms? Select all that apply.

Accepted Answer

Bar chart, Area chart (CORRECT)

Question 10

When it comes to using generated cluster columns in visualizations, which of the following statements are true? Select all that apply.

Accepted Answer

Cluster columns are created only in scatter plots, Any visualization can have a created clustered column as axis (CORRECT)

Question 11

Which of these attributes can support the continuous axis type in Power BI? Select all that apply.

Accepted Answer

Temperature, Product weight, Employee hire date (CORRECT)

Question 12

In this exercise you created a scatter plot to identify the product name distribution on Order Total vs Product Price. Which product name was the definite outlier in the dataset?

Accepted Answer

Aerospeed 1000 (CORRECT)

Question 13

For the line chart, what was the percentile increase in Sum of Order Total on the day with the highest sales amount?

Accepted Answer

217.65% increase (CORRECT)

Question 14

When the second highest day in terms of Order Total was identified as March 3rd , which of the two payment methods impacted positively to create the increase?

Accepted Answer

Credit card payments (CORRECT)

Question 15

What is the default visual that the Analyze feature creates when the Explain the increase or Explain the decrease options are selected?

Accepted Answer

Waterfall chart (CORRECT)

Question 16

Which of these features are supported by Analyze feature in Microsoft Power BI? Select all that apply.

Accepted Answer

Find where the distribution is different, Explain the increase, Explain the decrease (CORRECT)

Question 17

Which of these following visualizations is the most appropriate for time series analysis? Select all that apply.

Accepted Answer

Scatter plot, Line chart (CORRECT)

Question 18

Which of these following are types of Reference lines in Power BI? Select all that apply.

Accepted Answer

Constant Line, Trend Line, Min Line (CORRECT)

Question 19

Which of the following sentences describes what the Analyze feature in Microsoft Power BI automatically generates?

Accepted Answer

It generates charts with insights and patterns from your data   (CORRECT)

Question 20

What is the primary objective of time series analysis in Microsoft Power BI?

Accepted Answer

To explore patterns and trends within time-based data (CORRECT)

Question 21

What is the primary function of Reference lines in Power BI visualizations?

Accepted Answer

To highlight specific data points or values   (CORRECT)

Question 22

How do Reference lines enhance the readability and interpretation of visualizations?

Accepted Answer

By providing additional insights into the underlying data (CORRECT)

Question 23

What purpose do Error bars serve in Power BI visualizations?

Accepted Answer

They indicate the range of potential data variability. (CORRECT)

Question 24

Which of the following best defines seasonality in time-series data?

Accepted Answer

Recurring patterns or cycles that occur at regular intervals. (CORRECT)

Question 25

According to the relevant chart created, what is the average CO2 emission of the vehicle with the largest volume of Engine Size?

Accepted Answer

360.33  (CORRECT)

Question 26

Based on the results of the Key influencers visuals, which of the following fuel type attributes are scoring below the Average of CO2 emission line? Select all that apply.

Accepted Answer

Electricity/Diesel, Petrol LPG  (CORRECT)

Question 27

Which of the following decomposition tree features are driven by AI algorithms? Select all that apply.

Accepted Answer

High value, Low value  (CORRECT)

Question 28

Which column of the VehicleDetails table does not add value when added to the Explain by field of an AI visual?

Accepted Answer

Car_id  (CORRECT)

Question 29

Between Manual transmission vehicles, what is the fuel type category with the lowest average CO2 emission? Use the decomposition tree to find the answer.

Accepted Answer

Petrol Electric  (CORRECT)

Question 30

Which tool of the Key influencer visualizations groups major contributing influencers together?

Accepted Answer

Top segments (CORRECT)

Question 31

In which of the following scenarios is the decomposition tree the most suitable visualization?

Accepted Answer

Identification of trends in sales patterns (CORRECT)

Question 32

Which of the following specialized tools of Power BI use AI algorithms to provide insights? Select all that apply.

Accepted Answer

Decomposition tree, Q&A, Key influencers (CORRECT)

Question 33

What does the Top segments tool in the key influencers visualization do?

Accepted Answer

It ranks segments based on the combined influence of multiple factors. (CORRECT)

Question 34

What are the primary purposes of the decomposition tree visualization in Power BI? Select all that apply.

Accepted Answer

Identifying root causes of fluctuations, Ad-hoc exploration of data patterns (CORRECT)

Question 35

What is the primary purpose of the Q&A visual in Microsoft Power BI?

Accepted Answer

Allows users to ask questions in natural language and generate relevant visualizations (CORRECT)

Question 36

The Q&A visualization provides wording underlying to showcase whether the natural language words were interpreted correctly. Which of the following underlying feedback is featured in the visualization? Select all that apply.

Accepted Answer

Double red underline, Solid green underline, Orange dotted underline (CORRECT)

Question 37

You're a data analyst at Adventure Works and you are tasked with enhancing reports by applying analytics. The stakeholders are requesting an analysis of the distribution of an attribute. You are planning to incorporate a histogram to achieve this outcome. Which of the following statements accurately describes a histogram? Select all that apply.

Accepted Answer

A histogram groups an attribute in X-axis and analyses its frequency in Y-axis. A histogram is assigned the same attribute in both axes. (CORRECT)

Question 38

You are requested to enhance the readability of the new Microsoft Power BI report with the middle value of the data set. Which statistical function of Power BI should be used to calculate the result?

Accepted Answer

Median (CORRECT)

Question 39

You are requested to enhance the readability of the new Microsoft Power BI report by organizing an attribute into categories. The request is to categorize a sales country attribute column in custom manual groups provided by the business. What Power BI analytics feature is the optimal tool to complete the request?

Accepted Answer

Grouping data with column groups (CORRECT)

Question 40

The marketing manager of Adventure Works wants to segment the business’ products into separate segments based on their sales performance. You are requested to leverage a grouping technique of Microsoft Power BI to incorporate generated segments of data based on the outcome of their respective sales. Which technique should be used to accomplish that?

Accepted Answer

Clustering data with clustering technique (CORRECT)

Question 41

Some major spikes in sales numbers have been identified in the reports you have been building. The CEO of Adventure Works requests to identify the reasons behind it, so that the business will be assisted in their future decision-making. Which tool of the Analyze feature in Microsoft Power BI can immediately generate some insights on the sales spike?

Accepted Answer

Explain the increase (CORRECT)

Question 42

You're analyzing website traffic data in Microsoft Power BI and want to highlight a period where the traffic exceeded the expected range, based on the business’ confidence intervals. Which capability in the Analytics pane of Power BI would you use to visually indicate this anomaly?

Accepted Answer

Error bars (CORRECT)

Question 43

You're analyzing monthly website traffic data for a blog in Microsoft Power BI. To better understand the overall traffic pattern, you want to add a line that represents the average number of visitors per month. Which reference line of the Analytics pane of Power BI would you use for this purpose?

Accepted Answer

Average line (CORRECT)

Question 44

True or False: The Forecast feature in Microsoft Power BI's Analytics pane not only predicts future values but also provides insight into the factors influencing those predictions.

Accepted Answer

False (CORRECT)

Question 45

You are assigned to include AI visuals in Adventure Works reports to enhance the results of your insights. Which of the following scenarios would align with the use of the key influencers visual in Microsoft Power BI?

Accepted Answer

Understanding the breakdown of factors influencing fluctuations in monthly revenue. (CORRECT)

Question 46

You're exploring the dynamic capabilities of Microsoft Power BI's Q&A visual, which offers autocomplete suggestions and recognition feedback while you compose your queries. In this context, what does an orange dotted underline indicate during your query formulation?

Accepted Answer

Ambiguity in the word used, suggesting that it may correspond to multiple dataset fields. (CORRECT)

Question 47

You're a data analyst at Adventure Works and you are tasked with enhancing reports by applying analytics. The stakeholders are requesting a best-performing product visualization added to the report. You are planning to incorporate top N analysis to achieve this outcome. What are the different ways a Top N analysis can be achieved in Power BI? Select all that apply.

Accepted Answer

By applying a Top N filter type in the Filter pane, By utilizing TOPN function in DAX, By typing Top N in a Q&A visualization query (CORRECT)

Question 48

You are working with Microsoft Power BI to create a report based on sales data from Adventure Works. You have to add some statistical summary functions in your report. Which ones of the following are available directly through the Field settings of the Visualizations pane? Select all that apply.

Accepted Answer

Variance, Standard deviation (CORRECT)

Question 49

You are requested to enhance the readability of the new Microsoft Power BI report by organizing an attribute into categories. The request is to categorize a sales country attribute column into 5 equal-sized groups. What Power BI analytics feature is the optimal tool to complete the request?

Accepted Answer

Binning data with the Number of bins type (CORRECT)

Question 50

Some major spikes in sales numbers have been identified in the reports you have been building. The CEO of Adventure Works requests an analysis of the historical data of Adventure Works sales. You are requested to conduct a time-series analysis in a Microsoft Power BI report. Which visual in Power BI is commonly used to display time-series data?

Accepted Answer

Line chart (CORRECT)

Question 51

You've been tasked with analyzing quarterly sales data for the next year in Microsoft Power BI. Your goal is to provide insights into potential trends and performance. Which feature in the Analytics pane of Power BI should you use to visualize potential future trends in the data?

Accepted Answer

Forecast (CORRECT)

Question 52

You're tasked with enhancing your business reports using Microsoft Power BI's analytics features. In which scenario would the Forecast feature from the Analytics pane be most beneficial?

Accepted Answer

Predicting future revenue trends based on past performance. (CORRECT)

Question 53

You are assigned to include AI visuals in Adventure Works reports to enhance the results of your insights. Which of the following scenarios would align with the use of the key influencers visual in Microsoft Power BI?

Accepted Answer

Analyzing the factors contributing to employee turnover within the organization. (CORRECT)

Question 54

Venturing into the technical capabilities of Microsoft Power BI, you're intrigued by the Q&A visual's potential. Which of the following accurately characterizes a key function of the Q&A visual?

Accepted Answer

The Q&A visual enables users to ask questions in natural language and receive visual responses from the data. (CORRECT)

Question 55

A debate sparks between team members working on a Microsoft Power BI report. As the lead data analyst, you are requested to provide information regarding the type of visual that clustering can be applied to. Which of the following options is correct?

Accepted Answer

Scatter chart (CORRECT)

Question 56

Some major spikes in sales numbers have been identified in the reports you have been building. The CEO of Adventure Works requests to identify the reasons behind it so that the business will be assisted in its future decision-making. True or False: the Analyze feature of Power BI can be used to generate multiple suggested visualizations to identify the sales increase.

Accepted Answer

True (CORRECT)

Question 57

While preparing a sales performance report in Microsoft Power BI, you want to enhance your insights by adding the overall sales trend to show important milestones. Which feature in the Analytics pane of Power BI would you use for this purpose?

Accepted Answer

Reference lines (CORRECT)

Question 58

You are working with Microsoft Power BI to create a report based on sales data from Adventure Works. You have to add a measure to depict the variability of a set of data points from the average. Which statistical function of Power BI should be used to calculate the result?

Accepted Answer

Variance (CORRECT)

Question 59

You're tasked with enhancing your business reports using Microsoft Power BI's analytics features. You plan to include forecasting in your line charts. What is the primary purpose of the Confidence Band displayed alongside the Forecast line in Power BI's Analytics pane?

Accepted Answer

It visualizes the range within which the actual values are likely to fall around the forecasted line. (CORRECT)

Question 60

Venturing into the technical capabilities of Microsoft Power BI, you're intrigued by the Q&A visual's potential. Which of the following natural language tasks can the Q&A visual in Power BI add in a visualization based on its capabilities? Select all that apply.

Accepted Answer

Use relative date filtering, Return only the Top N. (CORRECT)

Question 61

You are requested to enhance the readability of the new Microsoft Power BI report by organizing an attribute into categories. The request is to categorize a sales country attribute column on equal-sized categories of 10 countries each. What Power BI analytics feature is the optimal tool to complete the request?

Accepted Answer

Binning data with Size of bin type (CORRECT)

Question 62

As part of your effort to provide more interactive reporting to your organization, you're considering the use of AI visuals in Power BI. In which scenario would the Q&A visual be most appropriate?

Accepted Answer

Extracting comparative sentiments from unstructured text data and translating them into actionable insights. (CORRECT)

Question 63

In your sales analysis report, you're investigating the quarterly revenue trends of your products. You want to mark a specific value on the visual to indicate the target revenue for each quarter. Which feature in the Analytics pane of Microsoft Power BI should you use for this purpose?

Accepted Answer

Constant line (CORRECT)

COURSE 5 – DATA ANALYSIS AND VISUALIZATION WITH POWER BI

Module 4: Identifying Patterns and Trends

MICROSOFT POWER BI DATA ANALYST PROFESSIONAL CERTIFICATE

Complete Coursera Study Guide

TABLE OF CONTENT

INTRODUCTION – Identifying Patterns and Trends

Learning Objectives

KNOWLEDGE CHECK: PERFORM ANALYTICS IN POWER BI

1. There are Revenue and Cost columns in an Adventure Works Sales dataset. The profit is defined as Revenue – Cost. Which DAX function should you use to calculate the average profit of the dataset?

2. What are the different ways a Top N analysis can be applied to a Power BI Report? Select all that apply.

3. When grouping data in Power BI, what happens to the original dataset?

4. What is the primary goal of applying clustering techniques in Power BI?

5. What are the main differences between a histogram bar chart and a standard bar chart in Power BI? Select all that apply.

6. Which of the following features available for analytics in Power BI groups data points together? Select all that apply.

7. Which statistical function in Power BI calculates the middle value of a dataset when arranged in ascending order?

8. Which of the following statements about groups and bins in Power BI are true? Select all that apply.

9. Which of the following graphs are the optimal visualizations to represent histograms? Select all that apply.

10. When it comes to using generated cluster columns in visualizations, which of the following statements are true? Select all that apply.

11. Which of these attributes can support the continuous axis type in Power BI? Select all that apply.

SELF-REVIEW: EXPLAINING THE INCREASE

1. In this exercise you created a scatter plot to identify the product name distribution on Order Total vs Product Price. Which product name was the definite outlier in the dataset?

2. For the line chart, what was the percentile increase in Sum of Order Total on the day with the highest sales amount?

3. When the second highest day in terms of Order Total was identified as March 3rd , which of the two payment methods impacted positively to create the increase?

4. What is the default visual that the Analyze feature creates when the Explain the increase or Explain the decrease options are selected?

5. Which of these features are supported by Analyze feature in Microsoft Power BI? Select all that apply.

6. Which of these following visualizations is the most appropriate for time series analysis? Select all that apply.

7. Which of these following are types of Reference lines in Power BI? Select all that apply.

KNOWLEDGE CHECK: ANALYTICAL TOOLS IN POWER BI

1. Which of the following sentences describes what the Analyze feature in Microsoft Power BI automatically generates?

2. What is the primary objective of time series analysis in Microsoft Power BI?

3. What is the primary function of Reference lines in Power BI visualizations?

4. How do Reference lines enhance the readability and interpretation of visualizations?

5. What purpose do Error bars serve in Power BI visualizations?

6. Which of the following best defines seasonality in time-series data?

SELF-REVIEW: ROOT CAUSE ANALYSIS

1. According to the relevant chart created, what is the average CO2 emission of the vehicle with the largest volume of Engine Size?

2. Based on the results of the Key influencers visuals, which of the following fuel type attributes are scoring below the Average of CO2 emission line? Select all that apply.

3. Which of the following decomposition tree features are driven by AI algorithms? Select all that apply.

4. Which column of the VehicleDetails table does not add value when added to the Explain by field of an AI visual?

5. Between Manual transmission vehicles, what is the fuel type category with the lowest average CO2 emission? Use the decomposition tree to find the answer.

6. Which tool of the Key influencer visualizations groups major contributing influencers together?

7. In which of the following scenarios is the decomposition tree the most suitable visualization?

KNOWLEDGE CHECK: WORKING WITH AI VISUALS

1. Which of the following specialized tools of Power BI use AI algorithms to provide insights? Select all that apply.

2. What does the Top segments tool in the key influencers visualization do?

3. What are the primary purposes of the decomposition tree visualization in Power BI? Select all that apply.

4. What is the primary purpose of the Q&A visual in Microsoft Power BI?

5. The Q&A visualization provides wording underlying to showcase whether the natural language words were interpreted correctly. Which of the following underlying feedback is featured in the visualization? Select all that apply.

MODULE QUIZ: IDENTIFYING PATTERNS AND TRENDS

2. You are requested to enhance the readability of the new Microsoft Power BI report with the middle value of the data set. Which statistical function of Power BI should be used to calculate the result?

6. You’re analyzing website traffic data in Microsoft Power BI and want to highlight a period where the traffic exceeded the expected range, based on the business’ confidence intervals. Which capability in the Analytics pane of Power BI would you use to visually indicate this anomaly?

8. True or False: The Forecast feature in Microsoft Power BI’s Analytics pane not only predicts future values but also provides insight into the factors influencing those predictions.

9. You are assigned to include AI visuals in Adventure Works reports to enhance the results of your insights. Which of the following scenarios would align with the use of the key influencers visual in Microsoft Power BI?

10. You’re exploring the dynamic capabilities of Microsoft Power BI’s Q&A visual, which offers autocomplete suggestions and recognition feedback while you compose your queries. In this context, what does an orange dotted underline indicate during your query formulation?

13. You are requested to enhance the readability of the new Microsoft Power BI report by organizing an attribute into categories. The request is to categorize a sales country attribute column into 5 equal-sized groups. What Power BI analytics feature is the optimal tool to complete the request?

15. You’ve been tasked with analyzing quarterly sales data for the next year in Microsoft Power BI. Your goal is to provide insights into potential trends and performance. Which feature in the Analytics pane of Power BI should you use to visualize potential future trends in the data?

16. You’re tasked with enhancing your business reports using Microsoft Power BI’s analytics features. In which scenario would the Forecast feature from the Analytics pane be most beneficial?

17. You are assigned to include AI visuals in Adventure Works reports to enhance the results of your insights. Which of the following scenarios would align with the use of the key influencers visual in Microsoft Power BI?

18. Venturing into the technical capabilities of Microsoft Power BI, you’re intrigued by the Q&A visual’s potential. Which of the following accurately characterizes a key function of the Q&A visual?

19. A debate sparks between team members working on a Microsoft Power BI report. As the lead data analyst, you are requested to provide information regarding the type of visual that clustering can be applied to. Which of the following options is correct?

21. While preparing a sales performance report in Microsoft Power BI, you want to enhance your insights by adding the overall sales trend to show important milestones. Which feature in the Analytics pane of Power BI would you use for this purpose?

22. You are working with Microsoft Power BI to create a report based on sales data from Adventure Works. You have to add a measure to depict the variability of a set of data points from the average. Which statistical function of Power BI should be used to calculate the result?

23. You’re tasked with enhancing your business reports using Microsoft Power BI’s analytics features. You plan to include forecasting in your line charts. What is the primary purpose of the Confidence Band displayed alongside the Forecast line in Power BI’s Analytics pane?

24. Venturing into the technical capabilities of Microsoft Power BI, you’re intrigued by the Q&A visual’s potential. Which of the following natural language tasks can the Q&A visual in Power BI add in a visualization based on its capabilities? Select all that apply.

26. As part of your effort to provide more interactive reporting to your organization, you’re considering the use of AI visuals in Power BI. In which scenario would the Q&A visual be most appropriate?

27. In your sales analysis report, you’re investigating the quarterly revenue trends of your products. You want to mark a specific value on the visual to indicate the target revenue for each quarter. Which feature in the Analytics pane of Microsoft Power BI should you use for this purpose?

CONCLUSION – Identifying Patterns and Trends

Quiztudy Top Courses

Popular in Coursera

Mood Zone for Studying & Relaxing