8 hours 33 minutes
Okay, so let's go
more detail. Off data you can put on the map.
So we have a list
off restaurants in area. And let's show let me first show you the area. So this is the area, and we have some restaurants here, and I have already started entering data. So, for example, I ma'am, I'm a sales person, and I'm selling toe all these restaurants in this area.
Um, fancy bottled water. And, uh,
I want to put these data on the maps. I see. How
So let's go back to excel.
Uh, so I'm here and I have some of these restaurants and I want to add some more.
And then you can use data from the so, for example, it's Ah, it's ah
yet this one. So if I click on this one,
I get ah,
the address, which is this,
and I can switch to
and I can put it here.
And then again, this is the name of the restaurant
on. I can put it here
and then I copy the coordinates of this one.
So let me close this,
and I can use this as well. So these air copied
I switch and I based it here. And then I look at my numbers and I see that I sell exceptionally well
in this restaurant. So I sold 139 big packs Walter
in last week.
So I have all these data here
and now How do I put it on a map? So I we already spoke about this. If I still like this and they say big naps
and I click here, I get the information that the data is invalid.
So let's try just by name. And this is where being Max being maps fail.
So I click here on dhe yet
Let me close this. Let me just do this. I get something absolutely wrong because it will look for some of these
in the world,
because there is probably too many galaxy carfare restaurants worldwide.
So what I can do
is I can pick the address,
you see, I'm I'm getting
an issue here
this is this is something that's not what I wanted.
So the one thing that is 100% sure
is let me just cut this and then insert here. So if I organize my data like this
and I click this
this is 100% sure. So I'm getting the same map like you have seen
when I was
Yeah, here it is. I can zoom in with same region,
and I have I have these dots, but what I don't get
is I don't get the name of the place.
I just get the location. Why? Because I have targeted this location using latitude and longitude.
So there is no way that you can add to this the name of the restaurant as well.
It simply doesn't work.
But it gives you a nice picture on how to do these things geographically.
so this is about to de maps. Ah, regarding on how much data you have, you can get very, very dense distribution. You can see that the bigger circles up, for example, in this area and smaller runs and there and then then you can
make a decision that o R conclusion that it's probably some other brands attacking your territory and they're moving slowly from here now on on a street map of the city, it really doesn't
work like that but on a bigger scale. If your country why distribution, you can get some
pretty good picture about it. So this is how you can put a date on a man abusing being maps.
Now, the other option you have
is to select your data. Let's just move this a little bit
that just delete this one from the previous.
So this is what we have here
and now we can select this
and we can click on treaty map
and it takes some time,
and you can click here a new door.
And what you get
is a separate
program will separate window Sorry,
in which you get all these things.
And then what you
get here is you can do other things. So let's just zoom in.
Yeah, and we get,
data. We can represent it like this or like this,
and the size is
decided by average monthly sales.
And you see that it's ah little bit
to beg so we can do it like this.
And then when zoom out, you see these numbers here represented in the size of this
and this is how you used his things so you can
move it around. You could see this on such a small area like this.
It is, uh,
so you can reduce this so that it fits
the density of your map
you can make it
And, uh, you can also
customized the fields. So, for example, if you would have here
category, restaurant and the store,
we could go into more detail here
and here We have the address
and we have street,
or it can be latitude and longitude, but then they have to be in a separate
bones, but what we can.
But here is a store, a cz Well,
and then, uh,
for dress, this is an error. So this thing story doesn't recognize like we had on to map. I'm just showing you what you can do with these fields.
So if we go further in
and then just zoom in in this part of Belgrade
and reduce the height even more so that we can
look at the streets and we can also reduce the thickness so it doesn't cover too much of a map.
And so we used the dress and street and become this. We get the address and we get the average monthly sales.
in category, for example, we can, uh,
with the restaurant name. So it's a different restaurant in here. We get the name of the restaurant so we can customize the three d map
100% to our liking.
every restaurant has its own color. You can assign different colors, two different restaurants
and this is how you make,
uh, the whole three D map off the area.
You can also choose it to be flat map so you can move it slightly
easy. It's likely easier you can add. Ah,
you can find some locations. You can define custom regions like Western Europe, northern Europe and so on and so on.
And you can play with it a lot. I'm not going to in to go into all the details. But what you see here is that you have this layer with information about what's in it.
And if you zoom in, you can see the street names as well.
No, Sorry, you don't. But you do. You see the street names when you click on the
Okay, so this is by restaurant. You can you can get all the information you want on this
and you can then capture screen.
And then if you moving to excel
here and just do it here and we just press control, we we can get this
and we can have it as a separate stab in the worksheet. Or we can put it in the old worksheet so we can illustrate our work sheet with
with very nice screen. JJ dumps off
what we have
designed in treaty maps,
and this is pretty much everything we have about
being maps, and they're using Excel.
Data Analyst Excel
The Data Analyst Excel Test is a premium Cybrary assessment created by iMocha and intended ...
Monitor a Web App
In this IT Pro challenge, participants get hands-on experience activating server logging and using Application ...
Learn On Demand