Question 1

True or False: When you go back to the desktop layout of your dashboard, the mobile optimized layout is deleted, and you need to create it again next time you log in to Microsoft Power BI service?

Accepted Answer

False (CORRECT)

Question 2

From the generated report, which of the following is the most profitable product category?

Accepted Answer

Components (CORRECT)

Question 3

Based on the dashboard, how many units have been sold?

Accepted Answer

6,560 (CORRECT)

Question 4

True or False: Both Microsoft Power BI dashboards and Microsoft Power BI reports can have multiple pages or tabs.

Accepted Answer

False (CORRECT)

Question 5

Adventure Works Customer Service manager wants to visualize an overview of customer satisfaction every Monday morning. As a principal data analyst, you need to design a dashboard, which elements you should include in your dashboard?

Accepted Answer

Customer support ticket volume, Total return volume, Customer satisfaction rate (CORRECT)

Question 6

What component of the Power BI ecosystem is needed to create and optimize dashboards for smartphones?

Accepted Answer

Power BI Service (CORRECT)

Question 7

What are the key characteristics of Microsoft Power BI report design? Select all that apply.

Accepted Answer

Drill through functionality, Interactive filtering (CORRECT)

Question 8

What is the primary goal of creating a dashboard in Power BI?

Accepted Answer

Providing high level insights about the data. (CORRECT)

Question 9

True or False: Once you publish your Power BI report to Power BI service, you can still edit and make changes to any chart of your report in the Power BI service.

Accepted Answer

True (CORRECT)

Question 10

When you publish a Power BI report to Power BI service, which of the following components are also published to the service? Select all that apply.

Accepted Answer

Underlying dataset, The data model and relationships, All measures you created. (CORRECT)

Question 11

True or False:You have created a dashboard in Power BI service and when you select mobile layout, all the visual elements automatically appear in edit mobile layout pane?

Accepted Answer

True (CORRECT)

Question 12

You have multiple graphs and charts in your Power BI report. One of the charts shows real-time data about the click trough rates (CTR) of the company’s website. Which of the following is the best dashboard to include this tile?

Accepted Answer

Marketing dashboard (CORRECT)

Question 13

You are designing a dashboard for the Adventure Works inventory management team. The team needs real-time access to the inventory levels while inspecting the warehouse. What is the most appropriate way to include this information in the dashboard?

Accepted Answer

Create a QR code of the tile containing the inventory level of products and use the code as an email attachment, orattachment or display it in a common area of your office. (CORRECT)

Question 14

What file types are supported in a Microsoft Power BI dashboard? Select all that apply.

Accepted Answer

PNG, JPG, BMP (CORRECT)

Question 15

True or False: In Microsoft Power BI service, you can pin a visual element from one dashboard to another dashboard.

Accepted Answer

True (CORRECT)

Question 16

In Microsoft Power BI, which media types can you add to a dashboard using Edit > Add a tile. Select all that apply.

Accepted Answer

Video, Image, Web content (CORRECT)

Question 17

What live streaming data is stored in Microsoft Power BI memory?

Accepted Answer

Push dataset (CORRECT)

Question 18

Your junior colleague designed a dashboard in Microsoft Power BI service, shared it with you, and requested that you duplicate and edit the dashboard.

Accepted Answer

True (CORRECT)

Question 19

Which live streaming dataset is stored in Power BI service to support full report functionality?

Accepted Answer

Push dataset (CORRECT)

Question 20

Which media types are supported by Microsoft Power BI service? Select all that apply.

Accepted Answer

An image published online. A video hosted on Vimeo. A YouTube playlist. (CORRECT)

Question 21

True or False:  You can generate a QR code for any tile of the shared dashboard.

Accepted Answer

True (CORRECT)

Question 22

You have presented a story as a Power BI report for the sales team. Your manager needs to have a QR code for the entire report for easy distribution among the team members. What is the best option you can opt for to fulfil your manager's needs?

Accepted Answer

Publish report to Power BI service and generate a QR code of the report. (CORRECT)

Question 23

Which alternative chart type can you use instead of a column chart to display current revenue and revenue from the previous year without losing clarity?

Accepted Answer

Bar chart (CORRECT)

Question 24

How does your storytelling approach help to present the company’s growth in a more engaging and understandable manner? Select all that apply.

Accepted Answer

By choosing the correct chart type for visualization, By crafting a clear narrative, By designing a logical canvas layout (CORRECT)

Question 25

True or False: You have crafted a growth story for Adventure Works, based on the scenario presented. Both you and the CEO of the company are characters in this data story.

Accepted Answer

True (CORRECT)

Question 26

What term describes an important benefit that data provides to help the audience interpret your data story?

Accepted Answer

Context (CORRECT)

Question 27

Who can be a character in the data story? Select the correct option.

Accepted Answer

A CEO, A data analyst, A marketing manager (CORRECT)

Question 28

What are benefits of effective visualization in data storytelling?

Accepted Answer

Improve audience engagement, Reveal patterns and trend, Provide context (CORRECT)

Question 29

What is the role of a business analytic tool such as Microsoft Power BI in the data storytelling process?

Accepted Answer

It increases understanding of the narrative by providing context throughout your data story. (CORRECT)

Question 30

In the context of data storytelling, what does the term conflict refer to?

Accepted Answer

A central issue or challenge that the data analyst aims to resolve. (CORRECT)

Question 31

True or False: You have received a donut chart showing the total sales broken down by 13 individual countries. In terms of data storytelling best practices, a donut chart is not an appropriate chart type to display this data.

Accepted Answer

True (CORRECT)

Question 32

What purposes does data visualization have in data storytelling? Select all that apply.

Accepted Answer

To improve audience engagement. To provide context and interpret results. To explore and communicate data patterns effectively to the stakeholders. (CORRECT)

Question 33

You are analyzing the Adventure Works sales data for Australia. What is the best way to color code a map visual in the context of data storytelling in Power BI?

Accepted Answer

Add a single color with different saturation levels based on the sales amount. (CORRECT)

Question 34

True or False: You cannot add an interactive slicer to your dashboard in the Microsoft Power BI service.

Accepted Answer

True (CORRECT)

Question 35

True or False. You can create and optimize a dashboard in Microsoft Power BI desktop.

Accepted Answer

False (CORRECT)

Question 36

You are working in a fast-paced environment where you need to manage multiple reports and dashboards. What best practices can streamline your workflow? Select all that apply.

Accepted Answer

Copying dashboard tiles. Duplicating dashboards. (CORRECT)

Question 37

Which Microsoft Power BI component allows you to generate QR codes?

Accepted Answer

Microsoft Power BI service (CORRECT)

Question 38

True or False: You cannot upload a video directly to a Microsoft Power BI dashboard from your local computer.

Accepted Answer

True (CORRECT)

Question 39

Microsoft Power BI service supports three types of live-streaming datasets. Which of these live-streaming datasets allows you to build a report on top of the data?

Accepted Answer

Push dataset (CORRECT)

Question 40

In data storytelling, which component creates the connection between your narrative and your audience?

Accepted Answer

Visualization (CORRECT)

Question 41

You are provided with a Microsoft Power BI report that contains a lot of connected data tables, calculated columns, and measures to display specific business metrics. You are asked to craft a data story in the form of a dashboard to show the impact of marketing efforts on sales of the company. What is the primary step you should take before designing a Marketing dashboard?

Accepted Answer

Data exploration to identify which fields are needed to support the story. (CORRECT)

Question 42

You published a report to Microsoft Power BI service from your desktop and created a dashboard. You are unable to pin your company logo to the dashboard from your report. What possible solution could you use to add your company logo?

Accepted Answer

Publish the logo file online with an HTTPS connection and then add a URL to a media tile in the dashboard. (CORRECT)

Question 43

What are common mistakes to avoid when designing dashboards? Select all that apply.

Accepted Answer

Inconsistent labeling, Not scaling your charts, Including unrelated data (CORRECT)

Question 44

What are possible reasons to duplicate a dashboard in Microsoft Power BI service? Select all that apply.

Accepted Answer

You need to create multiple dashboards with slight variations. You want to test the performance of the dashboard by applying a few changes. (CORRECT)

Question 45

True or False: The Microsoft Power BI service does not allow you to add a video playlist to your dashboard.

Accepted Answer

False (CORRECT)

Question 46

What is a critical factor of data in the context of data storytelling?

Accepted Answer

Data context (CORRECT)

Question 47

You are working as a Microsoft Power BI consultant in a big analytics company. What common issues could contribute to poor storytelling? Select all that apply.

Accepted Answer

A chaotic dashboard layout. Each tile of dashboard showing an independent story. Improper chart for the data type presented. (CORRECT)

Question 48

What is the key consideration when determining the level of detail to include in a dashboard?

Accepted Answer

Prioritize the most valuable information and avoid presenting too much data. (CORRECT)

Question 49

You are a Microsoft Power BI report designer for a retail company that has a diverse portfolio of products. The marketing head of the company needs a quick overview of the impact of the most recent marketing campaign. Which Microsoft Power BI visualizations will you choose to present to the marketing manager?

Accepted Answer

A dashboard (CORRECT)

Question 50

Once you select a tile on a dashboard (by clicking or tapping), what action is executed?

Accepted Answer

The source report of the tile is opened on the screen. (CORRECT)

Question 51

When crafting a dashboard for your story, what common issues could arise when incorporating colors into your visualization? Select all that apply.

Accepted Answer

Using too many colors makes it difficult for the viewers to understand the message. Using colors having little contrast. Using colors without considering accessibility (CORRECT)

Question 52

In the context of data storytelling, what is the primary advantage of using images and video in a Microsoft Power BI dashboard?

Accepted Answer

Images and videos create an emotional connection for audience engagement. (CORRECT)

Question 53

What describes the characteristics of Microsoft Power BI reports? Select all that apply.

Accepted Answer

Reports are detailed and structured documents. Reports support filtering and drill-through. (CORRECT)

Question 54

True or False: You can only optimize a dashboard in Microsoft Power BI service.

Accepted Answer

True (CORRECT)

Question 55

True or False: In Power BI, you can optimize both reports and dashboards for mobile devices.

Accepted Answer

True (CORRECT)

Question 56

In Microsoft Power BI service, which live-streaming datasets store data in Microsoft Power BI memory?

Accepted Answer

Push dataset (CORRECT)

Question 57

True or False: Microsoft Power BI service dashboards cannot display images published online that require external authorization to view.

Accepted Answer

True (CORRECT)

Question 58

What should be the guiding principle when selecting a chart or graph to visualize your data in a report or dashboard?

Accepted Answer

Choose a chart that is appropriate for the data and the message. (CORRECT)

Question 59

Which visualization elements can you generate QR codes for? Select all that apply.

Accepted Answer

An entire report. A tile from a dashboard. (CORRECT)

Question 60

Which live-streaming datasets can you use for report-building functionality, such as applying filters and slicers?

Accepted Answer

Push dataset (CORRECT)

COURSE 6 – CREATIVE DESIGNING IN POWER BI

Module 3: Dashboard Design and Storytelling

MICROSOFT POWER BI DATA ANALYST PROFESSIONAL CERTIFICATE

Complete Coursera Study Guide

TABLE OF CONTENT

INTRODUCTION – Dashboard Design and Storytelling

Learning Objectives

SELF-REVIEW: OPTIMIZING A DASHBOARD

1. True or False: When you go back to the desktop layout of your dashboard, the mobile optimized layout is deleted, and you need to create it again next time you log in to Microsoft Power BI service?

2. From the generated report, which of the following is the most profitable product category?

3. Based on the dashboard, how many units have been sold?

4. True or False: Both Microsoft Power BI dashboards and Microsoft Power BI reports can have multiple pages or tabs.

5. Adventure Works Customer Service manager wants to visualize an overview of customer satisfaction every Monday morning. As a principal data analyst, you need to design a dashboard, which elements you should include in your dashboard? Select all that apply.

6. What component of the Power BI ecosystem is needed to create and optimize dashboards for smartphones?

KNOWLEDGE CHECK: IMPROVING DASHBOARD DESIGN

1. What are the key characteristics of Microsoft Power BI report design? Select all that apply.

2. What is the primary goal of creating a dashboard in Power BI?

3. True or False: Once you publish your Power BI report to Power BI service, you can still edit and make changes to any chart of your report in the Power BI service.

4. When you publish a Power BI report to Power BI service, which of the following components are also published to the service? Select all that apply.

5. True or False:You have created a dashboard in Power BI service and when you select mobile layout, all the visual elements automatically appear in edit mobile layout pane?

6. You have multiple graphs and charts in your Power BI report. One of the charts shows real-time data about the click trough rates (CTR) of the company’s website. Which of the following is the best dashboard to include this tile?

KNOWLEDGE CHECK: ADDITIONAL DASHBOARD ELEMENTS

1. You are designing a dashboard for the Adventure Works inventory management team. The team needs real-time access to the inventory levels while inspecting the warehouse. What is the most appropriate way to include this information in the dashboard?

2. What file types are supported in a Microsoft Power BI dashboard? Select all that apply.

3. True or False: In Microsoft Power BI service, you can pin a visual element from one dashboard to another dashboard.

4. In Microsoft Power BI, which media types can you add to a dashboard using Edit > Add a tile. Select all that apply.

5. What live streaming data is stored in Microsoft Power BI memory?

6. Your junior colleague designed a dashboard in Microsoft Power BI service, shared it with you, and requested that you duplicate and edit the dashboard. True or False: You cannot make a copy of the dashboard and apply any changes.

7. Which live streaming dataset is stored in Power BI service to support full report functionality?

8. Which media types are supported by Microsoft Power BI service? Select all that apply.

9. There is a shared dashboard in your Power BI workspace. You cannot edit it because you are not the creator. True or False: You can generate a QR code for any tile of the shared dashboard.

SELF-REVIEW: THE ELEMENTS OF A DATA STORY

1. You have presented a story as a Power BI report for the sales team. Your manager needs to have a QR code for the entire report for easy distribution among the team members. What is the best option you can opt for to fulfil your manager’s needs?

2. Which alternative chart type can you use instead of a column chart to display current revenue and revenue from the previous year without losing clarity?

3. How does your storytelling approach help to present the company’s growth more engagingly and understandably? Select all that apply.

4. True or False: You have crafted a growth story for Adventure Works, based on the scenario presented. Both you and the CEO of the company are characters in this data story.

5. What term describes an important benefit that data provides to help the audience interpret your data story?

6. Who can be a character in the data story? Select the correct option.

7. What are benefits of effective visualization in data storytelling? Select all that apply.

KNOWLEDGE CHECK: PRINCIPLES OF DATA STORYTELLING

1. What is the role of a business analytic tool such as Microsoft Power BI in the data storytelling process?

2. In the context of data storytelling, what does the term conflict refer to?

3. True or False: You have received a donut chart showing the total sales broken down by 13 individual countries. In terms of data storytelling best practices, a donut chart is not an appropriate chart type to display this data.

4. What purposes does data visualization have in data storytelling? Select all that apply.

5. You are analyzing the Adventure Works sales data for Australia. What is the best way to color code a map visual in the context of data storytelling in Power BI?

MODULE QUIZ: DASHBOARD DESIGN AND STORYTELLING

1. True or False: You cannot add an interactive slicer to your dashboard in the Microsoft Power BI service.

2. True or False. You can create and optimize a dashboard in Microsoft Power BI desktop.

3. You are working in a fast-paced environment where you need to manage multiple reports and dashboards. What best practices can streamline your workflow? Select all that apply.

4. Which Microsoft Power BI component allows you to generate QR codes?

5. True or False: You cannot upload a video directly to a Microsoft Power BI dashboard from your local computer.

6. Microsoft Power BI service supports three types of live-streaming datasets. Which of these live-streaming datasets allows you to build a report on top of the data?

7. In data storytelling, which component creates the connection between your narrative and your audience?

9. You published a report to Microsoft Power BI service from your desktop and created a dashboard. You are unable to pin your company logo to the dashboard from your report. What possible solution could you use to add your company logo?

10. What are common mistakes to avoid when designing dashboards? Select all that apply.

11. What are possible reasons to duplicate a dashboard in Microsoft Power BI service? Select all that apply.

12. True or False: The Microsoft Power BI service does not allow you to add a video playlist to your dashboard.

13. What is a critical factor of data in the context of data storytelling?

14. You are working as a Microsoft Power BI consultant in a big analytics company. What common issues could contribute to poor storytelling? Select all that apply.

15. What is the key consideration when determining the level of detail to include in a dashboard?

17. Once you select a tile on a dashboard (by clicking or tapping), what action is executed?

18. When crafting a dashboard for your story, what common issues could arise when incorporating colors into your visualization? Select all that apply.

19. In the context of data storytelling, what is the primary advantage of using images and video in a Microsoft Power BI dashboard?

20. What describes the characteristics of Microsoft Power BI reports? Select all that apply.

21. True or False: You can only optimize a dashboard in Microsoft Power BI service.

22. True or False: In Power BI, you can optimize both reports and dashboards for mobile devices.

23. In Microsoft Power BI service, which live-streaming datasets store data in Microsoft Power BI memory?

24. True or False: Microsoft Power BI service dashboards cannot display images published online that require external authorization to view.

25. What should be the guiding principle when selecting a chart or graph to visualize your data in a report or dashboard?

26. Which visualization elements can you generate QR codes for? Select all that apply.

27. Which live-streaming datasets can you use for report-building functionality, such as applying filters and slicers?

CONCLUSION – Dashboard Design and Storytelling

Quiztudy Top Courses

Popular in Coursera

Mood Zone for Studying & Relaxing

9. There is a shared dashboard in your Power BI workspace. You cannot edit it because you are not the creator. True or False:  You can generate a QR code for any tile of the shared dashboard.