COURSE 6 – CREATIVE DESIGNING IN POWER BI

by
Contents hide
1 Module 4: Final Project and Assessment: Creative Design in Power BI
2 INTRODUCTION – Final project and assessment: Creative Design in Power BI
3 SELF-REVIEW: ADVENTURE WORKS QUARTERLY REPORT
4 COURSE QUIZ CREATIVE DESIGN IN POWER BI
5 CONCLUSION – Final project and assessment: Creative Design in Power BI
Spread the love

Module 4: Final Project and Assessment: Creative Design in Power BI

INTRODUCTION – Final project and assessment: Creative Design in Power BI

This week, you will be evaluated on the key skills you have developed throughout the course, ensuring a strong understanding of the essential concepts and techniques covered. A comprehensive course summary will also be provided, serving as a valuable reference as you reflect on the primary learning objectives and your achievements.

Additionally, you will have the chance to work on a culminating project that brings together your learning in a practical context. This project will allow you to showcase your proficiency and understanding in a real-world scenario, reinforcing the knowledge and skills you’ve gained while providing a clear representation of your progress and accomplishments.

Learning Objectives:

  • Synthesize the skills from this course by completing a graded assessment.
  • Reflect on the course content and the learning journey ahead.

SELF-REVIEW: ADVENTURE WORKS QUARTERLY REPORT

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?

  • Publish report to Power BI service, create a dashboard and pin report visuals to the dashboard and generate QR code.
  • Publish report to Power BI service, pin entire report to dashboard and generate QR code.
  • Publish report to Power BI service and generate a QR code of the report. (CORRECT)

That’s correct! You can publish your report to Power BI service and generate a QR code for the entire report.

2. In the exercise, you created visualizations for the sales data. Based on the visualizations, Adventure Works has ______________ in sales amount for the second quarter of 2020?

  • 0.14M
  • 0.19M (CORRECT)
  • 0.41M

That’s correct! Adventure Works has 0.19M in sales for the second quarter of 2020.

3. Based on the story presented to the executive board, what is the primary concern the story reveals?

  • The 1st quarter sales of 2020 is lower than the same period last year.
  • Despite an increase in the sales, the profit margin is negligible. (CORRECT)
  • Australia has no sales for the first quarter of 2020.

That’s correct! Data shows only 0.06% profit margin and that’s the major concern despite an increase in sales. 

4. You presented the quarterly sales performance story to the executive board by applying the filters for years and quarters to the data visualization. In Microsoft PowerBI, what is an alternative waythat you can present these measures without creating slicers and filters?

  • By using DAX logic. (CORRECT)
  • By using SQL queries.  
  • By using Power Query editor. 

That’s correct! You can create specific measures by using DAX formula language to display quarterly sales for both years without creating slicers and filters.

5. True or False: Tsvi Reiter is the top-performing salesperson of Adventure Works for the first quarter of 2020.

  • True
  • False (CORRECT)

6. What alternative chart types can you use to visualize sales by country without losing clarity and impact? Select all that apply.

  • Map visual (CORRECT)
  • Bar chart (CORRECT)
  • Waterfall chart
  • Line chart

Exactly! Power BI offers various types of map visualizations that are ideal for visualizing sales data across different geographic regions.

Correct! A bar chart is essentially a column chart rotated by 90 degrees and can effectively display data without losing clarity or impact.

COURSE QUIZ CREATIVE DESIGN IN POWER BI

1. What methods are used to combine various colors to construct a color scheme? Select all that apply.

  • Harmonious
  • Analogous (CORRECT)
  • Complementary  (CORRECT)
  • Triadic (CORRECT)

Exactly! Analogous colors are those that sit next to each other on the color wheel.

Correct! The complementary color system pairs colors that are opposite each other on the color wheel.

That’s right! The triadic color system selects three colors that are evenly spaced around the color wheel, forming a triangle.

2. The Microsoft Power BI core visualization pane does not have a dedicated dot plot chart. To create a dot plot chart, you use a variation of which chart?

  • Scatter chart (CORRECT)
  • Bubble chart
  • Area chart

That’s correct! In Microsoft Power BI core visualization, there is no dedicated dot plot chart available, it is a variation of a scatter plot. Alternatively, you can install a dot plot chart from AppSource.

3. As a Microsoft Power BI report and dashboard designer, creating a cohesive design is crucial in data storytelling. What factors contribute to a cohesive design that enhances audience engagement? Select all that apply.

  • Use of media elements.
  • Consistent color schemes. (CORRECT)
  • Consistent typography. (CORRECT)
  • Use of grids and guides. (CORRECT)

Exactly! Using a consistent color scheme throughout the report promotes cohesiveness and reinforces the brand identity.

Correct! Consistency in typography is key to creating a unified look and feel. It’s important to select fonts that are readable and match the overall design style.

That’s right! Grids and guides help ensure precise positioning and scaling of visual elements on the report canvas, maintaining consistency across the design.

4. True or False:You have activated a built-in theme from Microsoft Power BI desktop and customized it. You will need to customize the theme again the next time you log in to Microsoft Power BI and start creating reports.

  • True
  • False (CORRECT)

That’s correct! Once you customize the theme according to your needs, you can save the modified theme so that next time, you do not need to apply changes again.

