Lab-3-11G

>> I've got some data here showing our different products and the categories groups and the manufacturers of those products. And this lends itself to, this is quite hierarchical data. We've got categories at the top and then there's a particular product group within that. Then maybe I want to look at the manufacturers and finally I'll see the individual products. What I can do within Power BI desktop is create a hierarchy out of these to help people navigate through this data, and visualize it, and start to analyze it in different ways. And to create a hierarchy I'll just select the field I want to start with and choose new hierarchy. By default it just gets named with the name of the field in the hierarchy. So I am just going to rename this to products. And now I can start adding some more fields to it. So I go category, then I want to add the group, so I just click on that, and say add to products. Let's add the manufacturer and finally products as well. And now I can see they are arranged here underneath this products hierarchy. And it means that when I start using these in visualizations I'll get all of these fields added in one go and I can start to drill up and down between them. So let's just take a look at our overall units and I rather than dragging the individual field, I can grab the whole hierarchy and drag it on to the axis. And now you'll see the visual starts off by showing us the different categories, urban, rural, youth, and mix. And that's the one at the top of the hierarchy. And I can now drill through from category to group to manufacture and the individual products on the bottom. And to do that I use these icons at the top of the visual. So I can turn on the drill Down mode by clicking this one. And now as I start to click on the data points I'll drill down through those different levels of the hierarchy. So now I'm looking at these unit cells by a group. And it's been filtered to show me just the urban category that I clicked on. So if I choose one of these, let's go to moderation group. Now it's filtering to just those moderation group products in the urban category. I can see VanArsdel manufacturer as the, has had the highest unit sales. And if I click on this, I'm now looking at all of the products for that VanArsdel manufacturer in the Moderation group in the urban category. I can see those filters that have been applied, they've been generated and just added as filters at the bottom of the filter's area. So I you can always refer back and I'll know what bits of the hierarchy I'm looking at. I can do a back up by clicking on this up arrow, roll back up through the hierarchy. And I can do something else here as well, this double arrow drills everything down to the next level. So if I wanted to expand urban, rural, youth and mix all down to the group level, I can click on that one. And now I'm looking at all of those different groups for all of the different categories. You can see I haven't, no filters have been generated or applied here. I would just change the thing I'm looking at down to that next level. The other thing that's worth noting about these, these categories is, button, sorry, hierarchies is that by default we're going to add all of the different fields in to this navigation path as you're drilling. But you can remove individual ones of those. So for example, if you don't care about the manufacturer or if you're producing a report that you're going to publish and you don't want people to be able to drill to that manufacturer level or maybe you don't want people to drill down to individual product levels, I can remove that from this access bucket. And now I can't drill to it. So what I'll be able to do is click on this to drill down to urban, now I'm looking at the group but I can't drill any further. If I click on this, nothing else happens. So that's a way to create hierarchies and help people navigate and analyze through their information in a very, very sort of intuitive way using the data and the structure of that information on the visuals.