Mapping of Language Student Locations using Bing Maps

  1. What do our language students call home? Based on a pivot-table that counts zip codes, let Bing Maps tell you, a default add-in easily accessible in the insert section of the ribbon:
  2. image
  3. Note a Limitation: Bing Maps max 100 data points. image
  4. So we limited to zip codes with at least 15 students (which returns just below 100 zip codes).
  5. Also note, the Bing maps app cannot be increased beyond a certain size (below is the maximum).image
  6. Finally, note  that the visualization does have a weight indicator, but it seems imperfect:
  7. image
  8. clip_image001
  9. Here is how data (type) input errors get handled (duplicates override the original):
  10. image
  11. Fix your data, the reload from the upper right unfoldable menu: imageimage
  12. Voilà: image
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: