34 From the FIELDS section Click on the ellipsis next to Date field in Sales

34 from the fields section click on the ellipsis next

This preview shows page 47 - 51 out of 94 pages.

34. From the FIELDS section, Click on the ellipsis next to Date field in Sales table. 35. Select Hide . This hides Date field in the reports view. We have the option to view hidden fields and unhide fields as needed. 36. Similarly hide Country, ProductID, Zip and ZipCountry in Sales as well 37. Similarly hide ZipCountry from the Geography table. 38. Hide ManufacturerID from Manufacturer table. 39. Hide ProductID and ManufacturerID from Product table. 40. Note : It is best practice to hide fields that are not used in reports.
Image of page 47
Version: 12.30.2019 Copyright 2019 Microsoft 48 | P a g e Maintained by: Microsoft Corporation Let’s get back to our data story, Australia, VanArsdel and 2018 remember 😊Let’s check if the spike occurred in a specific region in Australia. 41.Select Revenue by Countryvisual. 42.From the FIELDSsection, drag Statefield from Geographytable, below Countryin the Axissection. 43.Drag Districtfield below Statein the Axissection. We just created a hierarchy. 44.Make sure VanArsdelis selected in the Manufacturer slicer45.Enable Drill modeby selecting down arrow on the top right corner of Revenue by Country visual. 46.Select Australiato drill down to State level. 47.From Revenue by Yearvisual select 2018and notice Revenue by Country and State visual. 48.From Revenue by Yearvisual select 2017and notice Revenue by Country and State visual. 49.Similarly, select 2016. We don’t see a spike in a specific state. 50.Select 2016again to remove year filter. 51.Drill upto countrylevel. . .
Image of page 48
Version: 12.30.2019 Copyright 2019 Microsoft 49 | P a g e Maintained by: Microsoft Corporation Let’s analyze by Product to figure out what’s happening there. Before we start with that let’s create a Product Hierarchy. This way we don’t have to drag multiple fields to the visual. 52. From the FIELDS section, click on the ellipsis next to Category in Product table. 53. Select New Hierarchy . Notice a new field called Category Hierarchy is created in the Product table. 54. Double click on Category Hierarchy and rename it to Product Hierarchy . 55. Click on the ellipsis next to Segment . 56. Select Add to Hierarchy -> Product Hierarchy . 57. Click on the ellipsis next to Product . 58. Select Add to Hierarchy -> Product Hierarchy . We have created a Product Hierarchy which is Category -> Segment -> Product.
Image of page 49
Version: 12.30.2019 Copyright 2019 Microsoft 50 | P a g e Maintained by: Microsoft Corporation 59. Click on the white space in the canvas. From the VISUALIZATIONS section select Clustered bar chart . 60. From the FIELDS section, expand Product table. 61. Click the checkbox next to Product Hierarchy . Notice complete hierarchy is selected. 62. From the FIELDS section, expand Sales table. 63. Click the checkbox next to Revenue field. Note : Make sure you have VanArsdel selected in the slicer. We see that VanArsdel has a presence in the Urban category and a small presence in the Rural category.
Image of page 50
Image of page 51

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture