Mapping UFO Sightings in the Western United States with Microsoft Power Map and Excel.

image

Well, it’s Friday again and it is always fun to take different datasets and see what we can do with them.  This time I found a database of UFO sightings from the National UFO Reporting Center (www.ufocenter.com). 

I used Microsoft Excel 2013 and the Power Query add-in to pull in data from the UFO database.  I selected the western states because I didn’t want to spend all the time setting up the queries even though it is just a cut and paste of a URL.

image

Once the data was imported, I could quickly insert a Power Map via Excel.  Since I’m dealing with UFO’s, I thought it would be best to create a dark theme.

image

Let’s remove the Excel shell so we can just look at the map at night.

image

Let’s drill down a little more into the Seattle area where I live.  I live in a city called Sammamish and sure enough, someone right near me reported seeing a UFO!

image

Let’s pull back and show a heatmap with the density’s of reports.  That reflects where the concentrations are.

image

I’m going to have to pull all the data and map the rest of the United States later.  This was pretty insightful.

Enjoy, Patrick

PS:  Email me any questions you may have.

2 thoughts on “Mapping UFO Sightings in the Western United States with Microsoft Power Map and Excel.

  1. Chalmers Ingersoll February 6, 2015 / 4:59 pm

    that is cool 

    Sent from Yahoo Mail on Android

    From:”HUSTING’s COOLBI” Date:Fri, Feb 6, 2015 at 10:04 Subject:[New post] Mapping UFO Sightings in the Western United States with Microsoft Power Map and Excel.

    Patrick Husting posted: ” Well, it’s Friday again and it is always fun to take different datasets and see what we can do with them.  This time I found a database of UFO sightings from the National UFO Center.  I used Microsoft Excel 2013 and the Power Query add-in to p”

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