All language subtitles for 12. Power BI Demo Visualizing Geospatial Data with Maps

All right.

Take a minute to talk about power be I's map tools.

Now I've used mapping software in a lot of different places lot of different tools and I can honestly

say that power be-I has done it better than anyone else.

It's powerful it's flexible and most importantly it's incredibly user friendly.

You don't need to find data at the latitude and longitude level.

You don't need to look up coordinates if you have any sort of Geospatial indicator a town name a zip

code a country a continent chances are power would be able to very smoothly integrate it into its map

visuals.

So let's take a look at how that works.

If you look at your visualisations pane you'll actually see three different mapping options.

This plain white globe is the standard map option.

You also have a field map option as well as the arc GISS maps for power be-I.

Now they all work in a very similar way.

They all take very similar fields but they each have their own flavor and I'll show you a couple of

comparisons.

We're going to start with the basic map and it's going to drop it right in here right in the slot that

we have left.

And you can see by the fields list it's going to ask for some sort of a location indicator.

And lucky for us we've got a territory Look up with Continent and country which we had already categorized

in the data sheet as countries and continents.

So they've got that little globe icon.

That means we know power be-I is going to be able to handle these fields.

Let's grab country and drop it into location and immediately we get some sort of mapping happening.

And what's going on.

There's no data being visualized yet.

There's no legend no values just kind of points that are pinpointing the different countries Germany

France UK US Canada.

So it's a good start but we're not quite there yet.

We need to give it some sort of values to actually compare and visualize for us.

So if we want to show country level performance by something like orders which is one of our KPI eyes

we could grab total orders and there are a couple of places to put it.

Either size or color saturation so all show color saturation first because it's very very subtle.

You see that the size of the bubbles stayed exactly the same.

They just got a little bit lighter and they're actually so small that they're almost impossible to see.

So I don't think that's going to be a very good option for us.

Let's drag it over to size instead.

And that's a little better see larger bubbles.

Now for the U.S. at 78 151 orders Australia's a little bit lower 50 to 12.

And then the European countries are in the 2000s.

So to compare the other map types here show you what these look like.

You can just switch the type to a filled map.

It's very similar but now it just kind of fills in the outline of the countries as opposed to putting

bubbles or dots over them.

So if you prefer this style you can go ahead and stick with it.

That's totally fine.

Notice that the size option disappears.

And our total orders field has been shifted into the color saturation option since that's the only place

where values make sense here aside from tool tips so pretty interesting.

You also have the art GISS option which is a little bit more sophisticated.

It's also a little bit slower and a little bit clunkier.

See it's kind of dynamic as far as highlighting country outlines and shapes are concerned but again

kind of slow a little bit clunky to load.

So I'm going to stick back to our original map option and now because viewing this at a global level

isn't really that insightful.

I'd like to have easy controls to drill in at least two specific continents and that will help kind

of narrow the focus or the view of this map to give us something a little bit more user friendly.

So before we do anything else let's make a couple formatting tweaks.

We actually don't need this title here so I'll turn the title off drive it down a bit.

And one last adjustment we're showing the bubble size by total orders but we can also pack a lot more

information for each country using the tool tips.

So let's go ahead and pull total revenue as well as total profit into those two tips.

And remember you don't see those up front.

They just get embedded.

So now hovering over these areas shows you not only the orders but also the revenue and profit.

So a lot of information kind of tucked away in this map.

Now in order to give the users a means of drilling into more specific areas where we can do is add a

slicer and instead of a date slicer like we practice the first time this time I want to use the continent

field and just drop it in.

But instead of a vertical list of checkboxes or drop down there's another style that's actually going

to work really really well for this layout and that's the horizontal style with buttons and I can access

that through the formatting tools.

And it's actually in the general category and where it says orientation vertical.

We're going to change that to horizontal and we're going to resize this to fit really nicely.

Right into this little space above the map.

And one other thing that we can change while we're in the formatting here is it's only got single selection

options for Pacific North America and Europe.

But if we drill into selection controls we can add a select all option which adds one more button here

and we can delete that header or deactivate that header that says continent.

And I think that should just about do it.

Well resize a little bit kind of fit it nicely in here.

Now when you select an individual continent the map will go ahead and zoom in to that particular area

which makes it a bit more readable and a bit easier to interact with these different types of tool tips.

So remember one of the key criteria that our Adventure Works clients needed to see was performance by

a sales territory and by creating this map and these user friendly slicers we're able to provide an

entire view focused on each core sales territory.

So let's go ahead and select all and there we have it that just about fills out our executive summary.

We've packed a lot of information in here but kept things relatively clean and organized and tight.

We use the matrix views bar charts KPI cards text cards maps and date slicer.

And we're only just getting started.

Next up we're going to take a quick look at that tree map visuals and then start building out an entirely

new product focused page.