Lab-3-11G
0 (0 Likes / 0 Dislikes)
>> 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.