MAPPED: Great visual where the S&P500 companies are headquarters using @mspowermap #vis

image

I used PowerQuery to pull a list of the S&P 500 companies and mapped them using PowerMaps in Excel.  You can see a vast majority of companies are HQ’d in New York.  The color codes are by Industry Sector.

Northeast

image

Midwest

image

South

image

Southwest

image

Pacific Northwest

image

Even a few in Europe

image

If you want a copy of the file, just direct message me and I would be happy to email you the file.

Enjoy, Patrick

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.

Power Map and XBOX–Video Game Analytics within the game…

I remember some past discussions about finding kill boxes in Halo where in test people tended to get crushed in a certain area of the game so they would adjust the map so it wouldn’t be that hard.  Now using power maps, you can put in your own custom background and map the geo-code data right on top.  I love that.

Enjoy, Patrick