Watch videos with subtitles in your language, upload your videos, create your own subtitles! Click here to learn more on "how to Dotsub"

Lab-3-5

0 (0 Likes / 0 Dislikes)
  • Embed Video

  • Embed normal player Copy to Clipboard
  • Embed a smaller player Copy to Clipboard
  • Advanced Embedding Options
  • Embed Video With Transcription

  • Embed with transcription beside video Copy to Clipboard
  • Embed with transcription below video Copy to Clipboard
  • Embed transcript

  • Embed transcript in:
    Copy to Clipboard
  • Invite a user to Dotsub
>> Power BI also has some really great mapping capabilities. Just to very quickly and easily throw some of your data onto a map to look at the geographical relationships in that data. So for example, I've got our sales and I, sales information and I've got the different geographies that we sold that in. And all I need to do to get started building a map is pick the field I want and drag it over to our canvas. Power BI will automatically identify fields that have geographical information based on things like the name of the field and even some of the content of that field. So for example, I pick the city. So it knows, okay, I'm going to go and draw dot for each of the cities in our dataset. And then I can start adding things like our revenue or units into this values area. And that will change the size of the bubble based on the number for that value. And you can see that the points are being drawn on that map as we're, as the data gets loaded. And we're actually using the Bing mapping engine to A, draw the background of the map here, but then also to figure out where to plot these points. So you don't even need to have assigned a latitude and longitude for this, all we need is the name of the city. We'll send over to Bing, Bing will tell us where to plot it, and we'll put those on the map. That's why it takes a few seconds sometimes to get it, with sending our data up to Bing and then retrieving it to put it on to a map. And of course, I can zoom in and out on this control, I can pan around it as you'd expect with any of these mapping controls. I can also do things like, you know, varying the color saturation, the same as I can do with many other charts. I could drop a legend on and color these bubbles in different ways based on a categorical value. And I can do a few different types of maps as well. For example, I've got a map here where I'm plotting a bubble for each of the states. Now in this case I might actually want to say rather than plotting a point, draw the area of the state. And we have this filled map control that allows you to do that. I've already added the units, unit sales into the values area. So you can see we're actually shading each of these areas, each of the states based on that value. So California had the highest, then Texas I think is kind of the next most intense, down to some of the others. And of course, just like any other visual, any other visuals within Power BI I can slice and filter this dataset just the same way. So if I wanted to pick a particular product category, I can click on these, and as I change, choosing the different product categories, you can see the map's updating and the shading is changing. The other thing that's worth noting with mapping is because we're using the Bing map's engine, you can actually be very precise about where these points get plotted as well. Bing does its best to identify, to geo-code that data. But it doesn't always get it right. So like I said, I can drop a city over and it'll plot this map. Now the data here tells me the cities are called Malden, Summerville, Cambridge, and Boston. Now it might just happen that if you grew up on the other side of the Atlantic, those cities are being plotted in the wrong place, not Boston, Massachusetts, but actually Boston, UK. Now there's a few ways that you can correct this. One of the simplest ways is by creating another column that just concatenates, you know, the country that you're particularly interested in. If you had a country field as well, you could join those two together and that acts as a hint to Bing as to where you should put those. So, if I add UK city, you'll see they all get plotted in the right places on the other side of the Atlantic. The other thing that you can do is actually specify a latitude and longitude. So if you've got fields in your model, numeric information for those latitudes and longitudes, you can grab these and drag that out a little bit. Drag these into the latitude and longitude fields, field well areas for that visual. And again, you can see we're plotting these in exactly the right places. So in this case we were, we took some latitude and longitude data for particular offices for this country. So it's not just picking up the name of the city but it's locating them very precisely with that latitude and longitude. And again, you can start adding the values to this or the colors to change it, to match your data as you need to. So those are some really easy ways that you can get started with geographic data using the Power BI maps here.

Video Details

Duration: 4 minutes and 39 seconds
Country: United States
Language: English
License: All rights reserved
Genre: None
Views: 36
Posted by: csintl on Feb 23, 2016

----- (Please provide translations for these languages: Chinese (Traditional) (chi_hant), English (eng), French (France) (fre_fr), German (ger), Italian (ita), Japanese (jpn), Korean (kor), Portuguese (Brazil) (por_br), Russian (rus), Spanish (spa).)

Caption and Translate

    Sign In/Register for Dotsub to translate this video.