HOTSPOT - You have a dataset named Pens that contains the following columns: ✑ Item ✑ Unit Price ✑ Quantity Ordered You need to create a visualization that shows the relationship between Unit Price and Quantity Ordered. The solution must highlight orders that have a similar unit price and ordered quantity. Which type of visualization and which feature should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:Suggested Answer:
Box 1: A scatter plot of Quantity Ordered and Unit Price by item A scatter chart shows the relationship between two numerical values. Note: Scatter charts are a great choice: To show relationships between two numerical values. To plot two groups of numbers as one series of x and y coordinates. To use instead of a line chart when you want to change the scale of the horizontal axis. To turn the horizontal axis into a logarithmic scale. To display worksheet data that includes pairs or grouped sets of values. To show patterns in large sets of data, for example by showing linear or non-linear trends, clusters, and outliers. To compare large numbers of data points without regard to time. The more data that you include in a Scatter chart, the better the comparisons that you can make. Box 2: Automatically find clusters Scatter charts are a great choice: * To show patterns in large sets of data, for example by showing linear or non-linear trends, clusters, and outliers. Reference: https://github.com/Microsoft/powerbi-visuals-corrplot/ This question is in PL-300 Exam For getting Microsoft Power BI Data Analyst Associate Certificate
Please login or Register to submit your answer