100%(1)1 out of 1 people found this document helpful
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 Reporticon 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 ellipsison the top right corner of the visual. Notice there is option to Sort by Country as well.
Version: 12.30.2019 Copyright 2019 Microsoft 32 |P a g e Maintained by: Microsoft CorporationNow let’s analyze Sales by Country by Manufacturer and see if we get more insights. 29.With the Clustered column chart selected, from the Fieldssection expand Manufacturertable. 30.Drag and drop Manufacturerfield to Legendsection. 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 VISUALIZATIONSsection select Stacked column chartvisual. 32.Resizethe 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.
Version: 12.30.2019 Copyright 2019 Microsoft 33 |P a g e Maintained by: Microsoft Corporation33.With Stacked column chart selected 34.In the Filters pane, expand Manufacturer. 35.From the Filter Typedrop down select Top N. 36.Enter 5in the text box next to Top. 37.From Salestable, drag and drop Revenuefield to By valuesection. 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, scrolldown 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 ellipsison the top right corner. Select Remove.
Version: 12.30.2019 Copyright 2019 Microsoft 34 |P a g e Maintained by: Microsoft Corporation