Question 1

Which issues can you address by implementing accessibility features and practices in Microsoft Power BI reports? Select all that apply.

Accepted Answer

Making the report easily understandable to people who use assistive technologies for navigation. Ensuring visually impaired users can understand report visuals. Helping people with cognitive disabilities understand the report easily. (CORRECT)

Question 2

A data analyst in your organization cannot use a mouse due to a recent injury. Which feature should you implement in your Microsoft Power BI reports to assist her in navigating and interacting with them?

Accepted Answer

Tab order (CORRECT)

Question 3

Some of the executives in a recent meeting have complained about feeling overwhelmed by the multitude of visuals on your Microsoft Power BI reports. Which feature should you utilize in Power BI to improve their user experience?

Accepted Answer

Focus mode (CORRECT)

Question 4

One of your team members has low vision and relies on a screen reader to understand the contents of a Microsoft Power BI report. He said it was difficult to distinguish between different elements in the report, and the screen reader did not provide enough context for visuals. Which features should you utilize to improve his experience with your Power BI reports? Select all that apply.

Accepted Answer

High-contrast colors, Alt text (CORRECT)

Question 5

Your organization has committed to ensuring all Microsoft Power BI reports are accessible. You have implemented several measures, including adding alt text to all visuals and enabling keyboard navigation. However, feedback from a color-blind user indicates that they're having difficulty interpreting some visuals due to their color usage. Which of the following steps would be most appropriate to improve accessibility for color-blind users further?

Accepted Answer

Use high-contrast colors, shaded colors, or pattern fills (CORRECT)

Question 6

Which feature in Microsoft Power BI allows a user to view one visual at a time, potentially aiding users who might get overwhelmed with too many visuals?

Accepted Answer

Focus mode (CORRECT)

Question 7

In the context of creating accessible Power BI reports, what does adding alt text to visuals accomplish?

Accepted Answer

It provides a description of a visual for screen readers. (CORRECT)

Question 8

Which of the following are examples of conditional formatting in Power BI? Select all that apply.

Accepted Answer

Changing the background color of a cell in a table based on certain conditions, Changing the color of data bars based on their values, Customizing the color of bars in a bar chart based on predefined thresholds (CORRECT)

Question 9

What is the function of themes in Microsoft Power BI? Select all that apply.

Accepted Answer

Enhancing the visual consistency across reports, Enabling alignment of reports with brand guidelines, Improving the accessibility and readability of reports (CORRECT)

Question 10

What is the purpose of custom tooltips in Microsoft Power BI?

Accepted Answer

Custom tooltips enhance user engagement by providing interactive insights. (CORRECT)

Question 11

In a business intelligence dashboard, you have two visuals: the first visual represents sales by region, and the second visual represents sales by product. When you select the North region in the first visual, the sales data in the second visual adjusts to show only sales of products in the North region. What is this interaction called?

Accepted Answer

Cross-filtering (CORRECT)

Question 12

You’re exploring an interactive business intelligence dashboard that displays two main visuals. The first chart shows monthly sales across regions. The second chart is a stacked column chart depicting the relationship between Month, Order Quantity, and Order Status. When you select the June bar corresponding to the West region in the first chart, you observe that the columns representing June in the second chart start to highlight particular sections within the stacks. These highlighted portions show the Order Quantity and their respective Order Status for products sold in the West region during June. The rest of the data in the stacked column remains visible but less prominent. What is this interaction called?

Accepted Answer

Cross-highlighting (CORRECT)

Question 13

You are creating a multi-page business intelligence dashboard containing multiple levels of data from a retail chain. The main dashboard presents an overview of total sales across all stores. You want users who select the California section to be taken to another page of the report that provides detailed sales data specific to each store in that state, including top-selling products and customer feedback for each individual store. Which feature would be most useful for this deeper level of data exploration?

Accepted Answer

Drillthrough (CORRECT)

Question 14

You are working with a business report that displays monthly sales data for an entire year. You want to view only the sales data for the months of July, August, and September. Which feature could you use to narrow down and present only the desired data?

Accepted Answer

Filtering (CORRECT)

Question 15

Given the provided dataset on employee turnover, order the data points from the broadest (most general) level to the most specific level to establish a proper hierarchy.

Accepted Answer

Department, Region, Team, Turnover Rate (CORRECT)

Question 16

What is the benefit of using hierarchy in a report? Select all that apply.

Accepted Answer

Helps organize data from broad to specific levels, Creates a visual relationship among various data fields, Helps to create data drill down (CORRECT)

Question 17

What is the primary purpose of using drillthrough in Microsoft Power BI?

Accepted Answer

To navigate from a data point or visual in a main report to a detailed report page (CORRECT)

Question 18

Which of the following statements best describes the purpose of filtering in data analysis?

Accepted Answer

To screen out or focus on parts of the data based on specific conditions (CORRECT)

Question 19

What best describes the function of cross-filtering in visual reports?

Accepted Answer

It allows a selection in one visual to filter out unrelated data in another visual. (CORRECT)

Question 20

After creating the Sales Detail page in Step 1, what was the total sales revenue displayed in the visualization?

Accepted Answer

$345,200 (CORRECT)

Question 21

True or False: By adding the drillthrough configuration, Microsoft Power BI automatically creates a back arrow button for ease of navigation.

Accepted Answer

True (CORRECT)

Question 22

After adding a bookmark for Mountain Bikes sold in March in the final step, what is the total sales revenue displayed when the bookmark is clicked?

Accepted Answer

$63,500 (CORRECT)

Question 23

When synchronizing slicers, which of the following ensures that a slicer synchronizes when other slicers or visualizations are interacted with? Select all that apply.

Accepted Answer

Enable Sync filter changes to other slicers, Ensure that the group name is consistent, Enable Sync field changes to other slicers (CORRECT)

Question 24

Which of the following are the benefits of using buttons in a report? Select all that apply.

Accepted Answer

Buttons can apply all slicers and clear slicers. Buttons increase the interactivity of your report. Buttons improve the user experience for page navigation. (CORRECT)

Question 25

You added new visualizations to a report after previously creating a bookmark with the default options. When you select the bookmark, which of the following statements are true? Select all that apply.

Accepted Answer

The previous visualizations will have the bookmarked filters applied to it. The current page of the report will change to the bookmarked page. The new visualizations will appear in a default state. (CORRECT)

Question 26

Three visualizations, X, Y, and Z, are present in a report. In the Layer Order tab, X is listed first, Y second, and Z third. When the visualizations overlap in the report, which one appears on top?

Accepted Answer

X (CORRECT)

Question 27

At Adventure Works, products are split into 5 main categories. The CEO wants a way to quickly filter by category in the sales report. It is important that any new categories added in the future can also be filtered. Which of the following is most suitable for this task?

Accepted Answer

Slicer (CORRECT)

Question 28

Which of the following are benefits of adding buttons to a report? Select all that apply.

Accepted Answer

They increase the interactivity of the report. They improve the user experience (CORRECT)

Question 29

What is a hyperlink?

Accepted Answer

A link to a URL on the World Wide Web. (CORRECT)

Question 30

When selecting a bookmark, which of the following are restored by default? Select all that apply.

Accepted Answer

Visualizations state, Current report page, Slicers state (CORRECT)

Question 31

True or False: When a value in a slicer is selected, the DAX context changes for connected visualizations.

Accepted Answer

True (CORRECT)

Question 32

True or False: Evaluation context influences how calculations are performed in DAX but does not affect the results of the calculations.

Accepted Answer

False (CORRECT)

Question 33

As a data analyst at Adventure Works, you're tasked with creating a Microsoft Power BI report that is accessible to all users, including those with visual impairments. You're using Power BI to create a report, and you are asked to suggest a tool that provides an accessible way for users to zoom in on a specific visual. Which feature should be used for this purpose?

Accepted Answer

Focus mode (CORRECT)

Question 34

You're working on a Microsoft Power BI project for a retail company, and you want to make the line chart in your report more informative. How can you achieve this goal? Select all that apply.

Accepted Answer

By adding data labels to the line chart, By enabling the legend for the line chart (CORRECT)

Question 35

You're designing a Microsoft Power BI report that visualizes employee performance. You want to highlight the high-performing employees by changing the background color of their rows in a table visualization. How can you achieve this in Power BI?

Accepted Answer

By applying conditional formatting to the table (CORRECT)

Question 36

You're designing a Microsoft Power BI report for your company's annual performance review. You want to create a consistent and branded look for the report. Which feature in Power BI should you use to achieve this?

Accepted Answer

Themes (CORRECT)

Question 37

You're working on a Microsoft Power BI report for a retail company, and you want to enable users to dive deeper into the sales data by exploring product categories, subcategories, and individual products. Which feature should you use for this interactive exploration?

Accepted Answer

Drillthrough (CORRECT)

Question 38

You're designing a Microsoft Power BI report for a regional sales team, and you want to help them quickly identify the top-performing salespeople based on revenue. Which feature should you use to sort the salesperson data in descending order to display the highest revenue earners at the top of the table?

Accepted Answer

Sorting by column (CORRECT)

Question 39

You want to apply conditional formatting on a table visualization in Power BI. Which of the following are conditional formatting options in Microsoft Power BI? Select all that apply.

Accepted Answer

Data bars, Font color (CORRECT)

Question 40

What are the benefits of adding slicers to a report? Select all that apply.

Accepted Answer

Improved interactivity, Improved user experience (CORRECT)

Question 41

You have created a Microsoft Power BI report with several pages. You have added a bookmark to easily navigate to a specific filtered state. A viewer has requested that the report page shouldn’t change when the bookmark is clicked. Which action should you take?

Accepted Answer

Disable the current page option for the bookmark (CORRECT)

Question 42

What is a hyperlink?

Accepted Answer

An interactive link to a URL. (CORRECT)

Question 43

As a data analyst at Adventure Works, you're working on a sales report that includes a scatter plot. You want to ensure that users can easily identify and click on specific data points on the plot. What feature can you use for this purpose?

Accepted Answer

Enabling data point markers on the scatter plot (CORRECT)

Question 44

True or False: Themes in Microsoft Power BI are pre-defined or custom sets of design elements such as colors, fonts, and visual styles that can be applied to a report to adjust all visualizations to the theme, without the ability to customize specific colorings.

Accepted Answer

False (CORRECT)

Question 45

You're creating a Microsoft Power BI report for a supply chain management team. They need the ability to drill through to detailed information about specific products when clicking on a product category in a visual. Which actions are necessary to set up drillthrough capabilities for this scenario? Select all that apply.

Accepted Answer

Create a drillthrough page with relevant visuals and filters. Define drillthrough filters on the product category field. (CORRECT)

Question 46

You're working on a Microsoft Power BI report and need to arrange the data for better visualization. Which sorting techniques are available in Power BI for this purpose? Select all that apply.

Accepted Answer

Sort legend, Sort axis (CORRECT)

Question 47

You have created a sales report with multiple slicers in Microsoft Power BI. Viewers have complained that it is tedious to reset all the slicers when viewing the report. What is the best action to take to resolve this?

Accepted Answer

Add a button to clear all slicers (CORRECT)

Question 48

By default, which of the following is restored when a bookmark is selected? Select all that apply.

Accepted Answer

Current report page, Slicer state, Visualization state (CORRECT)

Question 49

True or False: Selecting a hyperlink in a Microsoft Power BI visualization will navigate the web browser to a URL.

Accepted Answer

True (CORRECT)

Question 50

As a Microsoft Power BI developer, you’ve been tasked with customizing the theme for a financial report. Which aspects of the report can be customized using themes in Power BI? Select all that apply.

Accepted Answer

Fonts and typography throughout the report, Colors used in visualizations (CORRECT)

Question 51

True or False: The Show as a table tool in Microsoft Power BI provides a text-based representation of the data in a visual, making it more accessible for screen readers.

Accepted Answer

True (CORRECT)

Question 52

You're building a Microsoft Power BI dashboard to visualize quarterly sales performance for multiple regions. To make the data more accessible, which feature should you use to display the total sales value directly on each column of a column chart?

Accepted Answer

Data labels (CORRECT)

Question 53

You're working on a Microsoft Power BI report that includes multiple pages and visuals. You want to apply a filter through the filter pane. Which of the following filter options are offered by the filter pane? Select all that apply.

Accepted Answer

Filters on this visual, Filters on this page, Filters on all pages (CORRECT)

Question 54

What is a URL?

Accepted Answer

An address to a resource on the World Wide Web. (CORRECT)

Question 55

In your role as a Microsoft Power BI report creator, you’re mindful of accessibility considerations. Why is it important to provide alternate text (alt text) for visuals in Power BI reports? Select all that apply.

Accepted Answer

Alt text complies with accessibility standards and regulations. Alt text helps users with visual impairments understand the content of visuals. (CORRECT)

Question 56

True or False: You're designing a Microsoft Power BI report that visualizes employee performance. You want to highlight the best-performing employees in a table visualization based on an attribute. Is conditional formatting able to dynamically highlight the top-performing employees on the table.

Accepted Answer

True (CORRECT)

Question 57

You're working on a Microsoft Power BI report and need to arrange the data for better visualization. Which sorting techniques are available in Power BI for this purpose? Select all that apply.

Accepted Answer

Sort axis, Sort legend (CORRECT)

Question 58

You previously shared a Microsoft Power BI report that contained a bookmark. A manager has since added a new visualization to the report and complained that the bookmark isn’t updating the new visualization. Which of the following statements is true? Select all that apply.

Accepted Answer

A new bookmark must be created to account for the new visualization. New visualizations added after the creation of the bookmark will appear in a default state. (CORRECT)

Question 59

You're building a Microsoft Power BI report for a sales analysis, and you want to allow users to view detailed information about sales by year, quarter, and month. Which feature should you use to enable this interactive exploration of data?

Accepted Answer

Drill-down (CORRECT)

Question 60

In Microsoft Power BI, when you interactively select a data point in one visual, and other visuals on the same page are filtered to show related data points, which feature is being used?

Accepted Answer

Cross-filtering (CORRECT)

COURSE 5 – DATA ANALYSIS AND VISUALIZATION WITH POWER BI

Module 2: Navigation and Accessibility

MICROSOFT POWER BI DATA ANALYST PROFESSIONAL CERTIFICATE

Complete Coursera Study Guide

TABLE OF CONTENT

INTRODUCTION – Navigation and Accessibility

Learning Objectives

KNOWLEDGE CHECK: DESIGNING AN ACCESSIBLE REPORT

1. Which issues can you address by implementing accessibility features and practices in Microsoft Power BI reports? Select all that apply.

2. A data analyst in your organization cannot use a mouse due to a recent injury. Which feature should you implement in your Microsoft Power BI reports to assist her in navigating and interacting with them?

3. Some of the executives in a recent meeting have complained about feeling overwhelmed by the multitude of visuals on your Microsoft Power BI reports. Which feature should you utilize in Power BI to improve their user experience?

6. Which feature in Microsoft Power BI allows a user to view one visual at a time, potentially aiding users who might get overwhelmed with too many visuals?

7. In the context of creating accessible Power BI reports, what does adding alt text to visuals accomplish?

8. Which of the following are examples of conditional formatting in Power BI? Select all that apply.

9. What is the function of themes in Microsoft Power BI? Select all that apply.

10. What is the purpose of custom tooltips in Microsoft Power BI?

KNOWLEDGE CHECK: REPORT NAVIGATION AND FILTERING

4. You are working with a business report that displays monthly sales data for an entire year. You want to view only the sales data for the months of July, August, and September. Which feature could you use to narrow down and present only the desired data?

5. Given the provided dataset on employee turnover, order the data points from the broadest (most general) level to the most specific level to establish a proper hierarchy.

6. What is the benefit of using hierarchy in a report? Select all that apply.

7. What is the primary purpose of using drillthrough in Microsoft Power BI?

8. Which of the following statements best describes the purpose of filtering in data analysis?

9. What best describes the function of cross-filtering in visual reports?

SELF-REVIEW: CREATING AN INTERACTIVE REPORT

1. After creating the Sales Detail page in Step 1, what was the total sales revenue displayed in the visualization?

2. True or False: By adding the drillthrough configuration, Microsoft Power BI automatically creates a back arrow button for ease of navigation.

3. After adding a bookmark for Mountain Bikes sold in March in the final step, what is the total sales revenue displayed when the bookmark is clicked?

4. When synchronizing slicers, which of the following ensures that a slicer synchronizes when other slicers or visualizations are interacted with? Select all that apply.

5. Which of the following are the benefits of using buttons in a report? Select all that apply.

6. You added new visualizations to a report after previously creating a bookmark with the default options. When you select the bookmark, which of the following statements are true? Select all that apply.

7. Three visualizations, X, Y, and Z, are present in a report. In the Layer Order tab, X is listed first, Y second, and Z third. When the visualizations overlap in the report, which one appears on top?

KNOWLEDGE CHECK: INTERACTIVE REPORT

1. At Adventure Works, products are split into 5 main categories. The CEO wants a way to quickly filter by category in the sales report. It is important that any new categories added in the future can also be filtered. Which of the following is most suitable for this task?

2. Which of the following are benefits of adding buttons to a report? Select all that apply.

3. What is a hyperlink?

4. When selecting a bookmark, which of the following are restored by default? Select all that apply.

5. True or False: When a value in a slicer is selected, the DAX context changes for connected visualizations.

6. True or False: Evaluation context influences how calculations are performed in DAX but does not affect the results of the calculations.

MODULE QUIZ: NAVIGATION AND ACCESSIBILITY

2. You’re working on a Microsoft Power BI project for a retail company, and you want to make the line chart in your report more informative. How can you achieve this goal? Select all that apply.

3. You’re designing a Microsoft Power BI report that visualizes employee performance. You want to highlight the high-performing employees by changing the background color of their rows in a table visualization. How can you achieve this in Power BI?

4. You’re designing a Microsoft Power BI report for your company’s annual performance review. You want to create a consistent and branded look for the report. Which feature in Power BI should you use to achieve this?

5. You’re working on a Microsoft Power BI report for a retail company, and you want to enable users to dive deeper into the sales data by exploring product categories, subcategories, and individual products. Which feature should you use for this interactive exploration?

7. You want to apply conditional formatting on a table visualization in Power BI. Which of the following are conditional formatting options in Microsoft Power BI? Select all that apply.

8. What are the benefits of adding slicers to a report? Select all that apply.

9. You have created a Microsoft Power BI report with several pages. You have added a bookmark to easily navigate to a specific filtered state. A viewer has requested that the report page shouldn’t change when the bookmark is clicked. Which action should you take?

10. What is a hyperlink?

11. As a data analyst at Adventure Works, you’re working on a sales report that includes a scatter plot. You want to ensure that users can easily identify and click on specific data points on the plot. What feature can you use for this purpose?

12. True or False: Themes in Microsoft Power BI are pre-defined or custom sets of design elements such as colors, fonts, and visual styles that can be applied to a report to adjust all visualizations to the theme, without the ability to customize specific colorings.

14. You’re working on a Microsoft Power BI report and need to arrange the data for better visualization. Which sorting techniques are available in Power BI for this purpose? Select all that apply.

15. You have created a sales report with multiple slicers in Microsoft Power BI. Viewers have complained that it is tedious to reset all the slicers when viewing the report. What is the best action to take to resolve this?

16. By default, which of the following is restored when a bookmark is selected? Select all that apply.

17. True or False: Selecting a hyperlink in a Microsoft Power BI visualization will navigate the web browser to a URL.

18. As a Microsoft Power BI developer, you’ve been tasked with customizing the theme for a financial report. Which aspects of the report can be customized using themes in Power BI? Select all that apply.

19. True or False: The Show as a table tool in Microsoft Power BI provides a text-based representation of the data in a visual, making it more accessible for screen readers.

20. You’re building a Microsoft Power BI dashboard to visualize quarterly sales performance for multiple regions. To make the data more accessible, which feature should you use to display the total sales value directly on each column of a column chart?

21. You’re working on a Microsoft Power BI report that includes multiple pages and visuals. You want to apply a filter through the filter pane. Which of the following filter options are offered by the filter pane? Select all that apply.

22. What is a URL?

23. In your role as a Microsoft Power BI report creator, you’re mindful of accessibility considerations. Why is it important to provide alternate text (alt text) for visuals in Power BI reports? Select all that apply.

25. You’re working on a Microsoft Power BI report and need to arrange the data for better visualization. Which sorting techniques are available in Power BI for this purpose? Select all that apply.

26. You previously shared a Microsoft Power BI report that contained a bookmark. A manager has since added a new visualization to the report and complained that the bookmark isn’t updating the new visualization. Which of the following statements is true? Select all that apply.

27. You’re building a Microsoft Power BI report for a sales analysis, and you want to allow users to view detailed information about sales by year, quarter, and month. Which feature should you use to enable this interactive exploration of data?

28. In Microsoft Power BI, when you interactively select a data point in one visual, and other visuals on the same page are filtered to show related data points, which feature is being used?

CONCLUSION – Navigation and Accessibility

Quiztudy Top Courses

Popular in Coursera

Mood Zone for Studying & Relaxing