COURSE 6 – CREATIVE DESIGNING IN POWER BI

INTRODUCTION – Designing Powerful Report Pages

SELF-REVIEW: OPTIMIZING A REPORT FOR MOBILE

1. How many visual elements exist in the report design before the mobile layout?

2. In the bubble chart of the report, what does the size of the bubble represent?

3. True or False: After you select a mobile layout for a report, you can change the title properties of any visual element. This setting does not affect the desktop layout.

4. What is the percentage difference of the Goal value to the Sales values in the KPI visual of the report?

5. What is the correct path to format the title of the chart?

6. A local retail company has sales operations in three major cities, the company wants to present the distribution of sales across the cities. Which of the following chart type best presents the percentage contribution by cities towards total sales ensuring visual clarity? Select all that apply.

7. Which feature of Power BI desktop allows you to see a single visual in the entire report screen?

8. Adventure Works wants to analyze its sales data over time,  including year level and daily sales values. The company also wants to analyze each salesperson’s performance over the same time period. Which report design best displays the required data?

9. To visualize an Adventure Works Key Performance Indicator (KPI), Microsoft Power BI has a built-in visual called KPI. Which other visual from the visualization pane you can use to display KPI values?

10. Which statements are true about dot plot chart? Select all that apply.

11. In Microsoft Power BI, which visual can you use to display three numerical data values?

12. Which statement best describes the drill down operation in Power BI?

13. True or False: When you format the visuals in the mobile layout canvas, all the formatting, such as font size, will automatically change in the original desktop version of the report?

KNOWLEDGE CHECK: LAYING OUT A REPORT

1. Which Power BI visual is used for visualizing the density and distribution of data across geographical regions or grids?

2. In the Power BI mobile layout which pane lists all the visuals that are included on the original report page?

3. True or False: Changing settings in the mobile layout does not affect the desktop layout.

4. Which chart type is used for exploring relationships between two numerical variables?

5. Which chart type displays a single metric and its performance against a target or baseline?

SELF-REVIEW: VISUALIZING DATA BY GEOGRAPHICAL LOCATION

1. How many state records exist in the data set?

2. What is the total sales value for the state of California in the Shapemap?

3. What was the data category of the State field before you applied any transformation?

4. What data type is most suitable for a shape map visual in Power BI?

5. What are some common use cases for choropleth maps in data visualization?

6. What is the correct procedure for utilizing choropleth maps in Power BI to visualize data effectively?

7. True or False: You can create a geo-hierarchy in Power BI using a shape map visual from the core visualizations pane?

8. Which of the following map styles are available to use in the filled map visual of Power BI? Select all that apply.

9. What is the key difference between Shape and Filled maps in Power BI visualizations?

10. Which Azure map visual feature allows you to display custom information when the user hovers over a data point?

KNOWLEDGE CHECK: MAP VISUALS

1. What visuals are a geographic representation of areas, such as countries, states, or regions, that are shaded or patterned to illustrate quantitative data values?

2. Which of the following projection methods is used to display three-dimensional earth as a two-dimensional cylindrical projection that converts the globe into a grid, with each rectangular cell having the same size, shape, and area?

3. True or False: Shape maps are most effective when visualized data has clear geographic boundaries.

4. What is the format of the vector files generally used in Shape Maps?

5. What visual connects to a cloud service hosted to retrieve location data, such as map images and coordinates used to create the map visualization?

KNOWLEDGE CHECK: CUSTOM VISUALIZATIONS

1. What is the potential security risk of using external Python libraries in Microsoft Power BI?

2. How can you use Python in Microsoft Power BI? Select all that apply.

3. True or False: Custom visuals can be created in the Microsoft Power BI desktop and can then be published and shared through the Power BI service.

4. You are working with a multiple-table data model. If you enable Python scripting in Power BI and import the visualization library, what is the most important thing to do before creating Python visuals?

5. What is a potential limitation of a Python visualization in Power BI?

6. Which of the following statements describes how you can create custom visualizations in Power BI? Select all that apply.

7. True or False: Data fields from different tables must have defined relationships between them.

MODULE QUIZ: DESIGNING POWERFUL REPORT PAGES

1. While working on a dataset and designing a report, you realize that you need to use a specialized chart type that is not available in the Microsoft Power BI Visualization pane. How do you solve this problem? Select all that apply.

2. In a KPI visual, what is typically represented as the main metric?

3. How can you create a Bubble chart in Microsoft Power BI desktop? Select all that apply.

4. You are creating visualizations for a complex dataset in Microsoft Power BI to uncover correlations, patterns, and insights from the raw data. Upon careful review of the data, you realize the dataset contains multiple numerical fields. What is the primary challenge when plotting the current dataset?

5. Your task is to design a Microsoft Power BI report that is accessible and accommodates the needs of all users. What accessibility features can you include in your report? Select all that apply.

6. You are a data analyst in an environmental agency. You are responsible for analyzing air quality, temperature variations, and pollution levels in various regions. A map visualization is an ideal approach to visualize such data. Which of the following visuals is most suited to representing this type of data?

7. What are typical use case scenarios for a Filled map visual in Microsoft Power BI? Select all that apply.

8. True or False: The Microsoft Azure map visual provides better formatting and control options than other map visuals in Microsoft Power BI?

9. True or False: When using a Python visualization in Microsoft Power BI, the Python visual creates a dataframe. To create the dataframe, you need to bring all the required fields to the Values section of the visual.

10. You are working in a marketing agency analyzing website traffic. You want to highlight which areas of the website receive the most and the least clicks. Which chart type can you use to best visualize this data?

11. What programming languages can you use to create custom visuals in Microsoft Power BI reports? Select all that apply.

12. What additional elements are often included in a KPI visual to provide context for the metric? Select all that apply.

13. What advantages does a Dot plot give you over other visualizations for comparing data points? Select all that apply.

14. You are creating visualizations for a complex dataset in Microsoft Power BI to uncover correlations, patterns, and insights from the raw data. Upon careful review of the data, you realize the dataset contains multiple numerical fields. Which chart type should you choose?

15. True or False: You have created a combo chart in Microsoft Power BI with primary and secondary y-axes. Power BI allows you to visualize the chart data in a table form without creating a separate table visual.

16. Adventure Works has multiple stores located in different regions and wants to analyze its sales values at various granular levels from countries to stores. As a principal data analyst, which visualization approach do you think is most suitable?

17. When using Azure maps what field of the visual is used to represent a numerical value such as sales?

18. True or False: You are working with an Adventure Works dataset with sales and categories. You have created a Bar chart using a Python visualization. You need to change the chart color and size. You can use the Format visual choice in Power BI to format Python-based visuals.

19. Adventure Works wants to analyze market share by its product categories and subcategories. Which type in Microsoft Power BI is the best option to display this data in a single visual?

20. What are the prerequisites for using Python-based visualizations in Microsoft Power BI? Select all that apply.

21. You are creating visualizations for a complex dataset in Microsoft Power BI to uncover correlations, patterns, and insights from the raw data. Upon careful review of the data, you realize the dataset contains multiple numerical fields. What is the primary challenge when plotting the current dataset?

22. True or False: You have created a Bar chart in Microsoft Power BI using Python and matplotlib. To create color consistency with other Power BI charts, you must format the color scheme of the Bar chart from the Format visual tab in the Visualization pane of Power BI.

23. What Microsoft Power BI features is designed to help visually impaired users understand the content within a chart?

24. What map visuals are available in Microsoft Power BI’s core visualizations pane? Select all that apply.

25. You are building a Power BI report that needs to display up-to-date boundary information for different countries. What map type allows you to visualize this type of information?

26. True or False: Comparing a large number of data points is the common characteristic feature of a Scatter chart, a Bubble chart, and a Dot plot chart.

27. You are working as a Microsoft Power BI report designer in a multi-national retail organization. All the organization’s data is hosted on Microsoft Cloud. The company wants to analyze the number of franchises in various regions and the sales amount associated with each franchise. Which map visual is the best choice for this?

28. In a Microsoft Power BI core KPI visual, which chart is automatically plotted when you add the main measure and trend axis to the visual fields.

29. True or False: In Microsoft Power BI, you cannot plot geographical information if the dataset does not have longitude and latitude columns.

30. True or False: Heat maps are not available by default in the core Visualization pane of Microsoft Power BI?

31. You have a data model containing tables called region, sales, and product. Your task is to present categorical data that shows the correlation between sales and profit for each product category. Which chart type in Microsoft Power BI best suits your purpose?

CONCLUSION – Designing Powerful Report Pages