5. Microsoft Power BI desktop supports many accessibility tools. You want to add an image to your report canvas in an accessible way. What are the keyboard keys you need to use to navigate to the Insert tab of Power BI desktop?

  • Install the visualization libraries of Python. (CORRECT)
  • Make sure the Microsoft Power BI Python home directory path is correct. (CORRECT)
  • Install Python. (CORRECT)
  • Transform data using Python in the query editor.

Exactly! Python by itself isn’t enough; you’ll need to install visualization libraries like Seaborn and Matplotlib to use Python effectively in your reports.

Correct! After installing Python and its libraries, you must ensure that the home directory path is set correctly in Microsoft Power BI Desktop.

That’s right! Installing Python on your computer is essential to use Python-based visualizations in your Microsoft Power BI reports.

6. What is a prerequisite of using Python-based visualizations in Microsoft Power BI? Select all that apply.

  • Encourage a results-oriented culture based on competition
  • Create equal opportunity to succeed (CORRECT)
  • Invite and integrate diverse perspectives (CORRECT)
  • Foster a culture of respect (CORRECT)

To ensure equal opportunities for success, project managers should provide team members with the necessary information and resources to excel. They should also prioritize fostering respect and incorporating diverse perspectives into the team’s work.

Creating an inclusive culture requires project managers to encourage the sharing, listening, and integration of diverse perspectives in decision-making. Equally important is fostering respect and ensuring every team member has the tools and opportunities to succeed.

Project managers can foster a culture of respect by leading by example, demonstrating core values, and addressing issues proactively. Additionally, they should strive to create equal opportunities for success and embrace diverse perspectives in the team’s processes.

7. Which map visual is not available in the core visualization pane of Microsoft Power BI?

  • Filled maps
  • 3D maps (CORRECT)
  • Shape maps

That’s correct! You cannot create 3D maps from the core visualization pane of Microsoft Power BI. Installing a custom visual from AppSource can solve this problem.

8. In a Microsoft Power BI KPI chart, what is the ideal field to use as a trend axis? Select all that apply.

  • Year (CORRECT)
  • Countries
  • Month (CORRECT)
  • Categories

That’s correct! If you want to track the sales performance over the years, then a year field should be added as a trend axis.

That’s correct! If you want to track the sales performance over the months, then a month field should be added as a trend axis

9. True or False: You created a report in Microsoft Power BI desktop and published it to Microsoft Power BI service. After publishing it, you realize the report was not optimized for mobile devices. You must go back to Power BI desktop, optimize it, and publish it again.

  • True
  • False (CORRECT)

10. Which chart type can be used to visualize the single data point against a pre-defined target value?

  • A gauge (CORRECT)
  • A KPI
  • A card visual

That’s correct! In a Gauge you can visualize the value against the target without the use of a trend axis.

11. In Microsoft Power BI, which chart is most suitable to display three numerical values, enabling you to analyze complex relationships among variables?

  • A dot plot chat
  • A scatter plot
  • A 3D scatter plot (CORRECT)

That’s correct! With the use of a 3D scatter plot, you can visualize three numerical values and their relationship to analyze complex data structures.

12. Choropleth maps visual of Microsoft Power BI sends geographical information to which map service provider?

  • Google maps
  • Bing maps (CORRECT)
  • Waze maps

That’s correct! Choropleth maps send location information to Bing maps to retrieve the latest geographic boundary information.

13. What are the potential limitations of using Python for visualization inside Microsoft Power BI? Select all that apply.

  • Python visuals do not support renaming columns and fields in Microsoft Power BI. (CORRECT)
  • Using Python in Microsoft Power BI raises security concerns. (CORRECT)
  • Python has limited visualization capabilities.
  • The input data size is limited to 250MB. (CORRECT)

Exactly! You can’t rename columns and fields directly within the Microsoft Power BI formatting options; any changes require modifications in the source script.

Correct! Integrating external Python scripts can pose security risks for organizations, as running external code may expose vulnerabilities or compromise data privacy.

That’s right! Python’s dataset size in Power BI is limited to 250K rows, and the input data is capped at 250 MB.

14. Which chart type allows you to use the play axis in addition to the x and y-axis in the chart visuals?

  • A bubble chart (CORRECT)
  • Scatter chart
  • A dot plot chart

That’s correct! The play axis is another important feature of the bubble chart visual in Microsoft Power BI where you can add a year or month field to the play axis, and Microsoft Power BI animates the bubble movement over time.

15. What type of formatting can you perform in the conditional formatting option of Microsoft Power BI? Select all that apply.

  • Table columns fonts (CORRECT)
  • Chart title
  • Column colors (CORRECT)
  • Chart background color

Exactly! In a table visual, Microsoft Power BI allows you to highlight variations in data values by applying conditional formatting, such as font color, background color, or data bars.

Correct! You can also apply conditional formatting to the column colors in your column chart to visually represent variations in sales values, for instance.

16. In any dataset, there are often outliers or data points that deviate significantly from the norm. These outliers can provide valuable insights or indicate areas that require attention from the decision-makers. What is the best way to highlight the outliers in your report?

  • By making the text bold.
  • By using a different color. (CORRECT)
  • By creating a card visual.

