Placeholder Image

Subtitles section Play video

  • Hello, everybody.

  • Thank you so much for coming.

  • My name is Dennis Cao, and I'm absolutely thrilled to be talking about two of my favorite things in life, besides family and stuff like that.

  • Maps and Tableau.

  • But more specifically, creating maps in Tableau, or vice versa, using Tableau to create maps.

  • And so these are kind of one of my favorite things to do.

  • And I'm so happy to be here.

  • So thank you so much for attending.

  • Just a brief background.

  • I'm a social work professor at Carleton University, which is based in Ottawa, Ontario.

  • Originally from the States, originally just up north in Los Angeles.

  • I have the pleasure to be a Tableau visionary this year.

  • I'm also a public ambassador.

  • And then more specifically for this session, I have a graduate certificate in GIS, and

  • I've been doing GIS for about 15 years in regards to my research, which is around health equity issues.

  • And I also try to teach GIS mapping and things like that in my classes as well.

  • I first discovered Tableau about three and a half years ago, so I've been doing GIS for about 15 years.

  • But I only discovered Tableau about three and a half years ago.

  • And the rest is history.

  • And hopefully you'll get a sense of that today.

  • So for today's presentation, I decided to try to keep the agenda fairly simple.

  • I want to talk a little bit about maps, what they are, some general concepts, and design principles.

  • And then I wanted to talk a little bit about some of the things I think...

  • I spend a lot of time thinking about maps.

  • And so I think compared to the average Tableau user, I think I probably think a lot more about maps.

  • And so all these things I've tried to kind of wrap up and categorize into five broad tips.

  • Okay?

  • So next, after that, I want to try to apply those principles or those tips.

  • And so if you're interested in following along, you can access the data right here using that link or QR code and follow along.

  • Download it onto your desktop, then you can use it.

  • Like I'll be trying to...

  • I'll show you some things, but then you can play with the data.

  • And that's the fun part, right?

  • So let's talk about maps.

  • So by now, you've probably noticed that I love maps.

  • I use maps personally as well as professionally.

  • But I also love and enjoy the map-making process, kind of the thinking behind it and things like that.

  • And since discovering Tableau, I've been on a journey to explore the more creative side of map-making.

  • And so that's what I'm going to try to show you today.

  • And because I study and use them in my work, I probably think about maps a lot more.

  • And so hopefully you'll get a sense of that.

  • And when we do go into the Tableau and try to create a map, hopefully you'll kind of get some insight into some of my thinking around this.

  • So what are maps?

  • So here's a definition.

  • Maps are a symbolic, condensed representation of reality.

  • But the key takeaway from this, I think, is that maps aren't merely tools to help us find the nearest Starbucks or, in my case, the nearest In-N-Out Burger.

  • But maps are powerful tools of communication.

  • But more than that, throughout our history, maps often reflect the power.

  • Who has power?

  • Who was in power?

  • Who dictated the dominant values of society?

  • And I love this quote from Adam Schultz, who's a Canadian explorer.

  • Wouldn't that be a cool thing?

  • He's an explorer in this world, in this time and age?

  • And a writer.

  • And in his new book entitled A History of Canada in 10 Maps, in his intro he writes, maps are also a cultural artifact, a window into the past, a clue into understanding the worldview of the person or the persons who made it.

  • And so this resonates with me, because when you think about maps, just like when we create other data visualizations, bar charts, things like that, there are a million little decisions that often we have to make.

  • What to include, what not to include, what to highlight, what not to highlight, what to label, et cetera.

  • So it's important for us to really think intentionally about that.

  • So if there's a key takeaway, it's trying to think more intentionally about some of the decisions we make when we make maps.

  • For me, I think it's helpful to kind of think about maps in kind of two broad categories.

  • First, you have reference maps.

  • You know, Google is a good example of that.

  • Apple Maps is a good example of that.

  • And we often use that to navigate and find where things are.

  • The other one is thematic maps.

  • And this is an example of a map I created in Tableau, looking at changes in San Diego's black population between decades.

  • And this was based on the challenge to kind of mimic his creative data visualizations and using the colors that he used and things like that.

  • So reference maps, if you think about it, they provide an overview of a place.

  • They're not necessarily guided by a topic, right?

  • All features are supposedly equal and often include more detail than thematic maps.

  • On the other hand, thematic maps, you know, are often used to visualize a specific phenomenon or topic.

  • It's driven by some purpose.

  • And so you see an emphasis on specific features.

  • And generally, as a result, they tend to be less specific, have less detail, right?

  • And hopefully you can see some of the differences.

  • And then to me, the key difference is with reference maps, the story is reader driven.

  • They're going to look at the map and try to find the story that they're interested in.

  • Whereas in thematic maps, they're designer driven.

  • The designer is the one making the choices in terms of color and things like that.

  • And so as a result, there's a huge responsibility as we try to make some of those decisions.

  • And I think generally, most of our work involves thematic maps, I think.

  • Another thing to kind of think about in today's world, we're not necessarily talking about drawing maps by hand, you know, generally we're talking about digital maps.

  • And digital maps are composed of different layers.

  • So each representing a different feature.

  • And so this is a quick map, not quick, but a map that I created in Tableau Public, looking at multiple layers.

  • So for example, you have points to represent the bars in this area.

  • I mean, there's 73 that I counted, or a Google search, that seems kind of disturbing, right?

  • 73 in the downtown area.

  • The second layer are the buildings.

  • So the bars are points.

  • The buildings are polygons.

  • And then the roads, which is the third layer, are lines, right?

  • And so we often work with what we call vector layers, which have distinct features.

  • And can be defined by points, lines, or polygons.

  • There's another type of data, rasters, but Tableau can't really handle those right now unless you kind of, there's some workarounds, but they're essentially grid cells or pixels with different values.

  • So if you look at weather maps, those are a good example of rasters.

  • And what's cool about this concept of layers, which is, you know, obviously in Tableau we have map layers, what's cool about that is now we can overlay different types of data, different topics, different types of features, as long as they're tied to some geography, and then explore the relationship between the two.

  • So here are some five basic cartographic design principles, and it's helpful for me to think about them as questions.

  • So as you're designing a map, right, do the map features and page elements contrast visually with each other and their background?

  • Okay, and in this map I try to visualize the downtown buildings very differently than the buildings around it, okay, to try to create that visual contrast.

  • Second, are the map's features, especially the most important ones, are they readable and easy to understand?

  • So this includes maybe labels as well.

  • Is the map or the most important thing on the most important map feature, is it visually separated?

  • Does it pop from the background?

  • And this is, again, my attempt to make it pop, the buildings in downtown, because I want this map specifically designed to showcase downtown San Diego.

  • Is there a clear hierarchy of the map elements arranged by their importance?

  • So when we think about labels, some labels might be bigger than others, and so in trying to do that, there might be a hierarchy created.

  • And then finally, are the map elements well balanced in the layout?

  • Okay, and so these are the questions I'd like you to kind of think about as we move forward.

  • So let's think about mapping in Tableau now, and these are kind of five tips, and I'm going to try to quickly go through this and then get to the mapping and then try to apply these.

  • So first tip, keep it simple.

  • This is a great quote by John Nelson, who works at Esri and is a pretty well-known map maker.

  • I'm not going to read the whole thing, but I just want you to take note of the highlighted text.

  • Specific phenomenon, pick a salient thing, leave everything else out, and exercise restraint.

  • And so when you think about mapping in Tableau, for those who have done it, you bring in a geographic field into the view, then you automatically see a background, background layers, and things like that, that's applied by Mapbox.

  • So the question is, do we need all of that?

  • And some of that might be noise, and so, or kind of make it a little harder for our story to come out.

  • So my own personal rule of thumb is really one map, one message, okay?

  • But if you have multiple stories to tell, and you're trying to do it in one map, you might be more effective creating multiple maps.

  • I lost my place in my notes.

  • So what does that mean?

  • That might mean one key feature per map, one colour palette per map, maybe one key symbol that you use to highlight a specific feature.

  • Things like that.

  • Second tip.

  • Do not accept defaults.

  • So like I said, when you plop in a geographic field into the view, there are a lot of defaults.

  • We see that when we do a bar chart, grid lines, things like that.

  • So when I plopped in San Diego, the city, something like this, all these background layers, ultimately we have to kind of revert back to what is the purpose of this map?

  • What are we trying to tell?

  • What story are we trying to tell?

  • What message are we trying to convey?

  • And do we need all of this stuff to convey that message?

  • Can we leave things out?

  • That's the kind of key thing.

  • And so question everything, right?

  • Question the defaults.

  • Question the symbols that are used.

  • Question the colours.

  • Question the background layers.

  • Do we need all of those?

  • Question the map options.

  • And we'll go through a few of those examples in the demo.

  • Kind of the counterpart to that is tip three.

  • Definitely sweat the little details, okay?

  • One of the things that cartographers spend an enormous amount of time on are labels.

  • The position of the labels around the dot or a shape, the size of the label, the font of the label, the font type, the font style, the font size, et cetera.

  • An enormous amount of time.

  • And so sweat the details.

  • So consider everything.

  • The positioning.

  • So this is a map of Balboa Park.

  • So I've supplied you with a few shape files.

  • Those are the shape files I used to create this map.

  • Consider the positioning.

  • Consider the inherent white space.

  • So we talk about white space, increasing white space to make things readable.

  • Geographies have a weird shape, right?

  • So if you notice, Balboa has kind of this weird shape where there's an open space, white space here, there's white space here.

  • And then everything is on this side.

  • And so this entire right side of Balboa Park, I thought about as white space.

  • So I was trying to take advantage of that white space.

  • And so kind of think about that.

  • Obviously, this is all floating.

  • And so I know there's two camps, right?

  • So I created this using just floating containers.

  • And so, you know, we can talk about that.

  • We can argue about that later, yeah.

  • And I tried to kind of balance it, take advantage of the white space, trying to position it in a way that made sense.

  • I spent an enormous amount of time playing with the size of the circles, trying to kind of figure out what worked best, right?

  • So sweating the little details is important.

  • Tip four.

  • So this was before my time.

  • But I heard that creating maps was a nightmare with dual access or trying to model the data in a way so all these different shape files were somehow linked to a single table, right?

  • With map layers, it's a game changer.

  • And I'll show you some examples.

  • Now we could just pile in the facial files, not worry about data modeling, and then overlay them on top of each other, right?

  • Which is cool.

  • And that makes a big difference.

  • Coming from someone who's done GIS, this mirrors more how I learned how to create maps.

  • Like by layering, not worrying about the data model necessarily, but as long as they're geographically linked in some way, we can overlay things on top of each other.

  • Okay?

  • It makes things a lot easier.

  • The second note I want to make here is a map is made out of multiple layers, right?

  • But layers are free.

  • So you can overlay a bunch of different layers on top of each other, even duplicate layers.

  • So for example, in this one I created, I tried to make the streets pop, and actually it's made up of three different layers of three different street layers, the same layer on top of each other.

  • Playing with the color, playing with the thickness, and things like that.

  • Trying to make the streets pop in this example.

  • And I'll show you an example of that once we get into the data.

  • And then finally, consider adding your own spatial files.

  • I think it gives you a lot more control with how the map looks.

  • If you think about Mapbox, those are great, but those are essentially images, right?

  • In your map.

  • You can't play with them, you can't change how they're overlaid on top of each other.

  • You can customize a Mapbox, right?

  • But again, once you plop it into your view, it's basically an image.

  • When you use your own spatial files, I feel like you have a lot more control on what the actual thing looks like.

  • So in this case, the roads.

  • Trying to play with the thickness, trying to play with the opacity, things like that.

  • And then kind of the side note is, if you're going to use your own spatial files, consider,

  • I would encourage you to consider adding a GIS software to your tool belt.

  • GIS software, geographic information systems, are specialized software that's designed specifically to work with spatial data, and deal with the unique properties of spatial data.

  • So I would encourage you to kind of consider that.

  • Now, I use QGIS, which happens to be totally free and open source.

  • All right.

  • So with that, I think we're doing pretty good.

  • Let's create a map, okay?

  • So again, if you missed my, I don't know, ten announcements, you can access the data here using the QR code, and I'll spend just a brief moment here just talking through what you'll find.

  • There's basically four shapefiles in four folders.

  • Balboa Park, which is the boundaries, a polygon, Balboa Park attractions, which are points, like the museums, the gardens, et cetera, Balboa Park buildings, which are the polygons, and then Balboa Park roads, which are lines, okay?

  • And in each folder, you'll see, so, for example, I opened up Balboa Park, you'll see that there's a bunch of files, okay?

  • With shapefiles, it's kind of a, it's how I learned, but they've, Esri has tried to move beyond that, but you'll notice, it's not a very efficient kind of, you know, way to kind of transport or use data, but it's basically a bunch of files.

  • Just make sure you keep them in the same folder.

  • Don't change the titles, but if you change the titles, make sure they all have the exact same title, name, and then, for Tableau, we only have to worry about the fourth file, which is the one with the extension SHP, or shapefile, okay?

  • That's the only one we need to pull into Tableau, and it will connect with all the other data files as well, okay?

  • All right.

  • And these are the different shapefiles.

  • All right, so I'm going to switch over, apologise, give me a second.

  • So this is Tableau Public, and what I'm going to do now, let me turn on my highlighter, is I'm going to plop in these data, kind of play with it a little bit.

  • If you have a suggestion, feel free to shout it out.

  • I haven't rehearsed this part, so I'm just kind of winging it right now.

  • So, you know, let your creativity flow, right, through this process.

  • Okay, so, let's see here.

  • So with map layers, all we have to do now is really just dump all these layers into

  • Tableau, right?

  • We don't have to connect with them, et cetera.

  • So here's the Balboa Park shapefile, and all I'm doing is I'm going to just drag all of them into Tableau.

  • So here's the Balboa Park place shapefile, like so.

  • And I'm not really doing anything, but you'll notice that they're congregating right here now, right?

  • Okay.

  • Let's move the buildings over.

  • And then, finally, the roads, like so, okay.

  • So now we have these multiple data sets here, and all we need to do now is move this geometry field into the view for each of them.

  • So let me start by doing the boundaries.

  • So this is the Balboa Park, right?

  • And so, automatically, all the map box layers show up, and I'm going to just turn these off because I don't want them.

  • And the cool thing is once you turn this off, these off, I don't know, I shouldn't say this out loud, but that kind of copyright map box here, that tagline, disappears, which is kind of cool, okay?

  • Okay.

  • I won't say that out loud.

  • Oh, wait, this is being recorded, though, so, oh.

  • Okay.

  • All right, now let's move in the, let's go with the roads.

  • I'm just going to plop it in, and then with map layers, once you drag another, a second layer, it will show up right here, there's a little field that you would plop that in, and then the roads automatically get overlaid.

  • And I'm just going to plop all the data into the view, and you'll notice, obviously, now here are the buildings, right?

  • Then here are the places.

  • All this data I got for free from the Census Bureau, and then the places, I kind of just did a Google search, right, and looked directly at the Balboa Park website.

  • Okay.

  • All right.

  • So now we can rename these, right?

  • So if you weren't familiar with, we can rename these as, let's see, Balboa Park Boundaries.

  • This is the roads, I believe, let's see, yeah.

  • These are the buildings, and these are the places, okay?

  • And then with map layers, just like in GIS tool, we can turn off various layers, things like that, and usually, because I'm not going to let, I don't really want the reader to be able to interact with all of these layers, right?

  • Like they don't need to interact with the park boundaries.

  • I'm going to disable selection.

  • So when you hover over it, it no longer, it's no longer hoverable, and the only thing that's left that's hoverable should be the places.

  • But we can't see anything yet, okay?

  • And so let me just kind of play with this a little bit, so now we can then see all the layers together, okay?

  • So what I'm going to do is I'm just going to turn off the opacity here.

  • So you can see the border now.

  • I'm going to make the roads as thin as possible.

  • I'm going to make the buildings, let's go with a gray, and then I'm going to get rid of the borders.

  • And I'm able to go through this because I'm familiar with this data, obviously.

  • As you kind of play with this type of data, you'll get more and more familiar with it.

  • And then let me make the places pop by making them red for now.

  • Let me get rid of the border.

  • And then I'm going to turn this into a circle, so I can change them, and then drag place place over to detail to disaggregate it again.

  • And now we can play with the shape, or the size, like so.

  • So far, so good?

  • Oh, it's counting down.

  • Okay.

  • So I have like 15 minutes.

  • Okay.

  • Anyways.

  • We can keep on playing with this.

  • Okay.

  • So for example, like, so if I wanted to really make this pop, let me change the worksheet to black, right?

  • To dark mode, right?

  • So obviously, I think I tend to kind of steer towards dark mode, because it's helpful for me, like, it's easier for me to kind of make things pop.

  • Like, you just make these things, the place is yellow, and it can just pop off of dark mode, right?

  • But obviously, you know, we don't want all of our maps as dark mode, right?

  • Like, you know, so obviously, you know, you have to kind of spend a little time playing with the colors and things like that.

  • Let's stick with none for now.

  • Okay.

  • So feel free, like, if you have any suggestions, things like that, feel free to kind of shout them out.

  • Okay?

  • All right.

  • So one of the things I wanted to show you today is the idea of multiple layers.

  • So I already have the places or the attractions in the map as a layer, right?

  • But what I can do is actually, I can add the places again, as another layer, right?

  • Make them circles, and then disaggregate them by place again, so they, okay.

  • And now I have two circles on top of each other.

  • Okay?

  • So what I can do, possibly, is let me see, I'll play with it.

  • So these are places also, but places, too.

  • Okay.

  • So these are the top, so the layers are kind of in order, right?

  • From top to bottom, right?

  • So this is the place layer that's on top right now.

  • Let me make that now I'm just, like, winging it now.

  • So I apologize.

  • Actually, I'm going to stick with, let me stick with dark mode, because it will be easier for you to see it.

  • Maybe this one.

  • Okay.

  • And I'm going to turn off buildings for now.

  • Okay?

  • So I made the top layer yellow.

  • Circles.

  • Okay?

  • I'm also going to make the top layer the same color yellow, but I'm going to make them a little bigger.

  • Okay.

  • Now you can't see it, but let me change the opacity here to 50%.

  • Like so.

  • And this kind of starts getting at that kind of firefly type effect, right?

  • I can also, like, so I have some, like, custom shapes.

  • So let me add a shape here.

  • I have this, I have a bunch of shapes, but, and pretty disorganized, but I have this little shape right here.

  • I don't know if you can see it.

  • It's like a circle, but it fades out as you go out.

  • Okay?

  • So I created this in Figma, for those of you who are familiar with Figma.

  • I'm going to select this, this kind of, this shape there.

  • And then once we put that in there, I'm going to choose a brighter yellow.

  • So I hope you're starting to see something.

  • Okay.

  • So this is the outside.

  • Let me redo this.

  • Oh, I know why.

  • Sorry.

  • My bad.

  • I think this one has the border, too.

  • Actually, let me make this one white, and you can start seeing it a little bit.

  • Should be.

  • What's going on?

  • Of course, these demos never work well, right?

  • I planned this, and they never work well.

  • Okay.

  • But hopefully, you get the idea.

  • I don't know why it's not working right now.

  • Okay.

  • Let me change the roads to maybe a gray, a little darker.

  • Like so.

  • Okay.

  • And then I want the dark.

  • Okay.

  • Let's put the buildings back.

  • Right?

  • And so this is the start, right?

  • And hopefully, you're kind of getting a sense of when we use map layers, right, they're free, so we can overlay things on top of each other, right?

  • We can play with each of those layers.

  • So in this case, what I was trying to do is I had two layers of the tractions on top of each other, and I was trying to vary the opacity and the color for each of them to kind of create this effect where they kind of pop, right?

  • And things like that.

  • And then once we put it on the dashboard, we can kind of arrange things.

  • So let me start creating a dashboard here.

  • I'm going to fix it 800 to 1,000.

  • Like so.

  • And then I'm just going to bring this in.

  • Like that.

  • Okay.

  • And what I often do is I'll shrink it a little bit.

  • And then kind of try to size it the way...

  • Hopefully, Tableau one day will be able to have a way to kind of measure the exact scale that we're looking at.

  • But for now, we can just kind of play with it a little bit.

  • And play with kind of the positioning and things like that.

  • Obviously, we can shift it a little bit depending on where the rest of our viz is and stuff like that.

  • And once I do that, I turn off these map options.

  • Because in this case, I don't want the reader to be able to search.

  • Because if they search for Ottawa, where I'm from, or Europe, a country in Europe, the map's going to go there, right?

  • But in this case, I want the map to lock.

  • And so once I kind of have set the position of the map, I'm just going to turn off all the map options.

  • Like so.

  • And then once we do that, it locks in place.

  • Right?

  • And then when you upload it to the cloud, and in this case, Tableau Public, when a user's scrolling on the map, it won't scroll with their mouse cursor.

  • It will just be locked in place.

  • Okay?

  • So once you do that, you know, so, you know, that's part of like, you know, trying to figure out the positioning, the balance, right?

  • And then getting rid of some of the defaults, right?

  • We don't need the search tool in this case.

  • We don't need the user to zoom in and things like that.

  • We don't want them to do that.

  • We want them to look at the map and kind of figure out the story from that, right?

  • Okay.

  • So I'm going to end there.

  • I have about eight minutes.

  • If there are any questions.

  • Yeah?

  • Are you using roads for like geographic data, like states, so you can see Texas next to Maine and things like that?

  • To display them?

  • Okay.

  • I don't quite understand the question.

  • So try...

  • Let's say you have a map of the U.S. and you put the state on the road.

  • It'll separate like, pull up the map basically.

  • Right.

  • So you can see the state of Texas separately, that it's a geographic name.

  • I...

  • Like, so what's the end result that you want?

  • So like, let's say you have a sales geography, and they're not geographic names.

  • Right.

  • So you can see the state of Texas separately, that it's a geographic name.

  • Right.

  • So you can see the state of Texas separately, that it's a geographic name.

  • Right.

  • So you can see the state of Texas separately, that it's a geographic name.

  • Right.

  • So you can see the state of Texas separately, that it's a geographic name.

  • Right.

  • So you can see the state of Texas separately, that it's a geographic name.

  • Right.

  • She wants to see them next to each other.

  • Yup.

  • But US maps doesn't do a good job of that.

  • Right.

  • You have the gap.

  • Yup.

  • So, or like, separate countries.

  • Mm-hmm.

  • So do you want to see...

  • So if...

  • You're saying, like, if the user wanted to go to a certain state, you'd be able to zoom in like that?

  • Right.

  • You can't do actions.

  • Oh, yeah.

  • Yeah.

  • Oh, yeah.

  • Yeah.

  • So, like, if you're on the Mapbox platform, right, and so once you upload it, the user will be able to...

  • Like, so let's say you had a map of the United States.

  • You plop it in.

  • It's going to be projected on top of the Mapbox platform.

  • Right.

  • And it will operate the same exact way as you would if you just simply moved in, like, the geography...

  • Like, the state geographic field onto the view.

  • Right.

  • So what I...

  • Hopefully is the key takeaway from all of this is the idea that when you bring in your own files, you have a little bit more control over how the map looks.

  • And if that's something of interest to you, right, then this is, you know, what you can do in Tableau.

  • Does that help answer your question?

  • Sure.

  • Yeah.

  • Yeah.

  • Yeah.

  • Yeah.

  • Yeah.

  • Yeah.

  • Yeah.

  • Yeah.

  • Yeah.

  • Yeah.

  • Yeah.

  • Yeah.

  • Yeah.

  • Yeah.

  • Yeah.

  • Yeah.

  • Yeah.

  • Yeah.

  • Yeah.

  • Yeah.

  • Yeah.

  • Yeah.

  • Yeah.

  • There's a bunch of...

  • I find my data, like, in various places.

  • So the Census Bureau has a lot of shapefiles.

  • Specifically about the United States.

  • There are other sites...

  • Like, sometimes I'll just Google.

  • Like, I need a shapefile of a certain country, you know, and then there's probably sites like that.

  • So Humanitarian Exchange is another site.

  • Natural Earth is a place where you can get, like, world maps and things like that.

  • Yeah.

  • Okay.

  • So the maps...

  • All the maps in this presentation, you can kind of access them through that QR code.

  • My Linktree QR code is right there as well, if you're interested in getting connected, and if you have any questions beyond that.

  • Okay.

  • Well, thank you so much, everybody.

  • Thank you.

  • Thank you.

Hello, everybody.

Subtitles and vocabulary

Click the word to look it up Click the word to find further inforamtion about it