100%(1)1 out of 1 people found this document helpful
This preview shows page 47 - 51 out of 94 pages.
34.From the FIELDSsection, Click on the ellipsisnext to Datefield in Salestable. 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 ZipCountryin Salesas well 37.Similarly hide ZipCountryfrom the Geographytable. 38.Hide ManufacturerIDfrom Manufacturertable. 39.Hide ProductIDand ManufacturerIDfrom Producttable. 40.Note: It is best practice to hide fields that are not used in reports.
Version: 12.30.2019 Copyright 2019 Microsoft 48 |P a g e Maintained by: Microsoft CorporationLet’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. . .
Version: 12.30.2019 Copyright 2019 Microsoft 49 |P a g e Maintained by: Microsoft CorporationLet’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 FIELDSsection, click on the ellipsisnext to Category inProducttable. 53.Select New Hierarchy. Notice a new field called Category Hierarchy is created in the Product table. 54.Double clickon Category Hierarchyand renameit to Product Hierarchy. 55.Click on the ellipsisnext to Segment. 56.Select Add to Hierarchy -> Product Hierarchy. 57.Click on the ellipsisnext to Product. 58.Select Add to Hierarchy -> Product Hierarchy. We have created a Product Hierarchy which is Category -> Segment -> Product.
Version: 12.30.2019 Copyright 2019 Microsoft 50 |P a g e Maintained by: Microsoft Corporation59.Click on the white space in the canvas. From the VISUALIZATIONSsection select Clustered bar chart. 60.From the FIELDSsection, expand Producttable. 61.Click the checkbox next to Product Hierarchy. Notice complete hierarchy is selected. 62.From the FIELDSsection, expand Salestable. 63.Click the checkbox next to Revenuefield. 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.