in this lecture we're going to take a
look at 3d maps which is a nice new
visualization in excel like some of the
other new visualizations 3d maps don't
work with pivot tables now 3d maps will
work off your raw data sets without
having to necessarily aggregate them
however by running off your raw data
sets if you have a lot of data points
they can tend to run really slow so even
though it's not completely necessary to
pre-agreggrate your data it can sometimes
often make sense to if you find that
your computer starts to really churn and
start to run slow because of 3d maps so
I'm first going to load up some data so
data from text we're going to load up
employees 2017 gonna click on edit now
the first thing I'm going to do here is
aggregate some of my data now to do this
I'm going to come over to transform
group by and I'm going to click on
advanced and here I'm going to select
the columns that I want to do my
grouping by so what I want is I want
county we're going to add another
grouping for City and I'm going to add
another grouping for hirer date now the
reason why I am bringing hirer date in
for a map is because one of the neat
features about 3d maps is that you can
actually see how things change over time
so I'm going to come over here I'm going
to do a sum of head count just call that head
count and click OK so there we have our
aggregate data set which should be a lot
faster for rendering our maps then you
come over to home close and load that
now that we have our data we can come
over to insert 3d maps okay so here we
have a map now one of the things you'll
notice here is that we have a whole
bunch of dots all over the map and if we
look over here we can see that the
confidence of these locations is only
67% now I know in this case that all of
our locations are in the state of
Montana so they should really all be
clustered here and not spread out around
these other locations as well to improve
this what we're going to do is we're
actually going to go back to our data
and add another field which specifies
the state close it down when you come
back to our data here and I'm gonna click
edit so back in the power query editor
we've got all these four steps here I'm
just going to jump back a few steps so
here what we can do is we can we can add
another column so a custom column
and let's call this state and state
equals Montana I'm gonna click OK and
here we have our state for the groupings
the state hasn't been grouped here yet
so let's just modify this with the
little cog here and we're going to add
one additional grouping which is state
click OK close and load and let's come
back to our 3d maps let's open it up again and we
can refresh our data
now that our data has been refreshed
let's click on add field and add state
now we can see all of our locations are
showing up in the right place now we've
got 96% confidence which I think it's
pretty good let's zoom in on this map
a bit and if we tilt this a bit we can
see that we actually have these 3d icons
but they also relatively flat at the
moment what we can do is we can add
metrics to this chart say over here
we've got height I can add a metric
which is headcount and we can see that
next let me shrink a legend down we can
add categories to the map as well so if
I come over to here and let's say I said
let's say I add County we can color code
all the different counties so here you
can kind of see the outline of where all
in the counties sit and down
here we have time so here's the field
that we selected before hire date so you
notice that there's only one option
available here and that's because well
it only works with date formatted
columns so let's select that there and
now we have this cool little play button
so if I click on this you can see the
time going up here and you see you can
see the height of all the bars in the
map actually growing over time so that
is 3d maps a cool little feature in
Excel if you found this video helpful
please remember to give a thumbs up if
you're not subscribed yet and you want
to learn tips tricks and tools to help
you and your team work more effectively
with data hit the subscribe button and
the notification icon so you don't miss
anything thanks for watching this video
and I'll see you next time
