Visualizations: Maps

Charlie Walker
A free video tutorial from Charlie Walker
Data Analytics & Messenger Bot Marketer
4.1 instructor rating • 3 courses • 13,004 students

Learn more from the full course

Microsoft Power BI Desktop - Data Analytics with Dashboards

Learn Microsoft PowerBI to build interactive dashboards in Microsoft Power BI Desktop and PowerBI Service

02:40:09 of on-demand video • Updated March 2018

  • Take a data set and turn it into a beautiful interactive dashboard
  • These skills can be implemented immediately at work
  • Dashboarding best practices from someone in the field
  • Learn basic DAX functions to get more functionality on your data
  • Create calculated columns and Measures
English [Auto] The math options we have with power be-I is the still Matt. It's just called Map your bubble map is really what it is. And there's also this arc GISS map for power be-I which this is just a super advanced feature that can get really granular and do some really cool things for the for the purpose of this course. I don't think we need to go into it because I think these other two maps are really going to do just about what we need. So let's let's just start playing with this field map. So do sales by state and I think we play with this earlier in the dashboards. But with Philmont you can see the darker it is the more the more color saturated is the more cells that are in that particular state. This other map is just above the map so it all just the bigger the bubble the bigger the state. It can also add some color saturation there but this is just helpful to see you know one of the biggest or the biggest sellers so Washington is actually a pretty pretty big size. California is the leader and then New York is next. Here's where it gets a little bit difficult with these maps. If you wanted to drill down into the city with close lushest lushest see what happens. What happens is it pushes the data to Beijing and it says OK here's a city where is this located. And it has a tough time with ambiguous data like that because there's an Athens in Greece there's an Athens Georgia. So let's Sharath postal code post postal code and see if that helps us. And it's not going to play with it. It basically just there's I guess just postal codes all over. And it has it's track that to show reason to put the car saturation Because oh because it thinks it's a it's it's got a signal here so it's like it thinks that it's a number or a data field. All right. So this is not what we wanted right. Our data only lives in in the United States so there's not there's not sales outside of the United States so it should only be this area here. So why is it doing that. It's because there's other postal codes all over the world that happen to match the numbers that we have for our postal codes. So what do we do. Well if your data has latitude and longitude for the cell taking place that's an easy fix you just put it in there. If not you have to get a little bit creative and I'm going to show you one feature that you can use. It's a little bit more advanced So that's it this is just going too fast. It's not a critical step for understanding the maps. And we're going to go into some of the DAX functions that this is what we're about to do is called a daks function. Where do you go into some of those later. So if it's a little bit overwhelming or going too fast just just kind of breeze by and move on to the next lecture and then eventually Well we'll get to it. We'll get you brought up to speed. We're going to modify some of our data. So we've got City we've got we've got City we've got state or province we've got region we've got country. If you can have your data set up so that it says like Cincinnati comma Ohio then that data will be perfect and your map will just show North Carolina or just North America because it knows that it's where it is. It knows this it's Athens Georgia and not Athens and Greece. So let's go and play with it. We're going to create. So we're going to go into our data tap here and we're And we've only imported one table so when the orders table and we're going to insert a column so you can hover over any of these right click and do insert column where you can also just go to modeling. And then you can also do it. There you go. All right so the way this is if you have any experience in Excel you're going to be a little bit more. It's going to become a little bit easier for you. It's not just bear with me. So the way this works is you name it you name it first and then instead of having to drag the function down it does it for the entire column and the first part is just Naimi. So his name and location location equals and what we want is basically for it to say the city comma space state and then in because we have the data here you read Redmen comma space Washington and then we know exactly where we want it to go. So how do we do that in Excel. You have something called concatenate or you can do equals. And in parentheses or quotation marks we're going to concatenate in this example then concatenate and then it's going to say what's the first text you want the first is going to be city. So if you just start typing the field in it or look it up and say Oh you mean the city in the column city in the tap in the in the table orders. Yep that's the one at home. So what's the next what's the next text that we want. We want to be comma and a space. So we want to be common space. So my syntax here is text one is the looking at the city text to his comma in space. Well that's only just going to give me part of it it's not going to pick up the state. But the issue is you can't do a concatenated with three texts around. So that's what it's looking right now. So we need to add let me add another field which is the sort. You the end of the field which is the state into this concatenation. So we're basically going to have to do a nested concatenate. So I want to say I want cannonade this text which is City comma space and the state that's my text one the text 2 is going to be state. Close it out. And then we guess we should have City columnist Baystate. All right. So that's our location field and we it shows up here as a function. We go back here and we replace this postal code with location. We should have our map just in the United States and we know it knows which cities or go going which states and what locations. So we went to Ledgett we want to go to location and it's spinning it's sitting in being there we go. Perfect is exactly what we wanted. So well there's one big city here years New York that is obviously the biggest of all. And then some city in California which is L.A. so you can see a little bit more detail into here. You can you can also still see that California is a huge area or a HUGE in terms of sales. One particular city which is L.A. is making up the post sales. And so that's kind of how you can look at it and you may have to play with the location fields when you play with Matt.