6 From the Fields section expand Date table and click on the ellipsis next to

6 from the fields section expand date table and click

This preview shows page 52 - 58 out of 140 pages.

6. From the Fields section, expand Date table and click on the ellipsis next to Month field. Select Rename and name it as MonthYear . 7. Similarly, rename the MonthName field to Month .
Image of page 52
Version: 09.01.2016 Copyright 2015 Microsoft 53 | P a g e Maintained by: Microsoft Corporation Several of the ID columns in the tables are not useful to the end- users. Let’s hide some of the fields to present a clean user experience. 8. From Fields section, expand Date table and click on the ellipsis next to MonthID field and select Hide . This hides the column from the report. Note : You can still see this column in the data view and relationship view. 9. Similarly Hide the MonthNo and MonthYear columns from the Date table. 10. In the Manufacturer table, Hide ManufacturerID column. 11. In the Product table, Hide the columns ManufacturerID and ProductID . 12. In the Sales table, Hide the columns Country , Date , ProductID , Zip and ZipCountry . 13. Select Geography table and Hide the column ZipCountry . 14. Select the ellipsis next to Sentiment table and click on Hide to hide the entire table. Note : You can hide columns or tables from the report view so that your end users of the report only see the columns with which they need to interact.
Image of page 53
Version: 09.01.2016 Copyright 2015 Microsoft 54 | P a g e Maintained by: Microsoft Corporation Similar to your analysis of top competitors, when doing comparisons of competitors, your team is also only interested in comparing top competitors. 15. In order to apply a global filter for the entire page, click on the canvas outside the column chart. 16. In Fields section, select the ellipsis next to Manufacturer column in Manufacturer table and click Add Filter . This will add the Manufacturer column to Page filter. 17. In Visualizations section, scroll to Page level filters . 18. Select the manufacturers Aliqui, Currus, Natura, Pirum and VanArsdel in the filter.
Image of page 54
Version: 09.01.2016 Copyright 2015 Microsoft 55 | P a g e Maintained by: Microsoft Corporation 19. Move the column chart visual to the right of the canvas. 20. From the Fields section, expand Manufacturer table and drag and drop Manufacturer to the Legend of the visual. You need the company logo in most reports. 21. Click on the white space on the canvas. 22. From the ribbon, select Home -> Image .
Image of page 55
Version: 09.01.2016 Copyright 2015 Microsoft 56 | P a g e Maintained by: Microsoft Corporation 23. Navigate to /DIAD/Data folder and select Logo.gif. Click Open . Logo will appear on the report. 24. Resize and Move the logo to the top left of the report.
Image of page 56
Version: 09.01.2016 Copyright 2015 Microsoft 57 | P a g e Maintained by: Microsoft Corporation You can see VanArsdel logo is GREEN. You want to be able to match the logo color with the color of the sales for VanArsdel in the bar chart in your report. 25. Click on the previously created Stacked column chart. From the Visualization section, select the format icon as shown in the figure.
Image of page 57
Image of page 58

You've reached the end of your free preview.

Want to read all 140 pages?

  • Spring '20
  • Anand joshi
  • Microsoft Corporation

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture