Custom Geocoding

Loading...

En provenance du cours de University of California, Davis

Visual Analytics with Tableau

554 notes

University of California, Davis

Visual Analytics with Tableau

554 notes

Cours 3 sur 5 dans Specialization Data Visualization with Tableau

In this third course of the specialization, we’ll drill deeper into the tools Tableau offers in the areas of charting, dates, table calculations and mapping. We’ll explore the best choices for charts, based on the type of data you are using. We’ll look at specific types of charts including scatter plots, Gantt charts, histograms, bullet charts and several others, and we’ll address charting guidelines. We’ll define discrete and continuous dates, and examine when to use each one to explain your data. You’ll learn how to create custom and quick table calculations and how to create parameters. We’ll also introduce mapping and explore how Tableau can use different types of geographic data, how to connect to multiple data sources and how to create custom maps.

À partir de la leçon

Mapping

In this final module, we will go more in depths about maps within Tableau. You will be able to connect to a different data sources and customize your maps by changing colors, shapes, and sizes. You will be able to custom geocode a map and create Tableau maps with geographic data that is not recognized by Tableau. You will also be able to create dual layer maps and showcase how to overlay maps on top of one another.

Introduction to Mapping0:55

Working with Geographic Data1:38

Shapes, Colors, and Sizes3:02

Custom Mapping Techniques3:10

Custom Geocoding3:45

Dual Layer Mapping3:01

Rencontrer les enseignants

Suk S. Brar, M.B.A.
Lead Business Consultant
Blue Shield of California

[MUSIC]

Hi there.

When talking about maps, sometimes the location data you have might be

incomplete, or have an error, or may not be recognized by Tableau as a location.

So for this lesson, I will show you how to customize your location data to create

Tableau maps with geographic data not recognized by Tableau.

[MUSIC]

Let's begin by opening our Supersore data set, and

dragging our City field to our view.

Now, although our map does show cities across the United States, as we can see

from the bottom right-hand corner of our screen, there are many unknown locations.

Sometimes Tableau will not recognize one or

more of certain location names in your data.

When this happens,

those values are marked as unknown in the lower right corner of the view.

This often happens because your data values may be spelled incorrectly, or

used an abbreviation that Tableau does not recognize.

When this happens,

you can edit the unknown location names to map to known locations.

To edit these unknown locations, let's left-click on this notice.

And now we have options to fix our unknown city locations.

We can choose to edit our locations and correct the unknown locations,

filter date and exclude the special values from our view and calculations, or

show data at default position, and show the unknown values as zeroes.

Let's click on Edit Locations.

In the Edit Locations dialogue box, click on one of the unrecognized cells

to match a known location in your unknown data.

When you click on an unrecognized cell, a search box appears.

As you begin typing in the search box,

Tableau generates a list of possible locations.

Select a location from the list.

Alternatively, you can select Enter a Latitude and Longitude from the drop

down menu to manually map the value to a location on the map.

Both unrecognized and

ambiguous locations can be listed in the Edit Locations dialogue box.

You can usually fix ambiguous locations by specifying the country or region,

and/or State or Province options in the geographic role section

of the Edit Locations dialogue box.

Since we have several cities that are ambiguous,

let's click on the State/Province drop-down menu.

And click on From Field, and choose State as our field.

Now Tableau has identified the missing locations.

Now if we click on OK, you will notice that we no longer have unknown cities.

So far in this course, we have covered what types of geographic data Tableau

allows you to use to create maps.

How to connect to a different data source that may hold geographic

data that you may want to use in your analysis.

How to customize your map by changing colors, shapes, and sizes.

And how to customize your map background.

And create Tableau maps with geographic data not recognized by Tableau.

Now, to help refine your skills,

please remember to continue to practice everything you are learning.

Go back through everything you have learned in this module, and

try to explore ways to expand on what you are learning.

In the next lesson, we will cover dual layer mapping, and

how to overlay maps on one another.

See you next time.

Explorer notre catalogue

Rejoignez-nous gratuitement et obtenez des recommendations, des mises à jour et des offres personnalisées.

Coursera propose un accès universel à la meilleure formation au monde, en partenariat avec des universités et des organisations du plus haut niveau, pour proposer des cours en ligne.

© 2018 Coursera Inc. Tous droits réservés.

Télécharger dans l'App Store

Disponible sur Google Play