Now we have successfully created a relationship The number 1 next to Geography

Now we have successfully created a relationship the

This preview shows page 31 - 35 out of 94 pages.

Now we have successfully created a relationship. The number 1 next to Geography indicates it is on the one side of the relationship and * next to Sales indicates it is on the many side of the relationship. 27. Click on the Report icon on the left panel to navigate to the Report view. Notice the clustered column chart we created earlier. It shows different sales for each country. USA has the most sales followed by Australia and Japan. By default, it is sorted by Revenue. 28. Click on the ellipsis on the top right corner of the visual. Notice there is option to Sort by Country as well.
Image of page 31
Version: 12.30.2019 Copyright 2019 Microsoft 32 | P a g e Maintained by: Microsoft Corporation Now let’s analyze Sales by Country by Manufacturer and see if we get more insights. 29. With the Clustered column chart selected, from the Fields section expand Manufacturer table. 30. Drag and drop Manufacturer field to Legend section. There are many manufacturers and clustered column chart does not represent the information well. Let’s change the visual. 31. With the Clustered column chart selected, from the VISUALIZATIONS section select Stacked column chart visual. 32. Resize the visual as needed. Now we can figure out the top manufacturers by country. It will be nice to narrow down to the top 5 competitors to better analyze the data.
Image of page 32
Version: 12.30.2019 Copyright 2019 Microsoft 33 | P a g e Maintained by: Microsoft Corporation 33. With Stacked column chart selected 34. In the Filters pane, expand Manufacturer . 35. From the Filter Type drop down select Top N . 36. Enter 5 in the text box next to Top. 37. From Sales table, drag and drop Revenue field to By value section. 38. Select Apply filter . Notice now the visual is filtered to display the Top 5 manufacturers by Revenue. We see that VanArsdel has higher percentage of sales in Australia compared to other countries. Let’s see if there is another way to build this visual. 39. Click on the white space in the canvas and from the ribbon select Home -> Ask A Question . 40. In the dialog start typing Top 5 Manufacturer . Notice a table with the top 5 manufacturers is displayed. 41. Continue typing Top 5 Manufacturer by country by revenue . Notice a bar chart is created. 42. Continue typing Top 5 Manufacturer by country by revenue as stacked column chart . Notice we can create the same visual we did earlier by typing the question. 43. With the visual selected, under VISUALIZATIONS section, scroll down to Visual level filters . Expand Manufacturer . Notice the Top N filter is applied. 44. We have two of the same visuals, so let’s delete this one. Hover over the visual and select the ellipsis on the top right corner. Select Remove .
Image of page 33
Version: 12.30.2019 Copyright 2019 Microsoft 34 | P a g e Maintained by: Microsoft Corporation
Image of page 34
Image of page 35

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture