WEBVTT

00:00.000 --> 00:03.400
Hello friends and welcome to Tutorials Point

00:03.400 --> 00:08.000
In this segment of the video I'm going to
show you what are the map visualization

00:08.000 --> 00:18.000
Now in PowerBi desktop we have two type of map visualization. First one being the
bubble map which will place bubble all across the location that you have mentioned

00:18.000 --> 00:25.600
and second one is the field map which will help me to show
the outline of the area that you would like to visualize into

00:25.600 --> 00:29.980
Now our Power BI desktop is very
much flexible upon the location

00:29.980 --> 00:35.840
that it accepts that is the location data that
you feed to power via desktop it can be more

00:35.840 --> 00:41.520
generalistic like the area like city name or the
pin code depending on that it will give you the

00:41.520 --> 00:47.440
location drilling down further to latitude and
longitude as well so if you have the proper

00:47.440 --> 00:53.840
latitude and the longitude it's the best way to get
your visualization using the maps all right guys

00:53.840 --> 00:59.840
so once you have created a map visualization let's
say for a bubble map the value if you drop the

01:00.000 --> 01:05.180
bucket in the map visualization the moment
you drop the values the size of the

01:05.180 --> 01:10.200
bubble will increase upon the location
that you have mentioned so if let's say

01:10.200 --> 01:14.880
for an example we have a location let's
say Karnataka and we have the value

01:14.880 --> 01:19.800
let's say 10,000 it will show one size
for it and if you have a double figure you

01:19.800 --> 01:24.080
the size of your bubble will keep on
increasing depending on the what value

01:24.080 --> 01:28.680
feed you are going to give it all right
guys moving on with the next one sometimes

01:28.680 --> 01:33.800
when you create the chart, you can also see a
warning icon. Now, what does this warning icon

01:33.800 --> 01:41.560
It indicates that the map needs more location
data to accurately plot the areas that you would

01:41.560 --> 01:47.240
like to mention. Now, this is a very common
problem whenever your location data has some

01:47.240 --> 01:52.520
ambiguous data, like what I mean to say,
let's say for an example, Washington. Now

01:52.520 --> 01:58.660
Washington is also a state and it's also a district.
So at that time, it is difficult to plot this

01:58.660 --> 02:04.240
area onto the map. So how you can fix this? It's
simple. You simply have to go under the Power

02:04.240 --> 02:09.840
Query Editor and you have to rename the column
names. Now in this scenario it will be the

02:09.840 --> 02:15.320
state. So I simply have to go under the
Power Query Editor and rename to state. So it

02:15.320 --> 02:20.860
understand that it is a state and it will map
the location accordingly. Now let's go ahead and

02:20.860 --> 02:25.980
see how to create this maps in our Power
BI desktop using our practical approach

02:25.980 --> 02:43.792
Hello friends and welcome in this video we are going to see how to create map charts in power BI alright so let go ahead and get started
under the visualization pane you can see there are different type of map charts the first one is a normal map chart the second one is a

02:43.792 --> 02:48.892
fill map chart and the third one which
I see out here is our GIS maps for

02:48.892 --> 02:54.272
power BI these all these map charts are
basically powered by Bing so if you have

02:54.272 --> 02:58.312
any kind of suggestion you can just put
it in your suggestion box and send it to

02:58.312 --> 03:04.612
power BI so that it gets updated and mark the region
accordingly all right guys so this is how the

03:04.612 --> 03:10.372
power BI works now let me show you quickly how it
is done and how to create map chart for the same

03:10.372 --> 03:16.492
for the same reason what I'm doing out here I'm just
going to create a new table altogether a simple

03:16.492 --> 03:22.712
plain table in which I'll be having some values and
the regions according to it all right so I need to go

03:22.712 --> 03:28.112
under the enter data tab and I'll simply click
on it the moment I click on it I have some

03:28.312 --> 03:34.552
table right in front of me I will start
typing the name of states in India itself

03:34.552 --> 03:41.812
so I will start off with let's say Gujarat
I'd enter we have Rajasthan all right

03:41.812 --> 03:54.172
we have Kerala we have Maharashtra and
let's add Karnataka as well all right

03:54.172 --> 04:08.512
so I have all the regions in front of me let's give them some
value some random value let's say 2000 and 5,000 let's take

04:08.512 --> 04:16.772
6,000 again a 3,000 and one let's take
it as 4,000 all right so I have all

04:16.772 --> 04:23.032
the regions and let's give them a header
I will give them a header as states and

04:23.032 --> 04:33.372
let's say revenue It can be anything right I
simply hit enter so I have state and revenue both

04:33.372 --> 04:39.432
I will simply load this table on my
power BI screen just give it a moment

04:39.432 --> 04:46.012
All right now this table has been added out here
as table one if I want to change the name of it

04:46.012 --> 04:50.952
So I simply have to select this drop-down
menu change name and says Indian states

04:52.452 --> 04:58.292
All right and I hit enter all right so it
can be seen out here now I have revenue

04:58.292 --> 05:18.025
and I have states So let go ahead and start with the very basic map that is a simple map chart I will simply take this click on this So I have this bubble
map chart So if I simply select state drag it here Alright so as you can see it has automatically taken the India shape all right this can be seen out here

05:18.345 --> 05:26.445
So I have the outline for Indian map and it has
automatically marked the region so this is for Kerala we have

05:27.705 --> 05:33.045
Right Kanataka we have Maharashtra we have Gujarat
and we have Rajasthan out here so this is how it

05:33.045 --> 05:37.785
automatically picks up the region as I have
already told you that it is powered by Bing

05:37.785 --> 05:43.565
so it refers to the Bing Maps and get
me the results accordingly now for this

05:43.565 --> 05:48.185
particular map chart it is necessary
that you have an active internet

05:48.185 --> 05:52.005
connection alright if you do not have
an internet connection this feature

05:52.005 --> 05:56.825
will not work on your system or on
your laptop guys all right so this was

05:56.825 --> 06:02.305
about a basic field map chart in which
I'm getting the region as bubble dots

06:02.305 --> 06:07.805
alright now I can simply change the color
of it by going to this format tab I will

06:07.805 --> 06:12.125
not go here if you see there's a drop-down
menu you can also change the size

06:12.125 --> 06:15.665
of this bubble if you're finding that
that they are very small you can increase

06:15.665 --> 06:21.545
a percentage now you can see the map
the bubble size automatically increases

06:21.545 --> 06:26.525
all right so this is how this bubble
chart on a map is working now let's go

06:26.525 --> 06:32.285
ahead and see how this field chart
so for the same set of rear inputs

06:32.285 --> 06:39.625
I'm going to create a film map. All right. The moment I create a
film map, you can see all the regions, all the regions that have

06:39.625 --> 06:45.905
you mentioned has automatically occupied those
areas and it is giving me the, what do you

06:45.905 --> 06:53.105
say, the results accordingly. Now under this drop-down menu,
I can see there are so many style map styles, map controls

06:53.105 --> 06:57.365
that can be seen. Now let's go
ahead and select this map styles

06:57.365 --> 07:02.285
If I click on this drop-down menu of theme,
I have basically five themes out here from

07:02.285 --> 07:06.565
which I can select any you can have aerial
view whether you want an aerial view

07:06.565 --> 07:12.145
which looks like this a dark view which
which almost look like this right as

07:12.145 --> 07:17.125
though both are this same visualization
a light one which which we already saw

07:17.125 --> 07:21.325
right so there are so many things that
we can select from and get my results

07:21.325 --> 07:27.745
accordingly guys all right I will skip
to the light theme so that it makes me

07:27.745 --> 07:48.297
give me a simple projection a simple projection with white and bluish background All right So this is what we can do Okay moving on if I go
under this drop menu you also have an option when you have a database in which I have which in which I already know what is the latitude and

07:48.297 --> 07:52.577
the longitude of it I can also mark
the region so if you can see I have a

07:52.577 --> 07:56.957
feature where I can drop in the latitude
column and the longitude column and if

07:56.957 --> 08:03.077
I fill out these two respective
places it accordingly maps the region

08:03.077 --> 08:07.077
accordingly or at least get
close by to it so this is how the

08:07.077 --> 08:11.417
if you have the latitude and the longitude
feature the or the columns ready with you

08:11.417 --> 08:16.457
you can use this feature to map this
thing on a film map as well all right guys

08:16.457 --> 08:23.717
moving on with the next type of chart
is basically this ARC GIS map chart so

08:23.717 --> 08:28.097
let's go ahead and quickly create a
new chart for the same now as you have

08:28.097 --> 08:33.437
seen that it has already occupied so
much of space in order to get me a new

08:33.437 --> 08:37.077
chart I have to either delete
one of those or we can do one

08:37.077 --> 08:40.577
thing we can simply move on to this next
page to you see at the bottom of the

08:40.577 --> 08:44.297
screen I have page one this is basically
my page one I can simply click on this

08:44.297 --> 08:48.497
plus button it automatically adds
a page two and I can get a second

08:48.497 --> 08:52.457
projection out here as well alright
so we'll go ahead and get this

08:52.457 --> 08:57.497
a GIS map for power BI I simply
click on it I get an empty map I will

08:57.497 --> 09:02.477
simply go ahead this time I will go
ahead and select some American countries

09:02.477 --> 09:07.037
so I will simply select the state
and drag it here all right so this

09:07.097 --> 09:10.817
particular feature is working it will
take some time as it connects to the

09:10.817 --> 09:16.157
internet and marks the region accordingly
all right I will also need to go ahead and

09:16.157 --> 09:20.537
add the revenue so I'll simply select
the revenue drag it here so it will

09:20.537 --> 09:26.057
show me the region revenue by states
different states of America as my

09:26.057 --> 09:30.917
database is completely dependent that
it generally takes time just give it a

09:30.917 --> 09:37.077
moment all right guys here we go we
have the visualization now as you have

09:37.077 --> 09:45.097
as you are seeing that it is marking the different states in the
United States of America and getting me the results accordingly

09:45.097 --> 09:52.897
alright so for different state it is showing you the different
revenue all right so this is how this particular map works in Power BI

09:52.897 --> 09:59.697
okay guys so this was all about maps and how to create maps
and how to modify this maps according to our own needs

09:59.697 --> 10:07.077
and how to supply the data how to give input
the to the data to the maps in Power BI

10:07.077 --> 10:12.337
all right so this was all about this video in
which we learned how to create map charts in power

10:12.337 --> 10:16.017
BI hopefully you guys like this
video see you until it next time