That’s correct! Color has an instant reaction, therefore changing the color of the outliers in your data is the best option to highlight this piece of information.

17. What factors contribute towards achieving data integrity while analyzing and visualizing data in Microsoft Power BI? Select all that apply.

  • Using data validation. (CORRECT)
  • Using error detection. (CORRECT)
  • Using HTTPS (Hypertext Transfer Protocol Secure) protocol.
  • Using transport layer security (TSL) protocols.

That’s correct! Data validation involves verifying the accuracy and integrity of input data to ensure it meets predefined criteria and is a crucial factor in ensuring data integrity.

That’s correct! Error detection is a factor in ensuring data integrity that focuses on identifying mistakes or anomalies in data, helping prevent erroneous information from causing problems.

11.Which of the following are true of work groups? Select all that apply.

  • M
  • SQL
  • DAX (CORRECT)

That’s correct! Microsoft Power BI allows you to write DAX formulas to define the custom rules for conditional formatting of your charts and tables.

19. True or False: When using Python-based visualization in Microsoft Power BI, you must bring all the fields you want to use for visualization into the Values section of the Python visual.

  • True (CORRECT)
  • False

That’s correct! You need to add all fields you want to use to create a custom visual in the Values section of the Python visual. A Python script can only use fields added to the Values section by creating a dataframe.

20. What elements should you consider while designing a report in Microsoft Power BI to maximize the report’s impact for all types of viewers? Select all that apply.

  • You must limit the report to one page.
  • You need to emphasize storytelling techniques. (CORRECT)
  • You need to introduce interactivity to engage users. (CORRECT)
  • You should only include the key metrics and KPIs in your report.

That’s correct! Reports are designed to tell a data-driven story. You need to arrange visual elements in a logical sequence to guide users about the introduction, main body, and conclusion of the story.

That’s correct! In the report design, you must consider adding slicers, filters, and drill-down and drill-through functionality to access granular data.

21. What is the prerequisite of an image upload to Microsoft Power BI dashboard? Select all that apply.

  • Image resolution should be 300 dpi
  • Image should be published online (CORRECT)
  • The image should not have security credentials set on (CORRECT)
  • Image should not be an .SVG format (CORRECT)

Exactly! All images need to be published online before you can add them to your dashboard, as Microsoft Power BI does not support adding images from your local computer.

Correct! Images that are published online must not have security credentials, meaning they should be publicly accessible without needing to log in to an account.

That’s right! Microsoft Power BI does not support the .SVG image file format; you can use JPG or PNG formats instead.

22. You are a Microsoft Power BI developer in Adventure Works handling the customer service information and creating a real-time dashboard to draw key insights about the number of support request tickets opened and closed. What information should you include in your dashboard? Select all that apply.

  • Customer support ticket volume over time. (CORRECT)
  • Real-time view of open tickets. (CORRECT)
  • Provide demographic information of customers.
  • Highlight frequently reported problems. (CORRECT)

That’s correct! Customer support ticket volume is related to customer service so you must include this information in your dashboard.

That’s correct! Including a real-time view of open tickets provides valuable information about the products and services provided by the company.

That’s correct! Frequently reported problems help the management to devise a strategy for resolving the issue.

23. You want to add an external URL to your Microsoft Power BI dashboard. What methods allow you to add external web sources as hyperlinks to your dashboard? Select all that apply.

  • Select web content and embed the code. (CORRECT)
  • Add an image file and use the title and subtitle as hyperlinks. (CORRECT)
  • Add the site as a hyperlink in the text box tile. (CORRECT)
  • Pin the visual from the Microsoft Power BI report containing the URL.

Exactly! In the Microsoft Power BI service, you can add a tile and select the web content option to embed external web sources as code.

Correct! In the image, you can enable the title and subtitle checkbox and add an external URL to create a hyperlink.

That’s right! In the text box tile of a dashboard, you can enter text and convert it into a hyperlink.

24. You are working on a dashboard that needs to display real-time data. Your manager said you might also need to dig deeper into the granular details of the data for which you must create some report visual, particularly creating filter and drill-down functions. What is the best option you could choose as a live-streaming dataset for your Microsoft Power BI dashboard?

  • Push dataset (CORRECT)
  • PubNub streaming dataset
  • Streaming dataset

That’s correct! With Push dataset, the data is physically stored in Microsoft Power BI memory, which allows you to build any report on top of the data. Therefore, the Push dataset is the best option you can employ in this case.

25. What element of data storytelling helps in the comprehension of the message presented through your story?

  • Visualization (CORRECT)
  • Narrative
  • Data

That’s correct! In the context of data storytelling, visualization educates your audience on your proposed theory. By creating a connection between the visual elements and your narrative, you can engage the audience and present both granular and summarized data points.

26. You are visualizing salesperson performance in a Microsoft Power BI report. There are thirteen people on the sales team. For both reports and dashboards, what is the best chart option?

  • A bar chart (CORRECT)
  • A pie chart
  • A column chart

That’s correct! A bar chart is a variation of a column chart with a 90-degree rotation and is the ideal choice to visualize sales by each salesperson and a best fit for your dashboard.

27. What is the correct approach in color coding the map visualization in Microsoft Power BI?

  • Use shades of same color family. (CORRECT)
  • Use divergent colors to make the map visually appealing.
  • Use analogous colors from the color wheel.

That’s correct! In a map visual, the best practice is to use shades of the same color family to indicate the sales amount in proportion to the intensity or saturation of the color.

28. For which type of visual elements can you create a QR code in Microsoft Power BI? Select all that apply.

  • An individual tile of your dashboard. (CORRECT)
  • An individual visual element from your report.
  • An entire dashboard.
  • An entire report. (CORRECT)

That’s correct! Microsoft Power BI service allows you to generate a QR code for any tile of the dashboard even if you do not own the dashboard.

That’s correct! You can create a QR code for the entire report in Microsoft Power BI service, but first, you must publish your report from Microsoft Power BI desktop to Microsoft Power BI service.

29. True or False: In Microsoft Power BI service, you are optimizing a dashboard for cellular devices. At the end of your optimization, you realize something went wrong. You can move all the tiles to the unpinned tiles pane by selecting Reset tiles.

  • True
  • False (CORRECT)

That’s correct! You need to select Unpin tiles to move all tiles to the unpin tiles pane.

30. In the context of color theory, how many color combinations are available to use from the color wheel?

  • 3
  • 4 (CORRECT)
  • 5

That’s correct! In the color wheel, there could be four different combinations, namely, analogous, monochromatic, complementary, and triadic.

31. In the Microsoft Power BI core visualization pane, which chart type can optimize high-density information in the limited space of a report canvas? Select all that apply.

  • Line chart
  • Bubble chart (CORRECT)
  • Scatter plot (CORRECT)
  • Dot plot chart (CORRECT)

Exactly! A bubble chart lets you add a third numerical data dimension by representing it as the size of the bubble.

Correct! A scatter plot is useful for visualizing high-density data with multiple numeric values, helping identify trends and relationships.

That’s right! A dot plot chart allows you to visualize multidimensional data, with a particular focus on categorical information along the horizontal axis.

32. In addition to creating custom visualizations, what other ways can Python be used in Microsoft Power BI? Select all that apply.

  • Creating measures.
  • Data transformation. (CORRECT)
  • Data connectivity. (CORRECT)
  • Configuring relationships.

Exactly! You can use Python within the Power Query editor to perform complex data transformations, enhancing your data manipulation capabilities.

Correct! Python can also be utilized to retrieve external data sources, perform web scraping, and connect to databases, providing flexibility in data acquisition.

33. You are visualizing temperature variation data for an environment agency. A map visual is an ideal option for this type of visualization. The dataset does not contain latitude and longitude coordinates, what is the first step you should take before creating any visualization?

  • Ensure there are proper relationships between data tables.
  • Select an appropriate map type from the visualization pane of Microsoft Power BI.
  • Format the geographic field of the dataset as an appropriate data category. (CORRECT)

That’s correct! You need to format the data category of the geographic field within your dataset, so that Microsoft Power BI recognizes this field as a location to accurately position on the map visual.

34. In Microsoft Power BI desktop, which map types support the creation of a geo-hierarchy? Select all that apply.

  • Filled maps (CORRECT)
  • Shape maps
  • Map (CORRECT)
  • Azure maps (CORRECT)

Exactly! Microsoft Power BI’s filled map lets you create a geo-hierarchy using the location fields available in your dataset.

Correct! The Map visual in Power BI also allows you to build a geo-hierarchy for visualizing geographic data.

That’s right! You can create a geo-hierarchy in Azure map visuals within Microsoft Power BI to represent spatial data effectively.

35. Which Microsoft Power BI core visuals can be used to track performance against pre-defined targets? Select all that apply.

  • A Funnel chart
  • A KPI chart (CORRECT)
  • A Waterfall chart
  • A Gauge  (CORRECT)

That’s correct! A KPI chart is designed to track performance against a set target. A trend axis is required to track the performance.

That’s correct! A gauge from the visualization pane can also be used to visualize the current values against the target.

36. Adventure Works has two product categories: Bikes and Accessories. The Bikes category has only 7 products, while the Accessories category has more than 30 products. Using one chart for each category, you must visualize the product sales. For the Bikes category, as there are only 7 products, you can use a pie or a column chart. What strategy would you use to display the data for the Accessoriescategory?

  • Visualize the sales amount over time and create a product slicer for interactive analysis. (CORRECT)
  • You can write DAX logic to group products for visualization.
  • Use scatter charts as they are designed to visualize high-density data.

That’s correct! Creating a slicer as a vertical list or drop-down is the best option to visualize sales values for each product in the Accessories category over time.

37. Which chart type allows you to visualize a multi-dimensional data type with two numerical values?

  • A bubble chart (CORRECT)
  • An area chart
  • A dot plot chart

That’s correct! A bubble chart allows you to add an additional numerical value as the size of the bubble.

38. True or False: In Microsoft Power BI you can add an image as a report background?

  • True (CORRECT)
  • False

That’s correct! Microsoft Power BI allows you to add an image file to your report background to complement your message. You can adjust the overlay color and opacity so the image will not interfere with the charts and graphics of your report.

39. Data anonymization is an effective technique used to protect the privacy and confidentiality of data during data analysis and visualization. In what ways can you achieve anonymization? Select all that apply.

  • B: Validation
  • Consistency checks
  • Noise addition (CORRECT)
  • Generalization (CORRECT)

Exactly! Noise addition introduces controlled random variation into the data, making it more difficult to deduce specific details about individuals or sensitive data.

Correct! Generalization simplifies or aggregates data, often elevating it to a higher level of abstraction to protect privacy or reduce complexity.

40. Which of the following color type is used for focal points of your report, capturing users’ immediate attention?

  • Accent colors (CORRECT)
  • Semantic colors
  • Dominant colors

That’s correct! Accent colors are used for focal points of your report, capturing users’ immediate attention. Examples include call-to-action buttons, alerts, and warning messages.

41. What media type can you include in your dashboard to indicate the title and conclusion of the story?

  • A logo file.
  • A text box. (CORRECT)
  • A text box from Microsoft Power BI report.

That’s correct! You can select the text box after enabling Add a tile. In the text box, you can write and format your title and conclusion of the data story.

42. In the context of data storytelling, which element is the central point around which you build your plot and create the storyline?

  • Narrative
  • Conflict (CORRECT)
  • Visualization

Feedback: That’s correct! Conflict is central to your data story. In the context of data storytelling, the conflict is your business problem or data challenge.

43. In the process of data storytelling, which step deals with the establishment of a functional data model?

  • Data collection and preparation. (CORRECT)
  • Data visualization.
  • Data analysis and exploration.

That’s correct! Before you start the process of storytelling, you need structured data that you obtained from various sources. A functional data model must be in place before you start the process of data analysis and exploration, which provides the main message of your story.

44. In the data storytelling process, what is the role of business analytic tools?

  • They provide automation for chart selection
  • They provide context to your data story (CORRECT)
  • They provide structure to your data story

That’s correct! Business analytic tools provide a necessary platform to interpret the data within the context and enable users to understand the key insights and highlights of the data.

45. True or False: If you scan the QR code from your Microsoft Power BI mobile app, the app takes you to the workspace where the dashboard is created.

  • True
  • False (CORRECT)

46. In the edit mobile layout screen of Microsoft Power BI service, how many panes are present to optimize your dashboard?

  • 2 (CORRECT)
  • 3
  • 1

That’s correct! The edit mobile layout screen consists of two panes: the edit mobile layout, and the unpinned tiles panes.

47. In Microsoft Power BI, you want to visualize sales and profit with respect to countries or product categories in a single chart. What is the best option to visualize this information?

  • Scatter chart
  • Dot plot chart (CORRECT)
  • Line chart

That’s correct! A dot plot chart enables you to visualize multidimensional data with particular emphasis on categorical information on the horizontal axis. Therefore, you can visualize all numerical values with respect to countries or categories on the x-axis using a dot plot chart.

48. True or False:Microsoft Power BI allows you to customize its built-in theme to fulfill your business and visualization requirements without uploading a JSON (JavaScript Object Notation) file or writing any code.

  • True (CORRECT)
  • False

49. You are a Microsoft Power BI analyst and report designer in a multinational home décor company that has developed a customized color scheme as their brand asset. The company insists on using their brand color schemes in all Microsoft Power BI reports. How can you incorporate this color scheme into your Microsoft Power BI workflow?

  • Apply a Microsoft Power BI built-in theme that resembles the company’s brand color scheme and perform further adjustments based on HEX codes.
  • Build the color scheme and upload it to Microsoft Power BI as a custom theme. (CORRECT)
  • Create a report and save it as a template for future use.

That’s correct! You can create your own color palette in the form of a JSON file and upload it to Microsoft Power BI desktop as a custom theme. This will create a consistent use of customized colors for a brand throughout your report design.

50. After activating the accessible option by selecting the Alt key, you want to configure some relationships between data tables. Which keyboard key takes you to the Modelling tab of Microsoft Power BI desktop?

  • I
  • M (CORRECT)
  • R

That’s correct! The M key navigates to the Model view of Microsoft Power BI, where you can configure the relationships between the data tables.

51. True or False: You can optimize both Microsoft Power BI report and dashboard in Microsoft Power BI service.

  • True (CORRECT)
  • False

That’s correct! Microsoft Power BI service allows you to optimize your reports and dashboards.

52. You have a hierarchical data structure showing the proportions of quantities for categories within a whole. Which Microsoft Power BI visual is the best choice to visualize this type of data structure?

  • A treemap (CORRECT)
  • A pie chart
  • A dot plot cha

That’s correct! Treemaps are ideal for displaying hierarchical data and comparing the proportions of data points across various levels.

53. True or False: In addition to Python, which other programming language in Microsoft Power BI allows you to create and manage custom visualizations to meet your analytical and visualization needs.

  • R (CORRECT)
  • SQL
  • JavaScript

That’s correct! R programming is rich in statistical language with visualization libraries that you can employ in Microsoft Power BI to create and manage custom visualizations.

54. You are visualizing data in the form of a table visual, and you need to highlight some key information from a column. What formatting options do you have in conditional formatting? Select all that apply.

  • Adding a bar (CORRECT)
  • Formatting the cell’s background color (CORRECT)
  • Formatting the font color (CORRECT)
  • Selectively changing the background of each cell

Feedback: That’s correct! In conditional formatting, you can add data bars to emphasize the key information trends. 

That’s correct! In conditional formatting, you can format the background color of the cell for emphasis. 

That’s correct! Font color is the most common formatting in conditional formatting to highlight key trends and anomalies of the data by changing the color.

55. What factors can help you understand your audience’s needs and expectations while you are designing your Microsoft Power BI reports? Select all that apply.

  • Cultural considerations (CORRECT)
  • Information needs (CORRECT)
  • Job function  (CORRECT)
  • Data source requirements

Exactly! Assessing cultural and demographic factors is key to understanding the audience’s preferences and how they interpret information.

Correct! Determining the specific information needs of the audience helps ensure the data or metrics provided are relevant to their decision-making process.

That’s right! Identifying the roles or job functions within your audience is crucial, as each role may have different data requirements and preferences.

56. Your data model contains 3 data tables: sales, product, and date. You need to create a Python-based visual displaying sales of product categories over time. In addition to the installation of Python and its libraries, what is the primary step you must ensure to avoid any error in visualization?

  • Make sure the data tables have appropriate relationships. (CORRECT)
  • Make sure the Python visualization libraries are up to date.
  • Make sure the dataset does not have duplicate values

That’s correct! Without the appropriate relationship between data tables of the data model, Python will not be able to visualize data because you need to bring date from the date table, product categories from the product table, while sales values must come from the sales fact table.

57. True or False: Microsoft Power BI does not allow you to pin an entire report that you published from Microsoft Power BI desktop to a dashboard.

  • True
  • False (CORRECT)

58. True or False: Microsoft Power BI service allows you to add a hyperlink within the description of a text box tile.

  • True (CORRECT)
  • False

That’s correct! You can write your description about the story by adding a text box tile to your dashboard and you can convert any piece of text to a hyperlink by inserting a URL.

59. You need to visualize the real-time data in your Microsoft Power BI dashboard as per the analytical requirement of the business. How many live-streaming data options does Microsoft Power BI support?

  • 3 (CORRECT)
  • 5
  • 1

60. What element of the data storytelling process provides evidence and context for the story?

  • Narrative
  • Data (CORRECT)
  • Visualization

That’s correct! Data is the core of data storytelling. It provides context, substance, and evidence to convey the primary message of your story to your audience.

61. In Microsoft Power BI, which map visuals provide multiple layers and better control options?

  • Shape map
  • Filled map
  • Azure maps (CORRECT)

That’s correct! In Azure maps, you can control the map settings and format its style by selecting multiple layers. Azure maps has the option of heat maps, filled maps, and bubble layers to select for specific visualization needs.

62. What information does a KPI chart display if properly visualized and formatted? Select all that apply.

  • Target value (CORRECT)
  • Percentage difference (CORRECT)
  • Sales breakdown by trend axis.
  • Time  (CORRECT)

Exactly! When you create a KPI chart and enter the current and target values into the respective wells, the KPI visual automatically displays the target values as a goal.

Correct! The KPI visual also automatically calculates and displays the percentage difference between the current and target values as negative or positive values.

That’s right! The last period, whether it’s a month, quarter, or year depending on the trend axis, is also displayed on the KPI chart.

63. Which elements contribute toward making an appropriate chart selection for creating a compelling data story? Select all that apply.

  • Data type  (CORRECT)
  • Data quality.
  • Your audience.  (CORRECT)
  • The message you want to convey.  (CORRECT)

Exactly! When you create a KPI chart and enter the current and target values into the respective wells, the KPI visual automatically displays the target values as a goal.

Correct! The KPI visual also automatically calculates and displays the percentage difference between the current and target values as negative or positive values.

That’s right! The last period, whether it’s a month, quarter, or year depending on the trend axis, is also displayed on the KPI chart.

64. What chart types are a variation of a scatter chart in the Microsoft Power BI desktop core visualization pane? Select all that apply.

  • A dot plot chart (CORRECT)
  • A treemap
  • A bubble chart (CORRECT)
  • A combo chart

Exactly! A dot plot is a variation of a scatter plot that uses categorical data on the horizontal axis of the visual, making it useful for visualizing relationships between categories.

Correct! The bubble chart is not directly available in the core visualization pane in Microsoft Power BI. You need to select a scatter chart and convert it to a bubble chart, as it’s essentially a variation of the scatter chart.

65. Which of the following is the visualization library used in Python for Microsoft Power BI custom visualization? Select all that apply.

  • Ggplot
  • Pip
  • Seaborn (CORRECT)
  • Matplotlib (CORRECT)

That’s correct! Seaborn is a versatile statistical library of Python used to create engaging and interactive visualizations.

That’s correct! Matplotlib is a comprehensive Python library that creates static, animated, and interactive visualizations.

66. True or False: Microsoft Power BI service allows you to add interactive elements like slicers and filters to your dashboard.

  • True
  • False (CORRECT)

67. You are a Microsoft Power BI developer in Adventure Works. The marketing manager has recently finalized a targeted marketing campaign and she needs a dashboard displaying the key metrics and insights of the campaign. What information do you need to include on the dashboard? Select all that apply.

  • Click-through rates. (CORRECT)
  • Competitor analysis. (CORRECT)
  • Website traffic information. (CORRECT)
  • Customer satisfaction scores.

That’s correct! Click-through rates (CTR) directly measure the effectiveness of the marketing campaign therefore, you need to include this information in your dashboard.

That’s correct! Competitor analysis also provides key insights into the potential competitors for the marketed product lines of the company.

That’s correct! Website traffic information, including time on a specific page of the site provides valuable information about the impact of a better business website.

68. What type of videos can you add to the Microsoft Power BI dashboard?

  • A Playlist hosted on YouTube. (CORRECT)
  • A single video published on your social media.
  • A single video hosted on YouTube. (CORRECT)
  • A single video saved to your local computer.

Exactly! You can add a complete video playlist as an external link by enabling the title and subtitle in the dashboard video tile, making it easy to display multiple related videos.

Correct! Any video hosted on YouTube can be embedded in your dashboard as a tile in the Microsoft Power BI service, allowing for rich multimedia integration.

69. True or False: Typically, you create a report in Microsoft Power BI desktop, and then to create a QR code for the report, you must publish the report to Microsoft Power BI online.

  • True (CORRECT)
  • False

That’s correct! Only Microsoft Power BI service allows you to generate a QR code for your report or dashboard tile therefore, you must publish your report before creating the code.

70. In Microsoft Power BI, what are viable options to use a customized color scheme for your reports and dashboards? Select all that apply.

  • Build a new theme from Microsoft Power BI desktop.
  • Customize any built-in theme of Microsoft Power BI to match your design needs. (CORRECT)
  • Create your own color scheme and upload it to Microsoft Power BI as a JSON file. (CORRECT)
  • Build a new theme for the query editor.

That’s correct! You can activate any built-in theme and customize it according to the visualization requirements.

That’s correct! If your organization has its own brand color identity. You can create a JSON file from these colors and upload it to Microsoft Power BI as a custom theme to use in your reports and dashboards.

71. True or False: In Microsoft Power BI desktop, the shape map visual does not support the creation of a geo-hierarchy.

  • True (CORRECT)
  • False

That’s correct! Shape map visuals in Microsoft Power BI work with custom regions or shapes therefore, they do not support the generation of geo-hierarchy.

72. Which component of the Microsoft Power BI ecosystem can you use to optimize a dashboard for mobile devices?

  • Microsoft Power BI service  (CORRECT)
  • Microsoft Power BI desktop
  • Microsoft Power BI mobile app

73. You are working on a complex dataset and need to create a visual out of the data. Microsoft Power BI core visualizations do not meet your requirements. What options do you have to create a custom visual in Microsoft Power BI desktop? Select all that apply.

  • Install a custom visual from AppSource. (CORRECT)
  • Use Python to create custom visuals. (CORRECT)
  • Use R programming to generate a custom visual. (CORRECT)
  • Use Mand query editor to design a custom visual.

Exactly! Microsoft Power BI AppSource offers a wide range of custom visualizations that can be downloaded and installed to meet your specific visualization requirements, expanding the default options available.

Correct! Python, with libraries like Seaborn and Matplotlib, enables you to create highly interactive and engaging visualizations, enhancing the visual appeal and insights of your Power BI reports.

That’s right! R programming is well-suited for statistical analysis and offers powerful visualization libraries that you can leverage in Power BI to create custom visualizations tailored to your data.

74. True or False: In Microsoft Power BI service, you need to create a dashboard for the sales and marketing department of the company. You must create each visual element you want to include in your dashboard, to your Microsoft Power BI desktop report, publish it to service, and then pin the visuals to your dashboard.

  • True
  • False (CORRECT)

That’s correct! In Microsoft Power BI dashboard, in addition to the visual from your report, you can also add a tile to add media elements or live-streaming data.

75. Data storytelling is the art of using data and visuals to build compelling narratives. It helps to convey a message, highlight trends, and engage a wide audience. Which tools provide key insights and understanding to your narrative by providing the context for your data story?

  • Data visualization tools.
  • Data manipulation tools.
  • Business analytic tools. (CORRECT)

76. In the context of color theory, what does harmony refer to?

  • The arrangement of colors in a specific design. (CORRECT)
  • The arrangement of colors that exist next to each other on a color wheel.
  • A color system composed of opposite hues on the color wheel.

78. In Microsoft Power BI desktop, which map visual sends geographical data to Bing maps?

  • Azure maps
  • Choropleth maps (CORRECT)
  • Shape maps

That’s correct! Choropleth maps benefit from Bing Maps’ extensive geographic database, providing accurate and up-to-date boundary information.

79. Which functions can you use to let viewers navigate from one page of the report to another with more details about the data?

  • Drillthrough (CORRECT)
  • Drill down
  • Slicers

That’s correct! Drillthrough functionality allows users to navigate to different pages of the report with associated information.

80. True or False: You can use a Python-based visualization library inside Microsoft Power BI to visualize data on a heat map.

  • True (CORRECT)
  • False

That’s correct! Python and its rich visualization libraries allow you to create a heat map to visualize your data.

81. You are working as a report designer in a childcare organization where younger children are the direct users of your report. What elements should you keep in mind while designing and presenting reports? Select all that apply.

  • Use clean and professional design.
  • Use engaging icons. (CORRECT)
  • Use vibrant colors. (CORRECT)
  • Introduce interactive elements. (CORRECT)

That’s correct! The use of simple and enjoyable icons that are easy to interpret adds value to a report designed for younger children.

That’s correct! Younger children are attracted to bright and bold colors therefore, you must consider using vibrant colors while designing your reports.

That’s correct! Interactive features, such as buttons or draggable elements, make the experience more interactive for younger children.

82. You have created a custom color palette for your Microsoft Power BI reports and visualizations. What file format do you need to save to upload to Microsoft Power BI as a custom theme?

  • JSON (CORRECT)
  • DOCX
  • XLSX

That’s correct! Microsoft Power BI only allows a JSON file as a custom theme to integrate your own color scheme into your reports and visualizations.

83. What is the primary characteristic of a compelling dashboard?

  • It must be understandable and actionable. (CORRECT)
  • It should contain the key metrics of the business.
  • It should be visually appealing.

That’s correct! The primary characteristic of an effective dashboard is that it must be understandable by a broad audience. Decision-makers can take necessary actions based on the analysis presented.

84. In the context of report cohesion, what elements contribute towards achieving a visual hierarchy? Select all that apply.

  • Grids and guides.
  • Headings and subheadings. (CORRECT)
  • Strategic positioning. (CORRECT)
  • Font size. (CORRECT)

Exactly! The use of headings and subheadings helps establish a clear structure, guiding the reader through the logical flow of the report and creating a strong visual hierarchy.

Correct! Proper positioning of visual elements within the report canvas is key to organizing information logically and ensuring that related data is grouped together for easier comprehension.

That’s right! Font sizes play a critical role in creating a visual hierarchy by drawing attention to key elements and differentiating levels of importance in the report.

85. You have recently joined as a data analyst at Adventure Works and received a Microsoft Power BI report. You’ve been asked to create coherence in the report. There is one chart in the report that differs from all the others, in terms of colors, fonts, and style. The Visualization pane, Format tab does not allow you to format the chart’s colors, fonts, and style. You discover that the chart is created using Python. How can you create consistency in the report?

  • Delete the chart and use a Microsoft Power BI core visualization that you can format according to the requirements.
  • Delete the chart and install a custom visual from AppSource that allows you to format the chart.
  • Modify the Python code to change the color, font, and style of the chart. (CORRECT)

That’s correct! When using a Python-based visualization in Microsoft Power BI, you cannot format the visual using the Microsoft Power BI format visual tab controls. To change the color, style, and font size, you must modify the source script that is used to build the Python visual.

86. You are working to visualize the density and distribution of information across geographical regions. Your management prefers to use a heat map. The Microsoft Power BI core visualization does not have a dedicated heat map visual. What options could you use to accomplish the visualization? Select all that apply.

  • Use a shape map and turn on the heat map control option.
  • Download and install a heat map visual from AppSource. (CORRECT)
  • Use Azure maps and turn on the heat map control option. (CORRECT)
  • Use Python-based heat map visuals. (CORRECT)

That’s correct! AppSource is the Microsoft Power BI marketplace where you can download and install custom visualizations. You can install a heat map from this source and use this for your visualization.

Ezoic

That’s correct! You can turn on the heat map layer of an Azure map visual and fulfill the visualization requirements of your analysis.

That’s correct! Python visualization libraries such as Seaborn and Matplotlib also contain heat map visualization that you can use, but remember you need to write a Python script to create and format the visual.

87. True or False: Generalization is a type of data anonymization where a deliberate removal of certain data elements is performed to prevent identifying individuals or sensitive information.

  • True
  • False (CORRECT)

88. True or False: Slicers are an important feature of Microsoft Power BI visualizations, but you should limit the use of this feature to avoid confusion in your data storytelling approach.

  • True (CORRECT)
  • False

That’s correct! Overuse of slicers is one of the common mistakes you will encounter while designing data stories in Microsoft Power BI.

89. You need to visualize the real-time data in your Microsoft Power BI dashboard according to the analytical requirements of the business. What are the live streaming data options Microsoft Power BI supports? Select all that apply.

  • Streaming dataset (CORRECT)
  • PubNub streaming dataset (CORRECT)
  • Push dataset (CORRECT)
  • SQL Server

Exactly! Streaming datasets in Power BI allow you to include real-time tiles in your dashboard, enabling you to monitor live data continuously.

Correct! PubNub, as a live streaming platform, facilitates a live connection between Power BI and external real-time data, allowing you to visualize data streams on your dashboard as a tile.

That’s right! You can push real-time data, such as temperature or humidity changes, into your Power BI dashboard through streaming dataset options, making it possible to track live conditions.

CONCLUSION – Final project and assessment: Creative Design in Power BI

In conclusion, this week’s activities will serve as a key milestone in your learning journey, allowing you to consolidate and demonstrate the core skills and knowledge you’ve acquired throughout the course. By reflecting on the primary learning objectives and engaging in a hands-on project, you’ll be able to showcase your proficiency in a real-world context. This process will strengthen your understanding and provide a meaningful culmination of your efforts, ensuring you are fully equipped to apply your learnings effectively in practical scenarios.

Leave a Comment